Data Modeling for Power BI

Chicago, IL, US

Sorry, this course is closed.

Leave your email if you want to be notified when a new edition of Data Modeling for Power BI is available in United States.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

 By pressing the Notify button you are agreeing to our Privacy Policy.

Data modeling is a required skill to get the most 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 classroom course is a practical introduction to the concepts of data modeling for Power BI, Analysis Services Tabular, and Power Pivot. All the attendees will receive a copy of the book, Analyzing Data with Power BI and Power Pivot for Excel.

The goal of the classroom 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 classroom course includes hands-on labs: you will apply concepts 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 classroom course, 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.

Prior DAX knowledge is welcome and may improve your classroom course experience. It is always a good idea to review the free Introducing DAX video course prior to attending the classroom course.

Location

MTC - Microsoft Technology Center

200 East Randolph Drive, Suite 200
Chicago, IL, US
Visit https://www.microsoft.com/en-us/mtc/locations/chicago.aspx for details about hotels and drive directions.
View on Google Maps

Teaching this course

Marco Russo

 Consultant & Mentor
Trainer for 170 other courses at SQLBI

Looking for another city?

We bring our classroom courses to you all over the world. Here are the current scheduled classroom courses.
Please note that each classroom course is taught exclusively by SQLBI trainers in person. No external trainers are involved.
 Amsterdam, NL Jul 2-4
Amsterdam
 Melbourne, VIC 3006, AU Aug 9
Melbourne
 Aug 6-8
Melbourne
 Sydney, NSW 2000, AU Aug 15
Sydney
 Aug 12-14
Sydney
 Brisbane, QLD 4000, AU Aug 19-21
Brisbane
 Calgary, AB, CA Sep 18-20
Calgary
 Vancouver, BC, CA Sep 23-25
Vancouver
 London, England, GB Oct 14-16
London
 Los Angeles, CA, US Nov 12-14
Los Angeles
 Amsterdam, NL Nov 19-21
Amsterdam
 Copenhagen, DK Dec 2-4
Copenhagen
 Amsterdam, NL Dec 10-12
Amsterdam
Other locations On-Site On-Site On-Site