home > training > PPBC2013: PowerBI for Excel 2013 – Report Builders, PowerBI Tools, Data Model Designers, and DAX Functions
Office 365 Training class at Interface logo

PPBC2013: PowerBI for Excel 2013 – Report Builders, PowerBI Tools, Data Model Designers, and DAX Functions


  • 5 Days
  • This live class is delivered online by Partner Remote
Partner DeliveryThis live class is delivered by a partner at another location. Students attend online from their home or office.
Interested in scheduling a date for this course?
Request A Date
Office 365 Training class at Interface logo
  • This field is for validation purposes and should be left unchanged.

Course Description

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.


Lesson 1 : Introducing PowerPivot

  • What Is PowerPivot?
  • PowerPivot Key Features
  • The Self-Service Bi Model
  • PowerPivot & Excel
  • PowerPivot Add-In
  • PowerPivot Manager


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
  • PowerPivot Pivot Charts
  • 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 2013

  • What Is Power View? Creating a Power View
  • Power View Interface Components
  • Additional Power View Features


Lesson 8 : Understanding Charts

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


Lesson 9 : Power Map for Excel 2013

  • What Is Power Map?
  • Preparing a Power Map Tour
  • Power Map Designer
  • Creating a Power Map
  • Power Map Formatting Tools
  • Finalizing a Power Map Tour


Lesson 10 : Power Query for Excel 2013

  • What Is Power Query?
  • Power Query Interface
  • Creating a Power 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 from Excel Data
  • Creating a Data Model from Access Database Data
  • Creating a Hybrid Data Model


Lesson 13 : Use DAX Functions

  • Review of Syntax and Calculated Columns
  • Best Practices
  • DAX Measures
  • Compound Functions, Context, & Aggregate Function


Lesson 14 : Using Dates Correctly

  • Why Dates are Different
  • Building Data Tables
  • Building Data Hierarchies


Lesson 15 : Shaping Reports

  • Building Hierarchies on Multiple Tables
  • PowerPivot Metadata


Lesson 16 : DAX Functionality Review

  • Review of DAX Columns & Measures
  • Rules of DAX Measures
  • Review Evaluation Context
  • Review CALCULATE
  • Best Practices
  • New Functions


Lesson 17 : Contexts in Relationships

  • Working with Many Tables
  • Row Context & Relationships
  • Filter Context & Relationships
  • VALUES Function


Lesson 18 : Time Intelligence Calculations

  • Calculating Operating Periods
  • Daily Calculations
  • DAX Date Functions
  • Advanced Date Functions
  • Prior Year Functions


Lesson 19 : Advanced DAX Functionality

  • Parameter Tables
  • Banding
  • Ranking


This course is designed for anyone who needs to use and analyze  PowerPivot for Excel 2103 in their reporting requirements.


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

What You Will Learn

After completing this course, students will be able to:

  • Define a Report
  • Understand PowerPivot Data
  • Create Reports using PowerPivot Data
  • Understand PowerPivot Functions
  • Power BI Tools
  • Power View for Excel 2013
  • Power Map for Excel 2013
  • Power Query for Excel 2013
  • Understand BI Data
  • Create Data Models
  • DAX Functions
  • Shaping Reports
  • Contexts in Relationships
  • Time Intelligence Calculations
  • Advanced DAX Functionality