Power BI Data Modeling with DAX
5.0 /5- Offered byLinkedin Learning
Power BI Data Modeling with DAX at Linkedin Learning Overview
Duration | 2 hours |
Total fee | ₹1,599 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Power BI Data Modeling with DAX at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
Power BI Data Modeling with DAX at Linkedin Learning Course details
- In this course, Gini von Courter covers the essentials of working with DAX, sharing best practices for data model design and optimization along the way
- Learn how to work with DAX aggregate functions, add calculated columns, create measures, and work with DAX logical and filter functions
Power BI Data Modeling with DAX at Linkedin Learning Curriculum
Introduction
Build powerful data models with DAX
What you will need
Set Up the Data Model
Data modeling: The basics
Get data for your model
Check relationships
DAX Aggregate Functions
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
Measures and Calculated Columns
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
DAX Logical and Filter Functions
Use FIND
Use IF
Use OR to handle case sensitivity
Use CALCULATE to create a simple filter
Use SWITCH
Using DAX Time Intelligence Functions
DAX time intelligence functions
Summarize year-to-date with DATESYTD
Visualize cumulative YTD data
Compare totals with SAMEPERIODLASTYEAR
Conclusion
Next steps
Power BI Data Modeling with DAX at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Power BI Data Modeling with DAX at Linkedin Learning Students Ratings & Reviews
3 Ratings- 4-53
Student Forum
Anything you would want to ask experts?