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.

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


General understanding of reporting requirements and a basic understanding of data base concepts is useful, but not required

Detailed Class Syllabus


Lesson 1 : Introducing Power BI


What Is Power BI for the Cloud
Power BI Key Features
Self-Service BI Model
Power BI Components

Lesson 2 : Defining a Report


What is a Power BI Report?
Defining a Report
Data-Driven Storytelling

Lesson 3 : Building Power BI Desktop Reports


Understanding the Design Interface
Creating Reports
Report Visualizations
Formatting Visualizations
Report Final Touches

Lesson 4 : Report Filtering


Highlighting, Drill-down & Data Actions
Visual Interactions
Visual Sorting and Slicers
Visual, Report, & Page Filters

Lesson 5 : Understanding Power BI Data Models


Understanding Data Terminology
Understanding Tables
Understanding Relationships
Diagnosing Data Models
Data Model Schemas

Lesson 6 : Gathering Report Data


Data Queries vs Data Models
Viewing & Refreshing a Data Source
Modifying Report Data

Lesson 7 : Data Model Functions


Creating Calculated Columns
What is DAX?
Basic DAX Functions
Date Hierarchies

Lesson 8 : Introducing the Power BI Service


Power BI Service Interface
Connecting to Data Sources
Uploading & Updating PBIX Reports
Refreshing Power BI Data
Power BI Service Report Interface Components

Lesson 9 : Building Power BI Service Dashboards


Dashboard Interface Components
Building Dashboards
Organizing Dashboard Elements

Lesson 10 : Using Q & A (Cortana)


Understanding Q & A
Modifying Q & A Results
Pinning Q & A results to a Dashboard

Lesson 12 : Appendix A: Power BI Roles and Security


Power BI Roles