microsoft partner logo color
8388  Reviews star_rate star_rate star_rate star_rate star_half

Intermediate Power BI: From Data to Insights

Skills Gained Connect to, visualize, and analyze data from a variety of sources with Power BI Use Power Query to transform data, including cleaning, shaping, and merging it Model data and create...

Read More
Duration 1 day
Course Code PBI-120-HF
Available Formats Classroom

Overview

Skills Gained

  • Connect to, visualize, and analyze data from a variety of sources with Power BI
  • Use Power Query to transform data, including cleaning, shaping, and merging it
  • Model data and create relationships between tables in Power Pivot
  • Create interactive visualizations, such as charts, maps, and tables in Power View
  • Publish reports to Power BI Service and create dashboards to monitor key metrics

Prerequisites

All attendees should have taken Ascendient Learning's Introduction to Power BI: Building Reports in a Day course or have the equivalent knowledge.

Course Details

Training Materials

All attendees receive a Power BI quick reference guide.

Software Requirements

  • The current version of Power BI Desktop installed
  • Attendees will not need to install any other software on their computers for this class. The class will be conducted in a remote environment that Ascendient Learning will provide.

Outline

  • Introduction
  • Using Power Query to Transform the Data
    • Setting up the Quick Access Toolbar (QAT)
    • Fixing Lost Preceding Zeros
    • Using Column from Examples
    • Creating Duplicate and Reference Queries
    • Converting a Query to a List
    • Changing the Source of the Query
    • Unpivoting Columns
    • Grouping Data
    • Appending & Merging Data
    • Creating Calculations
    • Viewing M Code
    • Disabling the Loading of Data
    • Creating Query Groups
    • Finalizing Queries
  • Using Power Pivot to Model the Data
    • Manually Creating Relationships
    • Hiding/Showing Tables and Fields
  • Using Power View to Create Visualizations
    • Creating Multi-row Cards, Charts, Matrix, and Slicers
    • Creating More Measures using DAX
    • Grouping Objects
    • Applying Conditional Formatting
    • Creating Bookmarks
  • Using Power BI Service
    • Publishing Reports to Power BI Service
    • Using Bookmarks
    • Exporting Data
    • Creating Dashboards
  • Conclusion

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

The course was informative, and I learnt a new skill. The instructor was up to the point.

This was effective way to provide a ton of information in a short time period.

I didn't have any problem navigating Exitcertified website or lab material at all.

Great instructor, clear and concise course. Labs were easy to follow and worked perfectly.

Exit certified was great as it is very in depth and hands on learning which made it very easy to learn this type of work.