Professional Training

Prerequisites

The course is targeted towards business analysts, business intelligence developers, and reporting professionals.

Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

After completing this module, participants will be able to:
Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.

Power View

In this module, we will explore Power View and its capabilities, then briefly walk-through the types of reports available and how to format them.

Lessons
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 1: The Business Intelligence Stack
Power View Interface
Working with Tables
Aggregations
Matrix
Drill Through
Cards
Filters
Charts
Tiles
Adding Slicers to Reports

After completing this module, participants will be able to:
Navigate the Power View interface.
Utilize Power View reports.
Work with tables.
Understand aggregations.
Utilize matrix.
Configure drill through.
Use cards as a visualization.
Apply filters.
Create charts.
Utilize tiles.
Add slicers to reports.
Utilize themes.

PowerPivot

In this module, we will explore PowerPivot and its capabilities, then briefly walk-through the options available and how to configure them.

Lessons
Exploring the PowerPivot 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 1: PowerPivot
Introduction to the PowerPivot Interface
Importing Data
Importing Large Datasets
Importing Data with a Query
Creating Relationships
Creating a Cascading Relationship
Hiding Columns, Change Data Type, Sorting, and Filtering
Calculated Columns and Calculated Fields
KPIs
Hierarchies
Perspectives

After completing this module, participants will be able to:
Navigate the PowerPivot interface.
Load data.
Examine and configure relationships.
Configure calculated columns are calculated fields.
Create PivotTables.
Understand and utilize DAX.
Use KPIs.
Work with hierarchies.
Manage perspectives.

Power Query

In this module, we will delve into the benefits and features provided using Power Query. We will examine the options available within the ribbon, as well as explore and demonstrate importing, filtering, and merging data using Power Query.

Lessons
Exploring The Power Query Interface
Loading Data
Managing Modifications
Examining Data Cleaning

Lab 1: Power Query
Getting External Data
Data Filtering
Merging Datasets

After completing this module, participants will be able to:
Navigate the Power Query interface.
Load data.
Filter data.
Merge datasets.
Manage modifications.
Perform data cleaning.

Power Map

In this module we will explore Power Map and its capabilities.

Lessons
Exploring The Power Map Interface
Using Bing Maps
Examining Map Data
Reviewing Map Types and Presentation

Lab 1: Power Map
View Power Map in Action
Geocoding
Tours, Scenes, and Layers
Adding Time

After completing this module, participants will be able to:
Navigate the Power Map interface.
Use Bing maps.
Examine map data.
Configure tours, scenes, and layers.
Add time to a presentation.

Introduction to Power BI

In this module, we will explore the Power BI interface and walk-through the options available.

Lessons
Introducing Power BI
Explaining Excel and Power BI
Examining Data Sources
Querying with Natural Language

Lab 1: Introduction to Power BI
Introduction to Power BI
Data Sources

After completing this module, participants will be able to:
Navigate the Power BI interface.
Utilize data sources.
Understand querying with natural language.