Description
Overview:
This is the second course in TLG Learning’s custom Power BI Desktop series. Using fundamental concepts of Self-Service Data Model Design, students will use Power Query to extract, transform, and load data to create manageable and scalable data models.
This course is designed for Report Builders who are ready to create custom data models. Students will also receive an introduction to the M Language as well as Data Analytic expressions (DAX).
Prerequisite(s):
Data Analysis using Power BI Desktop – Level 1 – Report Builder
Audience:
Outline:
Lesson 1: Understanding BI Data
- Understanding the Process
- Understanding BI Data Sources
- Table Roles
Lesson 2: Creating Data Models
- Analyzing the Data Source
- Creating New Tables
- Creating Relationships
Lesson 3: Customizing Data Models
- Additional Transformations
- Editing Applied Steps
- Merging, Appending, Unpivoting Data
- Transformations in Table View
- Using the Options Dialog Box
Lesson 4: Accessing Additional Data Sources
- Using Relational Databases
- Creating a Composite Data Model
- Creating a Data Model from Cloud Sources
- Storage Modes (ImportQuery vs. DirectQuery)
- Query Folding
- Performance Analyzer
Lesson 5: Power BI Functions – Intro to DAX
- Calculated Columns
- DAX Measures
- Working with Date Tables
Lesson 6: M Language
- Getting Started with M Language
- Basic M Language Queries
- Adding, Duplicating & Splitting Columns
- The “Last Refresh” Indicator
