Le portail de la formation tout au long de la vie
LU
DE
EN
FR
PT

Adapter vos données pour Power BI

2 jour(s)

Objectifs

  • 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 utilize Pivot Tables
  • Understand and utilize Power View

Contenu

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

Module 1: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Lessons
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • Lab: Course Overview
  • None

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.

  • Lessons
  • Analysis Services Installation and Architecture: One Product, Two Models
  • Version Changes: SQL Server Analysis Services
  • Important Terms
  • SQL Server Data Tools for Tabular
  • Lab: What is the Tabular Model?
  • SQL Server Data Tools for Tabular

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

Public cible

A qui s'adresse la formation?

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

 
Prérequis

A working knowledge of SQL Server

Voir les coordonnées de l'organisme


Le contenu de ce descriptif de formation est de la seule responsabilité de son auteur, l'organisme de formation Telindus Training Institute.

Imprimer Tout voir/cacher
Partager sur Facebook Partager sur Twitter Partager sur LinkedIn Partager sur Google+ Envoyer à un ami
Voir les coordonnées de l'organisme
Caractéristiques
Niveau Avancé
Organisation Formation intra-entreprise
Langues de prestation
lifelong-learning.lu utilise des cookies

En consultant ce site, vous acceptez l'utilisation des cookies nécessaires à la navigation et permettant de réaliser des statistiques.

Vous pouvez modifier les paramètres des cookies à tout moment dans votre navigateur.

OK En savoir plus