SQL Server Analysis Services

Course details

SQL Server Analysis Services Tabular can help you analyze your data more effectively—even if you have a large volume of data to sort through—organizing and storing your data so that you can find trends by looking at data summaries. In this course, Ginger Grant provides high-level overview SQL Server Analysis Services Tabular, with real-world examples, to help you gain insights from your data and plan for the future. Ginger shows you how to install the required complex development environment outside of SQL Server Management studio and explains the benefits of creating a data model in Analysis Services. Advanced topics include how to extend the analysis using DAX, an in-depth look at the model components, and how the different relationships change the way the data is displayed.

Join Ginger in this course to learn how to organize and store your data in a way that makes it easier to find trends and draw conclusions—and move beyond spreadsheets!

Concepts

0. Introduction

01 - Scalable data modeling with Analysis Services Tabular
02 - Background skills

1. Introducing Analysis Service Tabular

03 - Analysis Services Tabular
04 - Installing SQL Server and Analysis Services
05 - Installing SQL Server Management Studio
06 - Restoring data
07 - Installing Visual Studio and testing with Excel

2. Creating a Data Model

08 - Introduction to data modeling in Analysis Services Tabular
09 - Creating your first Analysis Services project
10 - Create a data source to SQL Server
11 - Adding other data sources
12 - Challenge - Create and test your model
13 - Solution - Create and test your model

3. Creating Measures with DAX

14 - Providing business insight with DAX measures
15 - Creating tables in DAX
16 - Developing calculated measures
17 - Using the CALCULATE function
18 - Challenge - Calculate measures
19 - Solution - Calculate measures

4. Time Intelligence Calculations

20 - Incorporating time intelligence
21 - All about the date table
22 - Examining three popular DAX time intelligence functions - SAMEPERIODLASTYEAR, PARALLELPERIOD, and TOTALYTD
23 - Writing DATESBETWEEN measures
24 - Challenge - Time intelligence measures
25 - Solution - Time intelligence measures

5. Advanced Modeling

26 - Examining different modeling relationships
27 - Active and inactive relationships
28 - Resolving issues with inactive relationships with USERELATIONSHIP
29 - Challenge - USERELATIONSHIP measures
30 - Solution - USERELATIONSHIP measures

6. Row-Level Security

31 - Restricting data for different users
32 - Modifications to the model to support row-level security
33 - Implementing roles in your model to restrict data
34 - Challenge - Implement model security
35 - Solution - Implement model security

7. Deploying the Model

36 - Review of deployment steps
37 - Troubleshooting potential deployment issues
38 - Review of how to test the model in SQL Server Management Studio

Conclusion

39 - Learn more about Analysis Services