Adapter vos données pour Power BI

Langue : FRRéférence : 55163Durée : 2 jours
Formation à distance ou en vos locaux.Prix : A définir
Date non disponible actuellement :

Cette formation est organisée uniquement à la demande d'un client et sera adaptée à ses besoins spécifiques.
Le coût de celle-ci sera donc déterminé par un devis personnalisé (avec This email address is being protected from spambots. You need JavaScript enabled to view it. ou This email address is being protected from spambots. You need JavaScript enabled to view it. au 53 28 20 1).

Pendant la pandémie, le Telindus Training Institute n'effectue ses formations qu'au travers de la formation à distance ou en vos locaux.
Ainsi, un grand nombre de nos formations propose une réduction tarifaire.
Veuillez nous contacter pour plus de renseignements. This email address is being protected from spambots. You need JavaScript enabled to view it.

Objectifs :

ABOUT THIS COURSE:

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.
Audience Profile

The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.
At Course Completion

- Understand Analysis Services Installation and Architecture: One Product, Two Models.
- Understand version changes: SQL Server Analysis Services.
- Understand important terms.
- Understand and utilize SQL Server Data Tools for Tabular.
- Understand and utilize projects.
- Understand and utilize importing.
- Understand and utilize loading data.
- Understand and utilize examining views.
- Understand and utilize deployment.
- Understand and utilize data sources.
- Understand and utilize data credentials.
- Understand and utilize SQL as a source.
- Understand and utilize Excel as a source.
- Understand and utilize Flat Files as a source.
- Understand and utilize Azure as a source.
- Understand and utilize SharePoint as a source.
- Understand and utilize sorting during load.
- Understand querying with MDX.
- Understand and utilize DAX syntax.
- Understand and utilize DAX data types and operator overloading.
- Understand and utilize DAX operators.
- Understand and utilize DAX values.
- Understand and utilize measures.
- Understand and utilize calculated columns.
- Understand evaluation contexts.
- Understand and utilize date calculations.
- Understand and utilize importing related tables.
- Understand and utilize creating relationships.
- Understand and utilize hierarchies.
- Understand Direct Query.
- Understand and utilize KPIs.
- Understand drillthrough.
- Understand perspectives.
- Understand and utilize PowerPivot.
- Understand and utilze Pivot Tables.
- Understand and utilize Power View.


Contenu :

Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.

After completing this module, students will be able to:
- Successfully log into their virtual machine.
- Have a full understanding of what the course intends to cover.

Module 2: What is the Tabular Model?
SQL Server Analysis Services (SSAS) provides two different approaches for data modeling: multidimensional and tabular. While there is substantial overlap between them, there are also significant differences. In this module, we discuss feature comparisons and explain each approach, then we’ll dive deeper into the tabular model as that is the focus for this course.

After completing this module, students will be able to:
- Understand Analysis Services Installation and Architecture: One Product, Two Models.
- Understand version changes: SQL Server Analysis Services.
- Understand important terms.
- Understand and utilize SQL Server Data Tools for Tabular.

Module 3: Working in Tabular
In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.

Module 4: Working in Tabular
After completing this module, students will be able to:
- Understand and utilize projects.
- Understand and utilize importing.
- Understand and utilize loading data.
- Understand and utilize examining views.
- Understand and utilize deployment.

Module 5: Understanding Loading Data From Different Sources
In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.

After completing this module, students will be able to:
- Understand and utilize data sources.
- Understand and utilize data credentials.
- Understand and utilize SQL as a source.
- Understand and utilize Excel as a source.
- Understand and utilize Flat Files as a source.
- Understand and utilize Azure as a source.
- Understand and utilize SharePoint as a source.
- Understand and utilize sorting during load.

Module 6: Using DAX and MDX
In this module, we will discuss two different languages; DAX and MDX. We will briefly explore MDX and its use with a tabular model, then we’ll cover DAX and walk-through how to use this powerful language.

After completing this module, students will be able to:
- Understand querying with MDX.
- Understand and utilize DAX syntax.
- Understand and utilize DAX data types and operator overloading.
- Understand and utilize DAX operators.
- Understand and utilize DAX values.
- Understand and utilize measures.
- Understand and utilize calculated columns.
- Understand evaluation contexts.
- Understand and utilize date calculations.

Module 7: Building Data Models
In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.

After completing this module, students will be able to:
- Understand and utilize importing related tables.
- Understand and utilize creating relationships.
- Understand and utilize hierarchies.
- Understand Direct Query.
- Understand and utilize KPIs.
- Understand drillthrough.
- Understand perspectives.

Module 8: Excel PowerPivot and Tabular
In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.

After completing this module, students will be able to:
- Understand and utilize PowerPivot.
- Understand and utilze Pivot Tables.
- Understand and utilize Power View.



Pré-requis :

A working knowledge of SQL Server

Telindus Training Institute utilise des cookies pour améliorer l'expérience client et l'utilisation de son site. En continuant à surfer sur training.telindus.lu, vous acceptez les conditions d’utilisation de ces cookies.