AllFusion® ERwin® Data Modeler: Dimensional Modeling

Overview:

AllFusion® ERwin® Data Modeler: Dimensional Modeling provides a solid foundation for development of data marts and data warehouses by presenting fundamental concepts and special features of AllFusion® ERwin® Data Modeler. The course includes physical and logical modeling of data marts, creating a data warehouse architecture, tracking data sources, developing data movement rules, and reporting. It also introduces concepts from Design Layer Architecture and demonstrates a step-by-step approach to data warehouse design.

Description:

Who Should Attend:

Data Administrators
Data Architects
Enterprise Architects

Prerequisites:

AllFusion® ERwin® Data Modeler: Introduction (ERB110) (4 Days)
AllFusion® ERwin® Data Modeler: Advanced (ERB120) (2 Days) 

You Will Learn How To:

Define dimensional modeling terms
Describe and recognize components of a star schema model
Build star schema data mart models in AllFusion® ERwin® Data Modeler using
A data warehouse architecture
Fact and dimension tables
Data warehouse rules
Data source tracking
Course Activities:

Case Studies
Demonstrations

For Managers:

To ensure accurate and consistent data for your data warehousing needs, your technical team will learn the skills needed to successfully create physical and logical dimensional models and a data warehouse architecture, track data sources, and develop data movement rules. Through demonstrations, they will learn a step-by-step approach to data warehouse design that will assist them in building a sound foundation for your enterprise's data mart, or warehouse.

Course Agenda
Module 1 Defining Dimensional Models

Lesson 1: Understanding Dimensional Modeling
Lesson 2: Differentiating Dimensional Models from Transactional 

Module 2 Modeling the First Data Mart

Lesson 1: Activating Dimensional Modeling
Lesson 2: Choosing the Facts & Deciding Granularity
Lesson 3: Analyzing Requirements for Dimensions

Module 3 Developing a Data Warehouse Architecture

Lesson 1: Continuing the Design: Top-Down or Bottom Up?
Lesson 2: Working with Conformed Dimensions
Lesson 3: Tracking Data Sources
Lesson 4: Creating Dimensional Modeling Standards

Module 4 Growing the Data Warehouse

Lesson 1: Adding Another Data Mart
Lesson 2: Improving the Architecture
Lesson 3: Completing the Physical Data Model
Lesson 4: Communicating the Design