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 »


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

Lesson 5: Report Actions & Filtering

Drill-Down, Drill-Through and other Data Actions
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