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

Our classes are always live and instructor led from our Exton, PA or EPIC Partner locations. Springhouse AnywhereLive options require Internet Access. Select classes are Guaranteed to Run (GTR). View our complete schedule policies.





18096a55-6aa8-e711-8b1b-00155d0a14062018-05-07T08:00:00Z2775.000000000000511:00 AM7:00 PMAnywhereLive18096a55-6aa8-e711-8b1b-00155d0a1406
c3bb0737-2726-e811-87a1-00155d0a14062018-07-09T08:00:00Z2775.000000000000511:00 AM7:00 PMAnywhereLivec3bb0737-2726-e811-87a1-00155d0a1406
c4bb0737-2726-e811-87a1-00155d0a14062018-09-10T08:00:00Z2775.000000000000511:00 AM7:00 PMAnywhereLivec4bb0737-2726-e811-87a1-00155d0a1406
c5bb0737-2726-e811-87a1-00155d0a14062018-10-29T08:00:00Z2775.000000000000511:00 AM7:00 PMAnywhereLivec5bb0737-2726-e811-87a1-00155d0a1406
c6bb0737-2726-e811-87a1-00155d0a14062018-12-17T10:00:00Z2775.000000000000511:00 AM7:00 PMAnywhereLivec6bb0737-2726-e811-87a1-00155d0a1406


​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. Second day topics include creating Power Views with Excel, Power Map, and Power Query. Third day topics include database design concepts, how to build both general purpose and customized data models, and how to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information. Fourth and fifth day topics covered in this class include Relational functions, Date functions, Banding, Ranking, advanced Slicer techniques, plus using DAX as a query language for customized analysis.

Intended Audience

At Completion


​Excel levels 1 & 2, including PivotTable & Pivot Chart skills; plus a basic understanding of database concepts.

Exams & Certifications


Course Outline

Lesson 1 : Introducing PowerPivot

What Is PowerPivot?
PowerPivot Key Features
The Self-Service BI Model
PowerPivot Components


Lesson 2 : Defining a Report

What is a PowerPivot Report?
Defining a Report
Data-Driven Storytelling


Lesson 3 : Understanding PowerPivot Data

Data Terminology
Understanding Tables
Understanding Relationships
Diagnosing Data Models
Data Model Schemas


Lesson 4 : Create Reports using PowerPivot Data

Making Changes to PowerPivot Data
Creating PowerPivot PivotTables
Creating PowerPivot PivotCharts
Creating Slicers
Graphing Data


Lesson 5 : Understanding PowerPivot Functions

Calculated Columns
What is DAX?
Understanding DAX Functions
Common DAX Functions
Dates and Date Functions


Lesson 6 : Introducing Power BI Tools

Microsoft’s Self-Service Power Bi Model
What Is Power BI for Excel


Lesson 7 : Power View for Excel 2016

What Is Power View?
Planning Power View Reports
Creating Power View Reports
Power View Interface Components


Lesson 8 : Understanding Chart

Understanding Table Visualizations
Chart Visualizations
Additional Power View Features
Power View Tiles
Power View Slicers


Lesson 9 : 3D Maps for Excel 2016

What are 3D Maps?
Preparing a 3D Map Tour
3D Maps Designer
Creating a 3D Maps Tour
3D Maps Formatting Tools
Finalizing a 3D Maps Tour


Lesson 10 : BI Data Queries in Excel 2016

What are BI Data Queries?
Planning BI Data Query
Creating a BI Data Query


Lesson 11 : Understanding BI Data

Business Intelligence Data Sources
Data Source Types
PowerPivot Data Sources


Lesson 12 : Creating Data Models

Creating a Data Model - Excel
Creating a Data Model - Database
Creating a Data Model - Hybrid


Lesson 13 : Use DAX Functions

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


Lesson 14 : Using Dates Correctly

Why Dates are Different
Building Data Tables
Building Data Hierarchies


Lesson 15 : Shaping Reports

Building Communication Worksheets
Controlling Item Ordering
PowerPivot Metadata


Lesson 16 : Basic DAX Functionality

Review Of Calculated Column
PivotTable Function
Review Of Measure
Rules Of DAX Measure
Evaluation Context
Formatting DAX Code


Lesson 17 : Controlling Content & Values

Controlling Values
Switch Function
Error Handling


Lesson 18 : Context Control Functions

Filter Function
All Function
Iterative Functions
Earlier Function
Calculate Function
Additional Uses Of The All Function


Lesson 19 : Contexts In Relationships

Working With Many Tables
Row Context & Relationships
Filter Context & Relationships
Values Function


Lesson 20 : Advanced Concepts

Circular Dependencies
Controlling Totals
Advanced Hierarchy Concepts


Lesson 21 : Time Intelligence Calculations

Working With Date Tables
Calculating Operating Periods
Working With Missing Periods
DAX Date Functions
Advanced Date Functions
Prior Year Functions
Moving Averages


Lesson 22 : DAX Dashboard Techniques

Parameter Tables
Advanced Slicer Techniques



Power BI for Excel 2016 - Report Builders, Power BI Tools, Data Model Designers, and DAXhttp://springhouse.com/course-catalog/TLG_PowerBIExcel2016AllPower BI for Excel 2016 - Report Builders, Power BI Tools, Data Model Designers, and DAX

Get More Information




Help us prove you're not a robot:

 ‭(Hidden)‬ Catalog-Item Reuse

Microsoft Gold Partner


AXELOS Limited

The Microsoft Gold CPLS logo is a mark of Microsoft, Inc.

The PMI R.E.P. logo is a mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited.
IT Infrastructure Library® is a registered trade mark of AXELOS Limited
The Swirl logo™ is a registered trade mark of AXELOS Limited
Accredited course material is property of ITSM Academy.

Connect with us

Springhouse Education & Consulting Services

Corporate HQ:Eagleview Corporate Park
707 Eagleview Boulevard
Suite 207
Exton, PA 19341

610-321-3500 - info@springhouse.com