Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map, and Power BI

Request more details:

submit request
Description:
This 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 example intensive.
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.