Overview
This 2-day course is designed to teach the participant how to combine the functionality of Power View, PowerPivot, Power Query, and Power BI into graphs, charts, KPIs, reports, and other visualizations for use in their business. This course is lab intensive.
Prerequisites
Participants who wish to take up this course should meet the following prerequisites:
- Working knowledge of Excel
Who Should Attend?
This course is intended for business analysts, business intelligence developers, and reporting professionals.
Course Outline
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What we’ll be discussing
Lab: Course Overview
- Exploring the Power View Interface
- Visualizing Power View Reports
- Working with Tables
- Understanding Aggregations
- Utilizing Matrix
- Configuring Drill Through
- Using Cards
- Applying Filters
- Creating Charts
- Examining Tiles
- Adding Slicers to Reports
- Theming Reports
Lab: Power View
- Exploring the Pivot Interface
- Loading Data
- Examining Relationships
- Configuring Calculated Columns and Calculated Fields
- Creating PivotTables
- Understanding DAX
- Utilizing DAX Functions
- Using KPIs
- Working with Hierarchies
- Managing Perspectives
Lab: PowerPivot
- Exploring the Power Query Interface
- Loading Data
- Managing Modifications
- Examining Data Cleaning
Lab: Power Query
- Exploring the Power Map Interface
- Using Bing Maps
- Examining Map Data
- Reviewing Map Types and Presentation
Lab: Power Map
- Introducing Power BI
- Explaining Excel and Power BI
- Examining Data Sources
- Querying with Natural Language
Lab: Introduction to Power BI
