18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

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

Category

Power BI

Rating
4
(4)
Price

$1150

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.

Who should attend this course?

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

Schedules


Aug 19, 2021
9:00 am - 5:30 pm EST
Online

Aug 26, 2021
9:00 am - 5:30 pm EST
Online
question-markCan't find the batch you're looking for?

What you will learn

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

With Microtek Learning, you’ll receive:

  • Certified Instructor-led training
  • Industry Best Trainers
  • Official Training Course Student Handbook
  • Pre and Post assessments/evaluations
  • Collaboration with classmates (not available for a self-paced course)
  • Real-world knowledge activities and scenarios
  • Exam scheduling support*
  • Learn and earn program*
  • Practice Tests
  • Knowledge acquisition and exam-oriented
  • Interactive online course.
  • Support from an approved ITIL expert
  • For Government and Private pricing*
*For more details call: +1-800-961-0337 or email: info@microteklearning.com

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

  • 300+ enterprise clients
  • 100,000+ professionals trained
  • Service 70 of the Fortune 100
  • 96% of our clients would recommend us
our clients

Our Awards

our awards

Why Choose Us?

Best price

Best Price in the Industry

You give better value in the marketplace. We will beat it.

trusted-approved

Trusted & Approved

Our courses are accredited by the authorized vendor.

delivery-methods

Many Delivery Methods

Flexible delivery methods are available here.

high-quality-resources

High-Quality Resources

Resources are included for a comprehensive learning experience.

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.
  • REVIEWS ON OUR POPULAR COURSES

    male

    I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.

    MARTIN

    TORONTO, CANADA

    • (5)
    male

    I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.

    Prince N.

    Texas

    • (5)
    male

    I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.

    Marsh George

    Texas

    • (5)
    Accredited By

    Course Details

    • Start Date: Aug 19, 2021
    • Duration: 2 Days
    • Certification: NO
    • Enrolled: 1564
    • Price: $1150
    side post

    Talk to Learning Advisor

    Get In Touch

    * I authorize Microtek Learning to contact me via Phone/Email