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

Code: 55164-02
Course duration: 2 days
Price: $1,895

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

Course 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. 

The 2 day 55164 Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI course followed by Course 20778 Analyzing Data with Power BI 2017 is a great 5 day Combo! 

Who Should Attend 

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

After completing this course, 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. 
  • 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. 

Module 1: Course Overview 

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

Lessons 

  • Introduction 
  • Course Materials 
  • Facilities 
  • Prerequisites 

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.. 

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 : Power View 

Module 3: Power Pivot 

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 : PowerPivot 

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. 

Lessons 

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

Lab : Power Query 

Module 5: 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 : Power Map 

Module 6: 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 : Introduction to Power BI 

Prerequisites 

Before attending this course, students must have: 

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

 

Guaranteed to Run

2020-11-26 09:00 to 2020-11-27 17:00
Attend Online
2020-11-25 09:00 to 2020-11-27 17:00
Attend Online
2020-11-19 09:00 to 2020-11-20 17:00
Attend Online
2020-11-19 09:00 to 2020-11-20 17:00
Attend Online
2020-11-16 09:00 to 2020-11-20 17:00
Attend Online
2020-11-16 09:00 to 2020-11-20 17:00
Attend Online
2020-11-13
09:00 to 17:00
Attend Online
2020-11-12 09:00 to 2020-11-13 17:00
Attend Online
2020-11-06
09:00 to 17:00
Attend Online
2020-11-06
09:00 to 17:00
Attend Online
2020-11-02 09:00 to 2020-11-06 17:00
Attend Online
2020-11-02 09:00 to 2020-11-06 17:00
Attend Online
2020-10-29 09:00 to 2020-10-30 17:00
Attend Online
2020-10-26 09:00 to 2020-10-30 17:00
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review