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

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

$2,775

  • 5 Days
  • This live class is delivered online by Partner Remote

Interested in scheduling a date for this course?
Request A Date
Office 365 Training class at Interface logo
x
Course:
  • 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.

Outline

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
Audience

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

Prerequisites

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