Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

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

  • Tuition USD $1,090 Save $109
  • Reviews star_rate star_rate star_rate star_rate star_half 347 Ratings
  • Course Code 55164
  • Duration 2 days
  • Available Formats Classroom

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.

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.

Who Can Benefit

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

Prerequisites

  • Working knowledge of Excel

Course Details

Outline


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

Lab 1: Course Overview
  • None
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.

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

Module 3: 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 1: 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.

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

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

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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

A reliable partner with AWS. Provides excellent reading and lab material. A really helpful subject matter companion as you move forward towards certification. Reliable and thorough. Professional instructors and customer service.

The presenter was knowledgeable and professional. The duration of the course, the pace and venue was suitable also

Warm greeting and excellent help. The eating area is always clean and well stocked

Great instructor and good class material. Labs were helpful and put together very well.

Facilities were very clean, coffee was nice to have, snack selection was refreshing

0 options found

undo
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward