Advanced Dimensional Data Modeling

This course describes the fundamentals of business intelligence in the organizations to bring a business value. One of the important component of the data warehousing systems is the data modeling. The fundamentals of the data modeling will be covered and you will find the advanced data modeling techniques. The modeling techniques that will be covered are based on Kimball’s Dimensional Data Modeling.

About the instructor Cuneyt Yilmaz

Cuneyt is working as senior instructor and consultant with specialty in Analytics, Business Intelligence, Data Management and Performance Tuning. He is a certified trainer for Microsoft and Oracle, and he also delivers training on MongoDB.

Cuneyt is based in Istanbul but has been working with customers in 35 countries across the Nordics and EMEA over the last 15 years. He combines top technology skills with his kindness and strong pedagogical skills. We dare to say, nobody leaves Cuneyt`s classroom disappointed! 

Private event training

We arrange this training for your company or departement upon request. Please contact us for dates and prices: itpro@glasspaper.no

Course content

 

Module 1: Fundamentals Data Warehousing and Business Intelligence

a. Data Source Types
b. Importance of Business Intelligence

Module 2: Introduction to Dimensional Modeling

a. Overview
b. Star Schemas vs OLAP Cubes
c. Information Pyramid
d. Measurements & Observations in Fact Tables
e. Descriptions in Dimension Tables

Module 3: Fact & Dimension Table Techniques

a. Fact Table Structure
b. Additive, Semi-Additive and Non-Additive Facts
c. Transaction Facts
d. Conformed Facts
e. Dimension Table Structure
f. Keys for Dimension Tables
g. Descriptive Dimension Tables
h. Calendar Date Dimensions
i. Role Playing Dimensions
j. Snowflake Dimensions
k. Outrigger Dimensions

Module 4: Slowly Changing Dimensions

a. The need for Slowly Changing Dimensions
b. Types of SCD

Module 5: Dimension Hierarchies

a. Hierarchy Types
b. Ragged Hierarchies

Module 6: Advanced Modeling of Fact Tables

a. Usage of Surrogate Keys
b. Numeric Columns
c. Snapshots
d. Duration Facts
e. Header – Detail Fact Tables
f. Usage of Multiple Units and Multiple Currencies
g. Time Series Calculations

Module 7: Advanced Modeling of Dimension Tables

a. Relations between Dimension Tables
b. Using Bridge Tables
c. Summarized Columns as Dimension Attributes
d. Step Dimensions
e. Swappable Dimensions
f. Heterogeneous Dimensions