Data Modeling for Power BI

On-Site

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.

The course is very intense and is structured as a set of lectures and hands-on-labs with a high level of interaction with attendees. Questions are welcome and it is possible to customize examples using company-specific data models. This type of customization has to be discussed in advance, in order to prepare material, but it grants a higher level of engagement with attendees.

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

The outline may be adjusted on customer request.

Data Modeling for Power BI Outline (PDF)

Want to organize it at your company?

"I want to know more about Data Modeling for Power BI."


Don't like web forms? Send an email to info@sqlbi.com