Data Modeling - Advanced (3 d)

 Training Content

In this training class you will learn how to adjust a data model that allows complex analyses and computation of business 

numbers by implementing DAX measures that are easier to write. 

• Introduction

 ○ Single Tables

 ○ Multiple Tables

 ○ Star Schema

 ○ Snowflake Schema

 ○ Naming Conventions

• Header & Detail Tables

 ○ Introduction

 ○ Aggregations on Header Level

 ○ Bi-directional Filtering

• Multiple Fact Tables

 ○ Denormalized Fact Tables

 ○ Filter Across Dimensions

 ○ Orders & Invoices

• Dates & Time

 ○ Creating a Date Dimension

 ○ Automatic Date & Time Dimensions

 ○ Working Days

 ○ Special Periods of the Year

 ○ Weekly Calendars

• Tracking Historical Attributes

 ○ Introduction to Slowly Changing Dimensions (SCD)

 ○ Using SCD

 ○ Loading SCD's

• Working with Different Granularity

 ○ Introduction

 ○ Relationships at different granularity

 ○ Analyzing budget data

 ○ Using DAX code to move filters

 ○ Filtering through relationships

 ○ Hiding values at the wrong granularity

 ○ Allocating values at the higher granularity

• Working with Multiple Currencies

 ○ Multiple source currencies, single reporting currency

 ○ Single source currency, multiple reporting currencies

 ○ Multiple source currencies, multiple reporting currencies

• Many-to-Many Relationships

 ○ Introduction

 ○ Understanding the bi-directional pattern

 ○ Understanding non-additivity

 ○ Cascading many-to-many

 ○ Temporal many-to-many

 ○ Reallocating factors and percentages

 ○ Materializing many-to-many

 ○ Using fact tables as a bridge

 ○ Performance considerations

 Goal

You will use the Contoso Demo database, a fictious company that sells electronics all over the world, through different sales channels. Of course,  the examples provided in this training class need to be translated into your own specific business model, but most likely there will be significant similarities between what you learn and what you need to realize in your own data model. 

 

 Prerequisites

Own Laptop 💻 + external mouse  

Power BI Desktop (see Microsoft's documentation Get Power BI Desktop). 

You can get Power BI Desktop in two ways, each of which is described in the following sections:

• Install as an app from the Microsoft Store.
• Download directly, as an executable you download and install on your computer.

 

📖 Documentation

Students will get 2-year access to the on-line in2Facts documentation platform

🚫 Cancellations

Cancellations up to 8 days before the training course are at no charge. 

Cancellations after this date, as well as no-shows, will be liable for the full registration fee.