Data Modeling for Power BI

Amsterdam, NL

Sorry, the course is sold out.

Good news, there is an open class in the same country:

Data modeling is a required skill to get the best out of Power BI, Power Pivot for Excel, and Analysis Services. The training is aimed at users of Power BI Desktop or Power Pivot for Excel, and at Analysis Services developers who want to learn how to build the optimal data model for their reporting needs.

This three-day workshop is a practical introduction to the concepts of data modeling for Power BI, Analysis Services Tabular, and Power Pivot.

The goal of the course is to teach through examples of increasing complexity how to solve business scenarios by adapting the data model, so that the required DAX code becomes easier, faster and more robust. All the demos and the exercises are based on Power BI examples. However, the very same concepts can be applied to Power Pivot and Analysis Services Tabular.

The course includes hands-on labs: you will make practice using your own notebook.

Topics

  • Introduction to data modeling
  • Basic modeling techniques
  • Dimensional modeling
  • Snowflakes and complex models
  • Using header / detail tables
  • Order and order details
  • Data models with multiple fact tables
  • Sales and purchase
  • Working with date and time
  • Aggregations and comparisons
  • Working days calculations
  • Handling special time periods
  • Week-based calendars
  • Tracking historical attributes
  • Slowly changing dimensions
  • Rapidly changing dimensions
  • Analyzing date, time and intervals
  • Events with a duration
  • Using many-to-many relationships
  • Managing tables with different granularities
Data Modeling for Power BI Outline (PDF)

Prerequisites

To get the most out of the workshop, attendees should be familiar with the user interface of Power BI Desktop to import data, create relationships, edit queries, define measures and calculated columns. Previous knowledge of data modeling concepts is not required.

DAX knowledge is welcome and may improve the workshop experience. We strongly suggest to review the free Introducing DAX video course before attending the course.

Location

BCN Amsterdam Arena

Atlas Arena Complex, Gebouw Azië - 5e etage, Hoogoorddreef 5
Amsterdam, NL
You can reach the training center in less than 15 minutes from Amsterdam Airport Schiphol with a direct train.
View on Google Maps

Teaching this live event

Alberto Ferrari

Consultant & Mentor
Trainer for 114 other courses at SQLBI

Looking for another city?

We bring our courses to you all over the world. Here are the current scheduled classroom events.
Please note that each course is taught exclusively by SQLBI trainers in person (no external trainers are involved).
Early Bird
Discount
Bundle
Discount
Video
Discount
2019
 Amsterdam, NL Nov 26-28
Amsterdam
 Amsterdam, NL Dec 10-12
Amsterdam
2020
 Houston, TX, US Feb 5-7
Houston
 San Diego, CA, US Feb 11-13
San Diego
 Amsterdam, NL Feb 18-20
Amsterdam
 San Francisco, CA, US Mar 11-13
San Francisco
 Charlotte, NC, US Mar 24-26
Charlotte
 Munich (München), DE Mar 31-Apr 2
Munich
 New York, NY, US Apr 15-17
New York
 Amsterdam, NL May 12-14
Amsterdam
 Calgary, AB, CA May 13-15
Calgary
 Chicago, IL, US May 19-21
Chicago
 Amsterdam, NL Jun 3-5
Amsterdam
 Oslo, NO Sep 1-3
Oslo
Other locations On-Site On-Site On-Site On-Site On-Site