PBIE16PBIT: Power BI Tools in Excel 2016 – Level 2

Become an EPIC Affiliate

To view the class schedule you need to become an Affiliate

  • Largest “Guaranteed To Run” public technical training schedules available
  • Easy to become an Affiliate – no charge or fee
Become an EPIC Affiliate

already an Affiliate?  Login

About this Course

This is the second course in TLG Learning’s exclusive Power BI using Excel 2016 series. This course builds on the foundation set in the Data Analysis using Excel 2016 Report Builders. In this course, students learn how to use the Power View, Power Map, and Power Query add-ins.

Audience Profile

At Course Completion

Outline

Lesson 1 : Introducing Power BI Tools

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

Lesson 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

Lesson 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

Lesson 4 : BI Data Query Basics

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

Lesson 5 : Query Editor Transformations

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

Prerequisites

Data Analysis using Excel 2016 – Level 1 – Report Builders