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

Course Modality

Instructor-led (classroom)

Course Level

Beginner

Course Time

90 MINUTES

Course Language

English

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. This course is lab example intensive.

Prerequisites

  • Before attending this course, students must have: 
      • Working knowledge of Excel 

Intended Audience

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

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

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. 

Get In Touch

Course Curriculum

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 
  • What We’ll Be Discussing 

Lab: Course Overview 

After completing this module, student 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: Power View 

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

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: 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, student 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: Power Query

  • Getting External Data
  • Data Filtering
  • Merging Datasets

 

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.

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

  • View Power Map in Action
  • Geocoding
  • Tours, Scenes, and Layers 
  • Adding Time

 

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.

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 

  • Introduction to Power BI
  • Data Sources

After completing this module, students will be able to: 

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

Reviews

5/5
John Doe
John Doe@username
Read More
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
John Doe
John Doe@username
Read More
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
John Doe
John Doe@username
Read More
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Previous
Next

Get in touch, enquire now!


By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.

© 2020 The Data Tech Labs Inc. All rights reserved.

TDTL-arrow
[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure