microsoft partner logo color
8379  Reviews star_rate star_rate star_rate star_rate star_half

Introduction to Power BI Report Builder

Power BI Report Builder is the latest incarnation of Microsoft’s easy-to-use tool for IT professionals and power users who want to build paginated reports using the Power BI service. Attendees...

Read More
By Request
$1,995 USD
Duration 3 days
Course Code PBI-114
Available Formats Classroom

Overview

Power BI Report Builder is the latest incarnation of Microsoft’s easy-to-use tool for IT professionals and power users who want to build paginated reports using the Power BI service. Attendees learn how to create paginated reports to display complex tables or matrices that can be printed or exported to tools such as Excel.

Skills Gained

  • Understand and use data sources and datasets
  • Create and format reports
  • Add images and document maps to reports
  • Work with groups to summarize data
  • Use parameters to add flexibility to reports
  • Create complex reports featuring nesting and drill-through capabilities
  • Incorporate custom expressions into reports

Prerequisites

Students must be familiar with database concepts and have a working knowledge of Microsoft SQL Server or Microsoft Office applications.

Course Details

Training Materials

All attendees receive a comprehensive Power BI Report Builder course workbook.
© 2023 Ann L Weber

Software Requirements

  • Microsoft 365, especially Excel (or on-premise Excel 2019 or later)
  • Power BI Report Builder
  • Modern web browser such as Chrome or Microsoft Edge

Outline

  • Introduction
  • Power BI Overview
    • What is Power BI?
    • What is Power BI Report Builder?
    • Authoring with Report Builder
  • Data Sources and Datasets
    • What is a Data Source?
    • Working with Power BI Dataset Connections
    • What is a Dataset?
    • Creating Datasets
  • Creating New Reports
    • Using the Report Wizards
    • Starting from the Blank Report Template
    • What is Tablix?
    • Creating a Tabular Report
    • Creating a List Report
    • What is a Matrix?
  • Formatting Reports
    • Working with Text Boxes
    • Rich Text Formatting
    • Managing Text Boxes
    • Drawing Lines and Boxes
    • Images
    • Page Headers and Footers
    • Adding a document map
    • Rendering Reports
  • Summarizing and Sorting
    • Creating Groups
    • Adding Totals and Aggregations
    • Tablix Properties and Grouping Data
    • Parent/Child vs. Adjacent Groupings
  • Add Flexibility with Parameters
    • Adding Parameters to a Report
    • Report Parameters vs. Query Parameters
    • Manage Report Parameter Properties
    • Working with Cascading Parameters
    • Sort Based on a Parameter Setting
    • Filtered Reports
  • Enhanced Report Items
    • Nesting Data Regions
    • Subreports and Drillthrough Reports
    • Working with Drillthrough Reports
  • Custom Expressions
    • Understanding Expressions>
    • Defining Expressions
    • Working with Report Variables
    • Understanding Lookup, LookupSet, and Multilookup Functions
    • Expression Samples
  • Conclusion
Read Less

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

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 was a good program to get prepared for the solutions architect associate exam.

Overall it was a good bootcamp. A lot to cover so it is understandable that the pace had to be a little fast.

Very good material, the instructor was clear explaining the topics, and the labs were easy to follow it.

Easy to work with. Learning material pdfs were able to be printed out in color which was very nice to write on.

The technical data in the AWS Solutions Architect course was very thorough.