SQL Server Analysis Services
Offered By: LinkedIn Learning
Course Description
Overview
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.
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
Related Courses
Analyzing and Visualizing Data with Power BIMicrosoft via edX Managing SSAS Models
Pluralsight Securing SSAS Models
Pluralsight Choosing between Multidimensional and Tabular Models in SSAS
Pluralsight SQL Server Analysis Services - SSAS, Data Mining & Analytics
Udemy