Descrizione

This course is about the Lates Microsoft analysis tool core engine: Microsoft Tabular. You will learn about the OLAP Tabular technology from the data ingestion to the front-end development. The advantages of an OLAP-type system, compared to a simple relational will be highlighted during the course with the aim to build a faster and more efficient data analysis scheme.

Target

Data Engineer, Data Analyst, Data Scientist

Prerequisiti

General knowledge of SQL-Server and T-SQL

Programma Corso

DATA MODELING

• Introduction to Data Modeling
• Dimensions, Facts and Measures
• Hints on Normal Forms and Schemas

SQL SERVER ANALYSIS SERVICES

• Comparison between Multidimensional and Tabular technology
• Historic hints on Tabular technology
• Recent Tabular updates

TABULAR

• Data Connection
• Table editing, loading and process
• Relationship between tables

TABULAR DAX

• Measures and calculated member
• Data modeling and Partitions
• Roles and Impersonation
• Deploy
• Tutorials