SSAS Tabular
In one day training(8 hours) you will learn how to design and develop a SSAS cube and make it available for the reporting purpose.
Below is the list of the items will be covered by can be customised based on your requirements.
SSAS Tabular Course Units
What is SSAS and cube?
Different types of cube
- Multidimensional
- Tabular
- Excel Power Pivot
Installing SSAS
Modeling
- Connect to data sources
- Add tables
- Working with Power Query
- Relationship and filtering
- Calculated tables
- Calculated Columns
- Measures
- Hierarchy
- Sorting
- Formatting
- Display Folder
DAX formula
Security
- Roles and members
- Static security
- Dynamic Security