Power BI Excel 2016 Level 1 - Data Analysis using Power Pivot and Power BI Tools

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.





939e569b-dd35-e911-9096-00155d0a14062019-09-16T08:00:00Z995.000000000000029:00 AM4:00 PMExton939e569b-dd35-e911-9096-00155d0a1406
949e569b-dd35-e911-9096-00155d0a14062019-11-11T10:00:00Z995.000000000000029:00 AM4:00 PMExton949e569b-dd35-e911-9096-00155d0a1406
959e569b-dd35-e911-9096-00155d0a14062020-01-13T10:00:00Z995.000000000000029:00 AM4:00 PMExton959e569b-dd35-e911-9096-00155d0a1406


Power BI Tools in Excel - Level 2 will learn everything they need to create highly effective PivotTable and PivotChart reports using data models created by more advanced Power BI Designers. Day one topics covered include an overview of PowerPivot, creating effective and professional reports, creating data driven narratives, effectively applying different chart styles, using data hierarchies, and creating simple custom data calculations. Day two topics include learning how to use the Power View, Power Map, and Power Query add-ins. Power BI Report Writers will learn how to use Power View to create highly effective interactive reports using data models created by more advanced Power BI Designers. Students will also learn how to build 3D geospatial reports using Power Map as well as how to transform and query data sources using Power Query.

Intended Audience

At Completion


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

Exams & Certifications


Course Outline

Day One


1. Introducing Power BI for Excel

  • What Is Power BI for Excel?
  • Power BI Key Features
  • The Self-Service Bi Model
  • Power BI in Excel
  • Power Pivot Add-In
  • Using Power BI

2. Defining a Report

  • What is a Power BI Report?
  • Defining a Report
  • Data-Driven Storytelling


3. Understanding PowerPivot Data

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


4. Create Reports using PowerPivot Data

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


5. Understanding PowerPivot Functions

  • Calculated Columns
  • What is DAX?
  • Understanding DAX Functions
  • Common DAX Functions
  • Why are Dates Different?
  • Understanding Hierarchies
  • Dates & Date Functions


Day Two


1. Introducing Power BI Tools

  • Microsoft's Self-Service Power BI Model
  • What Is Power BI for Excel


2. Power View for Excel

  • What Is Power View?
  • Creating Power View Reports
  • Power View Interface Components
  • Understanding Table Visualizations
  • Chart Visualizations
  • Power View Tiles, Slicers, & Multiples


3. Power Map/3D Maps for Excel

  • What Is 3D Map/Power Map?
  • Preparing a 3D Maps/Power Map Tour
  • 3D Maps/Power Map Designer
  • 3D Maps/Power Map Formatting Tools
  • Finalizing a 3D Maps/Power Map Tour


4. BI Data Query Basics

  • What Is a BI Data Query?
  • Planning a BI Data Query


5. Query Editor Transformations

  • Basic Transformations
  • Merging & Appending Queries
  • Calculated Columns
  • Grouping and Summarizing Data
  • Unpivoting Data
  • Dealing with Malformed Data
  • Finalizing Queries



Power BI Excel 2016 Level 1 - Data Analysis using Power Pivot and Power BI Toolshttp://springhouse.com/course-catalog/PowerBIExcel2016PowerBIToolsPower BI Excel 2016 Level 1 - Data Analysis using Power Pivot and Power BI Tools

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