Power BI for Excel 2019/2016 Part 2 Data Model Design

Planning Information

The duration of this course is 1 Day. The list price is $495.00.


This is the second course in our Power BI Using Excel series. What makes Power BI such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Excel 2016 Report Users.


Excel Levels 1, 2  and 3 including PivotTable and Pivot Chart skills plus a basic understanding of database concepts along with the first course in our Power BI using Excel series (or equivalent knowledge).


Digital courseware

Course Outline

1. Understanding BI Data

  • Business Intelligence Data
  • Data Source Types
  • Table Roles
2. Creating Data Models 
  • Creating the Data Model - Excel 
  • Creating the Data Model – Database 
  • Creating the Data Model – Hybrid 

3. Creating DAX Functions 

  • Review of Syntax and Calculated Columns 
  • Best Practices 
  • DAX Measures 
  • Creating Measures(Calculated Fields) 
  • Page Break 

4. Dates and Hierarchies 

  • Building Date Tables 
  • Building Date Hierarchies 

5. Shaping Reports

  • Building Communication Worksheets
  • Controlling Item Ordering
  • PowerPivot Metadata

Pin It on Pinterest