Power BI for Excel 2016 - Report Builders, Power BI Tools, Data Model Designers, and DAX Functions

Microsoft Technical

Find out more

Course Length: 5 Days

Delivered: Virtually


First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates.


This course is Intended for students with Excel knowledge including PivotTable & Pivot Chart skills® plus a basic understanding of database concepts.


This course takes an in depth overview of PowerPivot, creating effective and professional reports, Power Views with Excel, Power Map, and Power Query how to use basic DAX language, Date functions, Banding, Ranking, advanced Slicer techniques, plus using DAX as a query language for customized analysis.


1 - Introducing Power BI for Excel

2 - Defining a Report

3 - Understanding PowerPivot Data

4 - Create Reports using PowerPivot Data

5 - Understanding PowerPivot Functions

6 - Introducing Power BI Tools

7 - Power View for Excel

8 - Power Map/3D Maps for Excel

9 - BI Data Query Basics

10 - Query Editor Transformations

11 - Understanding BI Data

12 - Creating Data Models

13 - Creating DAX Functions

14 - Dates and Hierarchies

15 - Shaping Reports

16 - Basic DAX Functionality

17 - Controlling Content & Values

18 - Context Control Functions

19 - Contexts In Relationships

20 - Advanced Concepts

21 - Time Intelligence Calculations

22 - DAX Dashboard Techniques

Apply for this course

Leave us your email address and phone number and one of our team will be in touch to find out a bit more about you and discuss next steps.

Thank you, we'll get in touch
Oops! Something went wrong while submitting the form. Please try again or give us a call.