BI - Dimensional Modelling

To unleash the power of your BI tools with solid and rich data models, whether it is a data warehouse or an in-memory model. A good data model will allow a BI solution to grow and adapt to future needs. The approach focuses on identifying the key business processes within a business and modeling and implementing these first before adding additional business processes, as a bottom-up approach

Retail Price: $1,300.00

Next Date: Request Date

Course Days: 2


Request a Date

Request Custom Course


After taking this class you will be able to: 

-Create a solid dimensional model. 

-Use best practices to create a model for common needs regardless of the BI tool or technology used. 

-Identify future BI needs.

-Understand what BI has to offer and be prepared to work beyond BI. 

 

About the Trainer Guil Carmargo

-BI and data warehouse consultant since 1999

-Microsoft Certified Trainer since 1995

-Data warehouse and BI experience on projects with companies including Potamkin Automotive, EasyJet, University of Oxford, and Toyota among others. 

 

 


Course Outline

 

MODULE 1: Introduction to BI

What is BI

Beyond traditional architecture

BI Tools

Future BI

Lab 1: Explore a BI solution  

 

MODULE 2: Dimensional Modelling

Measures

Dimensions (Attributes, Hierarchies)

Measure Types

Star - Snowflake

Lab 2: Create a dimensional model    

 

MODULE 3: Facts

Grain

Types of facts

Fact-less facts

Lab 3: Identify grain and facts  

 

MODULE 4: Dimensions

Keys and unknown values

Date and Time

Mini Dimensions

Dimension Types

Degenerate

Junk

Range

Self

Other Type

Lab 4: Design dimensions

 

MODULE 5: Enterprise Modelling

Master Data

Data Quality

Conformed Dimensions

Bus Matrix  

Lab 5: Create an enterprise model  

 

MODULE 6: Advanced Modelling

Slowly Changing Dimensions

Multiple facts

Many to many relationships

Bridge tables

Multi-value Dimensions

Lab 6: Work with multiple fact tables  

 

MODULE 7: Beyond Dimensional Modelling

Help businesses make better decisions

Other data models

BI

Benchmarking

Optimization

Data Science

Innovation

Introduction to Creativity and Innovation

Lab 7: Innovate in BI    

 

MODULE 8: How to innovate in BI  

BI way of thinking

How to be creative and innovative

Creativity enhancing techniques

Lab 8: Innovate in BI  



Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com


Request a Date