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

You will learn

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 in Analysis Services (SSAS) 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

You get

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.

Get the best benefit from the course

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

This Analysis Services (SSAS) course is a part of 4D's unique collection of English conducted courses in the Business Intelligence category.

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

    Hold dig opdateret med vores nyhedsbrev

    Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

    Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

    Her bor vi

    Hovedindgang
    Amagertorv 21
    1160 København K
    Kursusindgang
    Læderstræde 22-26
    1201 København K
    Åbningstider
    Mandag: 08.00 - 16.30 (Indgang for kursister i Læderstræde åbner 8.30) 
    Tirsdag: 08.30 - 16.30
    Onsdag: 08.30 - 16.30
    Torsdag: 08.30 - 16.30
    Fredag: 08.30 - 16.30

     

    Kontaktoplysninger

     
    Amagertorv 21
    1160 København K