TLGPBICR - Data Analysis using Power BI Desktop - Level 1 - Report Builder

This is the first course in TLG Learning’s exclusive Data Analysis using Power BI Desktop series. This course lays the foundation for Power BI Report Builders. Report Builders will learn everything they need to create highly effective stand-alone and multi-page narrative reports using data sources that are created using Power BI Desktop. This course covers the use of both the Power BI Desktop application as well as the Power BI Service.

Student Testimonials

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »

Prerequisites


Basic experience with Microsoft Office, Microsoft Excel, and using Web Browsers. General understanding of basic database concepts is useful, but not required.

Detailed Class Syllabus


Lesson 1 : Introducing Power BI


Power BI as Part of Power Apps
What is Power BI
Power BI Overview

Lesson 2: Understanding Power BI Data Models


Understanding Data Terminology
Data Normalization
Understanding Tables & Relationships
Diagnosing Data Models, Data Model Schemas

Lesson 3: Defining a Report


Power BI Reports
Report Objectives
Data-Driven Narrative

Lesson 4: Building Power BI Desktop Reports


Working with managed data
Creating Visuals
Formatting and Organizing Visuals
Sharing

Lesson 5: Report Actions & Filtering


Drill-Down, Drill-Through and other Data Actions
Filters
Visual Interactions
Bookmarks and Buttons

Lesson 6: Report Data


Data Queries vs Data Models
Modifying Report Data

Lesson 7: Data Model Functions


Calculated Columns
What is DAX?
Row Level Security

Lesson 8: Connecting to Power BI Service


Power BI Service Interface
Publish PBIX Reports and Get Data
Creating your own Workspace
Connecting to Data Sources
Refreshing Power BI Data
Power BI service Report Interface Components

Lesson 9: Building Power BI Service Dashboards


Building Dashboards
Organizing Dashboard Elements

Lesson 10: Service Analytics Features


Dashboard Q & A
Quick Insights

Lesson 11: Sharing Reports & Dashboards


Sharing Content
Managing App Workspaces & Adding Content

Lesson 12: Bonus Activity – Putting it all Together


Power BI Roles