Microsoft/Course 55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

Course 55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI Certification Training Course Overview

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. 

Target Audience

  • Business Analysts
  • Business Intelligence Developers
  • Reporting Professionals

Course 55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1000
15 - 16 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Dec GTR 08:00 AM - 04:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1150
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Course Overview
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • Lab : Course Overview
Module 2: Power View
  • 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
Module 3: PowerPivot
  • 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 : PowerPivot
Module 4: Power Query
  • Exploring The Power Query Interface
  • Loading Data
  • Managing Modifications
  • Examining Data Cleaning
  • Lab : Power Query
Module 5: Power Map
  • Exploring The Power Map Interface
  • Using Bing Maps
  • Examining Map Data
  • Reviewing Map Types and Presentation
  • Lab : Power Map
Module 6: Introduction to Power BI
  • Introducing Power BI
  • Explaining Excel and Power BI
  • Examining Data Sources
  • Querying with Natural Language
  • Lab : Introduction to Power BI
Download Course Contents

Request More Information

Course Prerequisites

Working knowledge of Excel

 

 

Skills gained

  • 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.
  • 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.
  • Navigate the Power Query interface.
  • Load data.
  • Filter data.
  • Merge datasets.
  • Manage modifications.
  • Perform data cleaning.
  • Navigate the Power Map interface.
  • Use Bing maps.
  • Examine map data.
  • Configure tours, scenes, and layers.
  • Add time to a presentation.
  • Navigate the Power BI interface.
  • Utilize data sources.
  • Understand querying with natural language.