Power BI Data Modeling with DAX
Offered By: LinkedIn Learning
Course Description
Overview
Take your data modeling skills to the next level. Learn how to leverage Data Analysis Expressions (DAX) to create formulas for Power BI that extend your data model.
Syllabus
Introduction
- Build powerful data models with DAX
- What you will need
- Data modeling: The basics
- Get data for your model
- Check relationships
- Create a measure with SUM
- Understanding DAX syntax
- Display the measure in a matrix
- Format a measure
- Create measures with COUNT and COUNTROWS
- Delete or edit a measure
- Check your data with COUNTBLANK
- Create a measure with DISTINCTCOUNT
- Add a calculated column
- Understand explicit vs. implicit measures
- Create a measure with operators
- Create a measure with DIVIDE
- Iterators and row context: SUMX
- Basic DAX date and time functions
- Use FIND
- Use IF
- Use OR to handle case sensitivity
- Use CALCULATE to create a simple filter
- Use SWITCH
- DAX time intelligence functions
- Summarize year-to-date with DATESYTD
- Visualize cumulative YTD data
- Compare totals with SAMEPERIODLASTYEAR
- Next steps
Taught by
Gini von Courter
Related Courses
Simple Retrieval Queries in MySQL WorkbenchCoursera Project Network via Coursera Excel Business Intelligence: Power Pivot and DAX
LinkedIn Learning PowerBI Report Development Crash Course
Coursera Project Network via Coursera Model data in Power BI
Microsoft via Microsoft Learn Use DAX in Power BI Desktop
Microsoft via Microsoft Learn