microsoft partner logo color
8293  Reviews star_rate star_rate star_rate star_rate star_half

Power BI Desktop

In this hands-on Power BI course, participants first learn the basics of Power BI, Power Query, Power Pivot, and Power View and then move on to intermediate and advanced skills, including data...

Read More
$875 USD
Duration 2 days
Course Code PBI-117
Available Formats Classroom

Overview

In this hands-on Power BI course, participants first learn the basics of Power BI, Power Query, Power Pivot, and Power View and then move on to intermediate and advanced skills, including data modeling and sharing data visualizations.

Skills Gained

  • Define Power BI and its different components
  • Connect to data sources and transform data using Power Query
  • Create and format visualizations using Power View
  • Model data using Power Pivot
  • Publish and share reports in Power BI Service

Prerequisites

No prior knowledge is presumed.

Course Details

Course Outline

  • Introduction to Power BI
    • Power BI Desktop
    • Power BI Service
    • Power BI Mobile Apps
    • Power BI Report Server
  • Introduction to Power BI Desktop
    • What is Power BI?
    • What is Power BI Desktop?
    • Introduction to Power BI Desktop Application
  • Introduction to Power Query and the Data Button
    • Connecting to Data
    • Transforming the Data
    • Creating Simple Calculations using M Code
    • Loading the Data
    • Refreshing the Data
  • Introduction to Power Pivot using the Model Button
    • Creating Relationships
    • Modifying Relationships
  • Introduction to Power View using the Report Button
    • Creating Measures using DAX
    • Creating Visuals
  • Publishing and Sharing Your Reports
    • Publishing Reports to Power BI Service
    • Sharing Reports in Power BI Service
  • Using Power BI Desktop
    • Using Power BI Desktop Startup Screen
    • Setting Power BI Desktop Options
  • Using Power Query to Shape Data
    • Creating Duplicate and Reference Queries
    • Unpivoting Data
    • Appending & Merging Data
    • Combining Files from Folder
    • Grouping Data
    • Creating More Calculations using M Code
    • Using Advanced Editor
    • Using PBI Queries in Excel
  • Using Power Pivot to Model Data
    • Creating Relationships Manually
    • Using Cardinality, Cross Filter, and Referential Integrity Settings
  • Using Power View to Create Visualizations
    • Creating Advanced Measures using DAX
    • Using Q&A to create Visuals
    • Applying Filters to Visuals
    • Creating Bookmarks
    • Creating Multiple Pages
  • Using Power BI Service
    • Publishing to Power PI Service, Team Sites, PBI Report Server
    • Creating Dashboards

Schedule

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

This course gave me a clearer understanding of the AWS cloud architecture.

The format of the class was concise. I learned new skills to use at my workplace.

the class/lecture was amazing and very easy to understand and was in detail.

Great company -- easy to sign up and very organized. Loved my teacher and class overall.

This is my second course with ExitCertified. This course exceeded my expectations. The teacher was great and the class was fun.