Consulting Training Blog Careers About Us Contact Us

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

Upcoming Classes

Rows
Calender
Guaranteed to Run
To Be Determined

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
25 26 27 28 29 30 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
 
9:00 AM - 5:00 PM CST Online Only $2,775.00
 
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
30 31 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 1 2

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
27 28 29 30 31 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 1 2

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
24 25 26 27 28 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
31 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 1 2 3 4

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
28 29 30 1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31 1

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
26 27 28 29 30 31 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 1 2 3 4 5 6

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
30 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31 1 2 3

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
28 29 30 31 1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
29 30 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 1 2

Click to be notified when a date becomes Guaranteed to Run (GTR).

Dec 2018
Jan 2019
Feb 2019
Mar 2019
Apr 2019
May 2019
Jun 2019
Jul 2019
Aug 2019
Sep 2019
Oct 2019
Nov 2019
Sun Mon Tue Wed Thu Fri Sat
27 28 29 30 31 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

On Site/Private

Can't find a class that fits right for you? Contact us to inquire about scheduling your own private class

Contact Us

Upcoming Classes

Rows
Calendar
Start Date Time Location Price Classroom Live Online GTR
Dec 17, 2018 9:00 AM - 5:00 PM CST Online Only $2,775.00 Enroll Enroll
- GTR      - Not GTR
Click to be notified when a date becomes Guaranteed to Run (GTR).

On Site/Private

Can't find a class that fits right for you? Contact us to inquire about scheduling your own private class

Contact Us

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.

Bring This Course To You

For groups of 5 or more, let Intertech bring this course to your location. Customized versions tailored towards your objectives are also available.

Learn More

Prerequisites

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

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
  • Multiples

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
  • Banding
  • Ranking
  • Advanced Slicer Techniques

Free Resources from Intertech

Free On-Demand Video Bundle: IoT, Agile/Scrum, and Leadership

Free Whitepaper: Design and Code Review Checklist

Free Book Chapter: Intertech's WPF Course

X