Description
Overview:
This is the first course in TLG Learning’s 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 managed data sources. This course covers the use of both the Power BI Desktop application and the Power BI Service. We will cover usable features for users to become power users.
Prerequisite(s):
Basic experience with Microsoft Office, Microsoft Excel, and using Web Browsers. General understanding of basic database concepts is useful, but not required.
Audience:
Outline:
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
Reviews
There are no reviews yet.