Data Modeling for Managers and Executives
Objectives
The objectives of the course are to:
- Demonstrate to managers and executives the concepts and processes used in logical data modeling
- Explain how analyst approach an enterprise or business area, identifying data components and relationships among them
- Show how analysts model data for an enterprise and represent it via entity-relationship diagrams
- Understand design compromises among flexibility, performance, ease of use and cost
- Understand considerations for the physical database design
Seminar Content
Course Topics
- Roles, Definitions and Key Principles
- Critical role of the business analyst / data analyst in the enterprise
- Creating and adopting a formal enterprise modeling strategy
- Roles and mutual expectations among team members of an enterprise data modeling project
- Capturing Requirements for Data Modeling
- Identify critical consumers
- Understand the structure of a Data Model
- Types of Requirements
- Attributes and types of enterprise requirements versus application requirements
- Review of Data Modeling Concepts and Principles
- Phases of application development
- Importance of building data models
- Overview of the types of data models
- The Data Modeling Process, An Overview
- Relationship types
- E-R diagrams and how to read them
- Keys in Enterprise Data Modeling
- Normalization for the enterprise
- Patterns in Data Modeling
- Addressing missing data and data redundancy
- Issues and Challenges for Data Modeling and Data Analysis
- Workshop Summary, Additional Exercises and Reference Materials
To learn more about how EWSolutions can provide our World-Class Training for your company or to request a quote, please feel free to contact David Marco, our Director of Education at DMarco@EWSolutions.com