DAX or Data Analysis Expression language allows developers to extract data from dashboards and reports. This course will begin by explaining how DAX relates to the tabular model. It will progress to how row and filter contexts and functions can be used to manipulate data and then how Time Intelligence allows for slicing data quickly and easily. Finally it will show how DAX can be used to populate Reporting dropdowns and report previews.
Lesson 1:
- What Is DAX?
- Data Model
- Demo: Data Model Review
- DAX Structure
- Demo: DAX Structure
- Demo: Filter.
Lesson 2:
- Row Context
- Filter Context
- Use of Filters
- Demo: Row and Filter Context
- Demo: New Column
- DAX Functions
- Error Handling
- A and X Suffix
- Demo: Other DAX Functions.
Lesson 3:
- Time Intelligence
- Other Functions
- Demo: Time Intelligence
- Demo: Rounding
- Many to Many
- Demo: Many to Many
- Reporting a Tabular Model
- Reporting
- PowerView
- Demo: PivotTable and PowerView.
