Welcome To Genesee Academy, World Class Training, Data Vault Modeling

Data Modeling for the Operations, Data Warehouse and Business Intelligence.

This course covers the core principles of data modeling through lectures and hands-on labs and exercises.  Providing a solid overview of current techniques specifically for operational systems, data warehousing deployments, and business intelligence data modeling.

In covering these areas, the course considers data modeling and design using both normalized data modeling (3^rd Normal Form) and dimensional modeling (Star Schema).  The course will start with the core fundamentals of database design including identifying the core entities, the relationships, logical model design, defining attributes and key structures, and developing entity relationship diagrams (ERDs).  Within the scope of this modeling approach, the lessons will cover business rules, normalization, validation rules, reference tables, key constraints, identifying and non-identifying relationships, recursive relationships, redundancy, subtypes and supertypes, and relationship cardinality.  Students will become comfortable with the core rules and best practices approach to 3^rd NF modeling.

The training will continue with the fundamentals of dimensional data modeling based on current best practice interpretations of the Kimball Star Schema dimensional modeling approach.  First lessons will begin with the fundamentals of dimensional modeling including the purpose and structure of Facts and Dimensions, denormalization, the concept of Slowly Changing Dimensions (SCDs) and the main Dimension Types (Type 2 and also covering Type 0, 1, 3, 4 and 6), and then the modeling and design of solid dimensions and encouraged forms of Star Schemas.  The course continues with defining and designing Snow Flake models, the encouraged and acceptable practices for deploying these concepts.  Lastly, the course will cover physical data model considerations and DW/BI deployment topics. 

The Target Audience for this class includes Business Analysts, Data Analysts, DWBI Managers, Data Architects, and Database/Data Warehouse Designers.  Note that unlike other data modeling courses, this course takes a global view of database across the organization to include the enterprise initiatives (data warehousing and business intelligence).