SQL Server Analysis Services (SSAS) Tabular Model Basic (conducted in English) kursus

Kursusmål

Microsoft SQL Server Analysis Services in Tabular Mode is the choice for many new solutions focusing on analyzing data and creating data models delivering superior performance. Microsoft SQL Server Analysis Services in Tabular Mode uses effective compression and state of the art in-memory technology delivering high performing solutions. This course will learn you how to create data models and use DAX to create calculated columns and measures. You will also be introduced to real-time solutions using DirectQuery mode.

Microsoft SQL Server Analysis Services Tabular Model is a different way to create data models compared to the well-known multidimensional model and it is considered easier to comprehend for developers normally using relational databases.

On the course, you will learn to
  • Create Microsoft SQL Server Analysis Services solutions in Tabular Mode
  • Create a Tabular Data Model
  • Create Relationships
  • Create Hierarchies
  • Create Measures, Calculated Columns, KPIs, and Perspectives
  • Use DAX
  • Implementing Security
  • Create Solutions with DirectQuery
  • Administer a Microsoft SQL Server Analysis Services Tabular Database

Deltagere

This is a technical course and we expect that you have a basic knowledge of business intelligence, dimensional data modelling and relational databases.

Kursusmateriale

During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.

After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Kursusindhold

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
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.
  • 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.
  • 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.
  • 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.
  • 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.
    • 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.
    • 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.
    • 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.
    • 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.
    • Monitorering with SQL Profiler og xEvents
    • Backup and Restore

    Kontaktoplysninger

    Adresse
    Amagertorv 21
    1160 København K