Course 97018
Power BI Desktop – Creating Visual Reports - Part 2

Course Description

In this 2 hour course, In this course, we will explain in Detail the Power BI Desktop features (installed on your local computer) that can be used to create a Dashboard of different Visual Reports describing related tables. We will take students through a step-by-step process in greater detail, concerning the capabilities including Getting Data, Query Editor, Data View, Relationships, Visual Reports, Formatting, and Filtering.

Corresponding Exam: None

Who should Attend:

This course is for anyone looking to get an understanding of PowerBI and has attended or knowledge of Power BI Overview Part 1

Course Outline

Module 1: Get Data

This will extract the data source from a database such as Excel, Access, etc.

Module 2: Query Editor

- This will allow us to review the data extracted and filter or remove specific records prior to saving them to the Power BI file.

Module 3: Data View

- This will allow us to review the structure of the data extracted and add additional fields as needed. These new fields can be used for establishing relationships or creating new fields.

Module 4: Relationships

This will allow the different tables to display how data is tied together. Please note that storing all data into a single table isn’t as efficient as storing data in separate tables containing specific information.

Module 5: Visual Report

This will generate different reports describing the data from different tables. These reports will include Charts, Matrix, Tables, Summary Information, Maps, etc.

Module 6: Filter Report

- Once a report is created, it can be filtered to display desired information.

Module 7: Format Report

Once you create a report, it can be formatted and filtered to display the desired layout.

Prerequisites

  • Course: Power BI Overview Part 1.

More SQL Server Training


*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.