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

Module 1: Course Overview.

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

• Introduction.
• Course Materials.
• Facilities.
• Prerequisites.
• What We’ll Be Discussing.
• Lab: Course Overview.

Module 2: 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.

• 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.
• Labs: Power View.
  - Power View Interface.
  - Working with Tables.
  - Aggregations.
  - Matrix.
  - Drill Through.
  - Cards.
  - Filters.
  - Charts.
  - Tiles.
  - Adding Slicers to Reports.

Module 3: PowerPivot.

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

• 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.
• Labs: 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.

Module 4: 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.

• Exploring The Power Query Interface.
• Loading Data.
• Managing Modifications.
• Examining Data Cleaning.
• Labs: Power Query.
  - Getting External Data.
  - Data Filtering.
  - Merging Datasets.

Module 5: Power Map.

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

• Exploring The Power Map Interface.
• Using Bing Maps.
• Examining Map Data.
• Reviewing Map Types and Presentation.
• Labs: Power Map.
  - View Power Map in Action.
  - Geocoding.
  - Tours, Scenes, and Layers.
  - Adding Time.

Module 6: Introduction to Power BI.

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

• Introducing Power BI.
• Explaining Excel and Power BI.
• Examining Data Sources.
• Querying with Natural Language.
• Labs: Introduction to Power BI.
  - Introduction to Power BI.
  - Data Sources.