Microtek Learning Logo

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

4.6
(4.6)

The course is developed to teach participants the process of combining the functionality of Power Query, PowerPivot, Power View, and Power BI into Charts, graphs, reports, KPIs, and other visual information to use in a business environment.

  • Accredited By : Microsoft Partner Logo
  • Category : Power BI

Course Price : $1150 Per Participant

Course Description

The course is developed to teach participants the process of combining the functionality of Power Query, PowerPivot, Power View, and Power BI into Charts, graphs, reports, KPIs, and other visual information to use in a business environment.

This training is designed based on the objectives of the course variant 55164A.

 

Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.
Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick Navigating Power View interface.
  • green-tick Utilizing Power View reports.
  • green-tick Working with tables.
  • green-tick Understanding aggregations.
  • green-tick Utilizing matrix.
  • green-tick Configuring drill through.
  • green-tick Using cards as visualization.
  • green-tick Applying filters.
  • green-tick Creating charts.
  • green-tick Utilizing tiles.
  • green-tick Adding slicers to reports.
  • green-tick Utilizing themes.
  • green-tick Navigating the PowerPivot interface.
  • green-tick Loading data.
  • green-tick Examining and configuring relationships.
  • green-tick Configuring calculated columns and fields.
  • green-tick Creating PivotTables.
  • green-tick Understanding and utilizing DAX.
  • green-tick Using KPIs.
  • green-tick Working with hierarchies.
  • green-tick Managing perspectives.
  • green-tick Navigating the Power Query interface.
  • green-tick Loading data.
  • green-tick Filtering data.
  • green-tick Merging datasets.
  • green-tick Managing modifications.
  • green-tick Performing data cleaning.
  • green-tick Navigating Power Map interface.
  • green-tick Using Bing maps.
  • green-tick Examining map data.
  • green-tick Configuring tours, layers, and scenes.
  • green-tick Adding time to a presentation.
  • green-tick Navigating Power BI interface.
  • green-tick Utilizing data sources.
  • green-tick Understanding query with natural language.

Who should attend this course?

  • The program is aimed towards business analysts, reporting professionals and BI developers.

Microsoft Learning PartnerMicrosoft Learning Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

  • calendar Aug 01, 2024
  • time 8:30 am - 4:30 pm EST
  • location online
GTR
  • calendar Aug 15, 2024
  • time 8:30 am - 4:30 pm EST
  • location online
  • calendar Aug 29, 2024
  • time 8:30 am - 4:30 pm EST
  • location online

Can’t Find The Batch You’re Looking For?

Request a Batch

Curriculum

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

  • 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.
  • 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
  • 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.
  • 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
  • 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, 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.
  • 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
  • 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.
  • 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
  • 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.
  • 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
  • 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.
  • Course Details

    • enroll enroll-green
      Enrolled: 1564
    • duration duration green
      Duration: 2 Days

    Talk to Learning Advisor