Power BI Desktop – Creating Visual Reports - Part 2
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
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.
- Course: Power BI Overview Part 1.
*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.