Course Details
Module 1 - Introduction to Microsoft SQL Server Analysis Services
In this module you will be introduced to Microsoft SQL Server Analysis Services modes and the important role of Microsoft SQL Server Analysis Services in Business Intelligence solutions.
The following will be covered:- SQL Server Analysis Services Server Modes
- Configuring SQL Server Analysis Services in Tabular Mode
- Configuring the Development Environment
Module 2 – Microsoft SQL Server Analysis Services Tabular Projects
In this module you will learn how to create Tabular Data Models using multiple data sources and relate these. You will also be introduced to calculated columns, measures and hierarchies.
The following will be covered:]
- Importing data from different types of data sources
- Relationships
- Calculated Columns and Measures
- Hierarchies
Module 3 – DAX Introduction
In this module you will be introduced to DAX and you will learn the important difference between row context and filter context. You will also learn how to handle role playing relationships and create parent-child hierarchies.
The following will be covered:- DAX syntax
- Row Context and Filter Context
- Role playing Relationships
- Parent-Child Hierarchies
Module 4 – DAX Advanced
In this module you will learn how to use more advanced DAX. You will also learn how to use variables and how to create and use calculated tables.
The following will be covered:- DAX and Variables
- Advanced Filtering
- Calculated Tables
Module 5 – DAX and Time Intelligence
In this module you will learn how to use DAX time intelligence – and date functions. You will learn how to create YTD - and YOY calculations.
The following will be covered:
Time Table Date- and Time Functions YTD Calculations YOY Calculations
Module 6 – Deployment and Processing
In this module you will learn how to deploy your Microsoft SQL Server Analysis Services Tabular database. You will also learn how to partition your tables in your data model and hoe to process and update data in your database.
The following will be covered:- Deploying a Micosoft SQL Server Analysis Services Tabular Database
- Partitions
- Processing and updating Data
Module 7 – Tabular Data Model and Reporting
In this module you will learn how to design and prepare your Tabular Data Model for reporting. You will learn how to create KPI’s and perspectives to support analysis with Excel and Power BI.
The following will be covered:- KPI
- Perspectives
- Data Categories
- Columns and Summarization
Modul 8 – Implementing Security
In this module you will learn how to secure your Microsoft SQL Server Analysis Services Tabular database. You will learn to implement security at the server - and database level and you will learn how to implement dynamic security.
The following will be covered:- Security at the Server Level
- Database Roles
- Row-level Security
- Dynamic Security
Modul 9 – DirectQuery Mode
In this module you will be introduced to Microsoft SQL Server Analysis Services Tabular model solutions using DirectQuery mode making you able to create real-time solutions. You will also learn about the options and the limitations when using DirectQuery and you will be introduced to columnstore indexes and in-memory tables in Microsoft SQL Server Database Engine.
The following will be covered:- DirectQuery Mode
- DirectQuery Mode Limitations
- Operational Analytics in Microsoft SQL Server Database Engine
Modul 10 – Microsoft SQL Server Analysis Services Tabular Administration
In this module you will learn how to monitor Microsoft SQL Server Analysis Services Tabular with SQL Profiler and xEvents. You will also learn how to backup and restore databases and implement a simple disaster recovery strategy.
The following will be covered:- Monitorering with SQL Profiler og xEvents
- Backup and Restore