microsoft partner logo color
8781  Reviews star_rate star_rate star_rate star_rate star_half

Power BI Desktop for Report Writers

This live, private Power BI Desktop for Report Writers training course teaches attendees how to clean and present their data as powerful visualizations and reports. Participants first learn the...

Read More
By Request
$1,313 USD
Duration 3 days
Course Code PBI-106-HF
Available Formats Classroom

Overview

Course Description

This live, private Power BI Desktop for Report Writers training course teaches attendees how to clean and present their data as powerful visualizations and reports. 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. Over 80% of the class is hands-on, with attendees learning by doing.

Note: This 3-day course combines our 1-day introductory, intermediate, and advanced Power BI courses.

Skills Gained

  • Define Power BI and its different components
  • Connect to data sources and transform data using Power Query
  • Create and format visuals using Power View
  • Model data using Power Pivot
  • Publish and share reports in Power BI Service
  • Use Quick Insights and Q&A for data
  • Leverage Power BI Tips and Tricks

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.
Read Less

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
  • 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
  • Introduction to Advanced Features
    • Editing existing Power BI Reports
    • Updating the Data Sources
    • Setting up Quick Access Toolbar in Power Query
  • Extracting and Transforming the Report Data
    • Extracting the Data that tells the Story
    • Transforming the Data Quickly and Efficiently
  • Data Modeling and Relationships
    • Managing Relationships
    • Handling Many-to-Many Relationships
  • Preparing the Report Pages
    • Setting Page Information
    • Inserting a Page Background
  • Creating Interactive Reports
    • Creating Visuals that Explore the Data
    • Creating Top N Filters
    • Using Data Hierarchy Buttons
    • Creating a Measures table
    • Creating Measures & Quick Measures
    • Adding Custom Visuals
    • Applying Themes
    • Adding Report Titles, Logos, and Images
    • Creating Button Slicers
    • Adding Buttons and Shapes
    • Creating Multiple Pages
    • Using Edit Interactions
    • Using Q & A
  • Publishing and Sharing Reports
    • Publishing Reports
    • Creating Dashboards
    • Using Q&A in Power BI Service
  • Conclusions

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information
Ascendient Learning would like to occasionally share news about our services and career opportunities via e-mail when we believe it would be relevant to you. Would you like to opt-in to these communications? You may withdraw your consent at any time using the opt-out/preferences link in the emails sent.

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

Easy to use and exactly what I was looking for. Value for money was exceptional.

It is very good and very simple instructions. almost to much hand holding.

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

Some Labs are very good but some steps it ask to update but its already updated, but overall its very good training.

The class and material is good. I think some of the software needs to be updated.