
Outline
Lesson 1 : Understanding BI Data
- Business Intelligence Data
- Data Source Types
- Power BI Data Sources
Lesson 2 : Creating Data Models
- Working with Excel Data Sources
- Data Preparation
- Writing Data Queries
- Working with Database Data Sources
- Writing Data Queries
- Working with Multiple Data Sources
Lesson 3 : Customizing Data Models
- Understanding the Data Modeling Tool
- Making Changes to the Data Model
- Building Relationships
Lesson 4 : Using Dates Correctly
- Why Dates are Different
- Building Date Tables
- Building Date Hierarchies
Lesson 5 : Power BI Functions – M Language
- Query Functions(M) vs. Data Model Functions (DAX)
- Why use M Language?
- Understanding Basic M Functions
- Writing M Functions
Lesson 6 : Power BI Functions - DAX
- DAX Calculated Columns
- Understanding DAX Functions
- Common DAX Functions
- Dates and Date Functions
Lesson 7 : Power BI Functions - DAX Measures
- DAX Measures
- Creating Measures
- Best Practices
Audience
This course is designed for students who want to take advantage of the cloud service reporting features of Power BI.
Prerequisites
Power BI for the Cloud - Level 1 - Report Builder
What You Will Learn
After completing this course, students will be able to:
- Understanding BI Data
- Creating Data Models
- Customizing Data Models
- Using Dates Correctly
- Power BI Functions – M Language
- Power BI Functions – DAX
- Power BI Functions - DAX Measures