Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
9
•
Activities:
0
•
Resources:
39
- 001-Scalable data modeling with Analysis Services Tabular
- 002-Background skills
- 003-Analysis Services Tabular
- 004-Installing SQL Server and Analysis Services-
- 005-Installing SQL Server Management Studio
- 006-Restoring data
- 007-Installing Visual Studio and testing with Excel
- 008-Introduction to data modeling in Analysis Services Tabular
- 009-Creating your first Analysis Services project
- 010-Create a data source to SQL Server
- 011-Adding other data sources
- 012-Challenge Create and test your model
- 013-Solution Create and test your model
- 014-Providing business insight with DAX measures
- 015-Creating tables in DAX
- 016-Developing calculated measures
- 017-Using the CALCULATE function
- 018-Challenge Calculate measures
- 019-Solution Calculate measures
- 020-Incorporating time intelligence
- 021-All about the date table
- 022-Examining three popular DAX time intelligence functions SAMEPERIODLASTYEAR PARALLELPERIOD and TOTALYTD
- 023-Writing DATESBETWEEN measures
- 024-Challenge Time intelligence measures
- 025-Solution Time intelligence measures
- 026-Examining different modeling relationships
- 027-Active and inactive relationships
- 028-Resolving issues with inactive relationships with USERELATIONSHIP
- 029-Challenge USERELATIONSHIP measures
- 030-Solution USERELATIONSHIP measures
- 031-Restricting data for different users
- 032-Modifications to the model to support row level security
- 033-Implementing roles in your model to restrict data
- 034-Challenge Implement model security
- 035-Solution Implement model security
- 036-Review of deployment steps
- 037-Troubleshooting potential deployment issues
- 038-Review of how to test the model in SQL Server Management Studio
- 039-Learn more about Analysis Services