8781  Reviews star_rate star_rate star_rate star_rate star_half
Duration 1 day
Course Code PBI-118-HF
Available Formats Classroom

Overview

Skills Gained

  • Understand the basics of Power BI
  • Udr Power BI Desktop and the Power BI Service
  • Extract and transform data from a variety of sources using Power Query
  • Create and manage data models in Power Pivot
  • Build interactive dashboards and reports using Power View
  • Publish and share your reports with others using the Power BI Service

Prerequisites

No prior experience is presumed.

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.

Course Details

Course Details

Outline

  • Introduction to Power BI
    • What is Power BI?
    • What is Power BI Desktop?
    • What is Power BI Service?
    • Introduction to Power BI Desktop Application
  • Introduction to Power Query and the Data Button
    • Connecting to Class Data
    • Removing Columns
    • Creating Date Fields
    • Renaming Fields
    • Splitting and Merging Columns
    • Deleting and Filtering Rows
    • Creating Calculated Fields
    • Loading the Data
    • Using Data View
    • Refreshing the Data
  • Introduction to Power Pivot using the Model Button
    • Using the Model View
    • Managing Relationships
  • Introduction to Power View using the Report Button
    • Using Report View
    • Creating Visuals
    • Formatting Visuals
    • Creating Measures
    • Creating Charts
    • Creating Slicers
  • Publishing and Sharing Your Reports
    • Publishing Reports to Power BI Service
    • Sharing Reports in Power BI Service
  • Conclusion

Schedule

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase.

  • 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

ExitCertified gave a great course on AWS that covered all of the basics in depth with good lab materials.

Great oppportunity for me to get training on the software during my work day.

Course was great and informative. The instructor had a good flow and was very personable.

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

Courseware was effective but would like to have some PDF material on BPML and XPATH