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

Session Detail:    Classroom, Virtual 2 Day

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

Working knowledge of Excel.

Who Can Benefit

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

Session Outline

Class Outline

Module 1: Course Overview

  • Lesson 1: Introduction
  • Lesson 2: Course Materials
  • Lesson 3: Facilities
  • Lesson 4: Prerequisites
  • Lesson 5: What We’ll Be Discussing

After completing this module, students will be able to:

  • Successfully log into their virtual machine
  • Have a full understanding of what the course intends to cover

Module 2: Power View

  • Lesson 1: Exploring the Power View Interface
  • Lesson 2: Visualizing Power View Reports
  • Lesson 3: Working with Tables
  • Lesson 4: Understanding Aggregations
  • Lesson 5: Utilizing Matrix
  • Lesson 6: Configuring Drill Through
  • Lesson 7: Using Cards
  • Lesson 8: Applying Filters
  • Lesson 9: Creating Charts
  • Lesson 10: Examining Tiles
  • Lesson 11: Adding Slicers to Reports
  • Lesson 12: Theming Reports

After completing this module, students 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

Module 3: PowerPivot

  • Lesson 1: Exploring the PowerPivot Interface
  • Lesson 2: Loading Data
  • Lesson 3: Examining Relationships
  • Lesson 4: Configuring Calculated Columns and Calculated Fields
  • Lesson 5: Creating PivotTables
  • Lesson 6: Understanding DAX
  • Lesson 7: Utilizing DAX Functions
  • Lesson 8: Using KPIs
  • Lesson 9: Working with Hierarchies
  • Lesson 10: Managing Perspectives

After completing this module, students 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

Module 4: Power Query

  • Lesson 1: Exploring The Power Query Interface
  • Lesson 2: Loading Data
  • Lesson 3: Managing Modifications
  • Lesson 4: Examining Data Cleaning

After completing this module, students will be able to:

  • Navigate the Power Query interface
  • Load data
  • Filter data
  • Merge datasets
  • Manage modifications
  • Perform data cleaning

Module 5: Power Map

  • Lesson 1: Exploring The Power Map Interface
  • Lesson 2: Using Bing Maps
  • Lesson 3: Examining Map Data
  • Lesson 4: Reviewing Map Types and Presentation

After completing this module, students 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

Module 6: Introduction to Power BI

  • Lesson 1: Introducing Power BI
  • Lesson 2: Explaining Excel and Power BI
  • Lesson 3: Examining Data Sources
  • Lesson 4: Querying with Natural Language

After completing this module, students will be able to:

  • Navigate the Power BI interface
  • Utilize data sources
  • Understand querying with natural language

Need to train your team?

All of our sessions can be customized to meet your team’s specific needs. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

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

2 Day
Classroom, Virtual

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now