SQL Server Analysis Services

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.

Introduction

• Scalable data modeling with Analysis Services Tabular
• Background skills

1. Introducing Analysis Service Tabular

• Analysis Services Tabular
• Installing SQL Server and Analysis Services
• Installing SQL Server Management Studio
• Restoring data
• Installing Visual Studio and testing with Excel

2. Creating a Data Model

• 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

3. Creating Measures with DAX

• Providing business insight with DAX measures
• Creating tables in DAX
• Developing calculated measures
• Using the CALCULATE function
• Challenge: Calculate measures
• Solution: Calculate measures

4. Time Intelligence Calculations

• 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

5. Advanced Modeling

• Examining different modeling relationships
• Active and inactive relationships
• Resolving issues with inactive relationships with USERELATIONSHIP
• Challenge: USERELATIONSHIP measures
• Solution: USERELATIONSHIP measures

6. Row-Level Security

• 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

7. Deploying the Model

• Review of deployment steps
• Troubleshooting potential deployment issues
• Review of how to test the model in SQL Server Management Studio

Conclusion

• Learn more about Analysis Services