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

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
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 ...

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
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
    Du kan finde alle informationer om dette kursus ved at gå ind på http://www.4d.dk/Kurser/Backoffice/Business_Intelligence_(BI)/Ikke_angivet/999581

    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.

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

    Forhandler
    4D konsulenterne
    Normalpris
    11.400,00 kr
    Udsalgspris
    11.400,00 kr
    Normalpris
    Udsolgt
    Pris pr. stk.
    pr. 
    Eksklusiv moms.

    Efter aftale / Kontakt for pris

    Hvis du har valgt Efter aftale, kan du udfylde formularen nedenfor og så vender vi tilbage til dig og aftaler nærmere.

    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.