Learn how to create, secure, and deploy an Analysis Services Tabular model to organize and store your data in a way that makes it easier to find trends and draw conclusions.
Overview
Syllabus
Introduction
- Scalable data modeling with Analysis Services Tabular
- Background skills
- Analysis Services Tabular
- Installing SQL Server and Analysis Services
- Installing SQL Server Management Studio
- Restoring data
- Installing Visual Studio and testing with Excel
- Introduction to data modeling in Analysis Services Tabular
- Creating your first Analysis Services project
- Create a data source to SQL Server
- Adding other data sources
- Challenge: Create and test your model
- Solution: Create and test your model
- Providing business insight with DAX measures
- Creating tables in DAX
- Developing calculated measures
- Using the CALCULATE function
- Challenge: Calculate measures
- Solution: Calculate measures
- Incorporating time intelligence
- All about the date table
- Examining three popular DAX time intelligence functions: SAMEPERIODLASTYEAR, PARALLELPERIOD, and TOTALYTD
- Writing DATESBETWEEN measures
- Challenge: Time intelligence measures
- Solution: Time intelligence measures
- Examining different modeling relationships
- Active and inactive relationships
- Resolving issues with inactive relationships with USERELATIONSHIP
- Challenge: USERELATIONSHIP measures
- Solution: USERELATIONSHIP measures
- Restricting data for different users
- Modifications to the model to support row-level security
- Implementing roles in your model to restrict data
- Challenge: Implement model security
- Solution: Implement model security
- Review of deployment steps
- Troubleshooting potential deployment issues
- Review of how to test the model in SQL Server Management Studio
- Learn more about Analysis Services
Taught by
Ginger Grant
