Kursusmål
Deltagere
Kursusmateriale
Kursus indhold 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.
- SQL Server Analysis Services Server Modes
- Configuring SQL Server Analysis Services in Tabular Mode
- Configuring the Development Environment
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.
- Importing data from different types of data sources
- Relationships
- Calculated Columns and Measures
- Hierarchies
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.
- DAX syntax
- Row Context and Filter Context
- Role playing Relationships
- Parent-Child Hierarchies
Vis mere
...
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.
- DAX and Variables
- Advanced Filtering
- Calculated Tables
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.
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.
- Deploying a Micosoft SQL Server Analysis Services Tabular Database
- Partitions
- Processing and updating Data
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.
- KPI
- Perspectives
- Data Categories
- Columns and Summarization
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.
- Security at the Server Level
- Database Roles
- Row-level Security
- Dynamic Security
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.
- DirectQuery Mode
- DirectQuery Mode Limitations
- Operational Analytics in Microsoft SQL Server Database Engine
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.
- Monitorering with SQL Profiler og xEvents
- Backup and Restore
Har du spørgsmål?
Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.