Preparación de sus datos para Power BI (55163)

Duración: 14 horas.
¡Quiero saber más sobre el curso de Preparación de sus datos para Power BI (55163)!

A quien va dirigido

El curso está dirigido a analistas de negocios, desarrolladores de inteligencia de negocios y profesionales de SQL.

Descripción

Este curso está diseñado para presentar al participante el modo tabular del modelo semántico de inteligencia empresarial de SQL (BISM), el modelado de datos y DAX, y para comparar el trabajo en el modo tabular de SQL con Excel PowerPivot

A quien va dirigido

El curso está dirigido a analistas de negocios, desarrolladores de inteligencia de negocios y profesionales de SQL.

Descripción

Este curso está diseñado para presentar al participante el modo tabular del modelo semántico de inteligencia empresarial de SQL (BISM), el modelado de datos y DAX, y para comparar el trabajo en el modo tabular de SQL con Excel PowerPivot

La importancia del modelo tabular
• Instalación y arquitectura de Analysis Services: un producto, dos modelos
• Cambios de versión: SQL Server Analysis Services (SSAS)
• Términos clave
• Herramientas de datos del modelo tabular de SQL Server
• Proyectos
• Importación
• Carga de datos
• Ordenación
• Uso de fuente de datos: SQL, Excel, archivos planos, Azure, SharePoint
• Consulta MDX
• DAX: operadores, valores, medidas
• Columnas, contexto, fecha,
• Importación de tablas vinculadas
• Tablas dinámicas: PowerPivot y PowerView
• Uso de los KPI

Antes de tomar este curso, los estudiantes deben tener un conocimiento práctico de SQL Server.

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

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • None
  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

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.

  • Analysis Services Installation and Architecture: One Product, Two Models
  • Version Changes: SQL Server Analysis Services
  • Important Terms
  • SQL Server Data Tools for Tabular
  • SQL Server Data Tools for Tabular
  • 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.

In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.

  • Projects
  • Importing
  • Loading Data
  • Examining Views
  • Deployment

• Creating a Tabular Project

  • Understand and utilize projects.
  • Understand and utilize importing.
  • Understand and utilize loading data.
  • Understand and utilize examining views.
  • Understand and utilize deployment.

In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.

  • Data Sources
  • Data Credentials
  • SQL as a Source
  • Excel as a Source
  • Flat Files as a Source
  • Azure as a Source
  • SharePoint as a Source
  • Sorting During Load
  • None
  • 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.

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.

  • Querying with MDX
  • Basic DAX Syntax
  • Evaluation Context
  • Calculate Function
  • Time Intelligence
  • DAX Syntax
  • DAX Data Types and Operator Overloading
  • DAX Operators
  • DAX Values
  • Measures
  • Calculated Columns
  • Evaluation Contexts
  • Date Calculations
  • 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.

In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.

  • Importing Related Tables
  • Creating Relationships
  • Hierarchies
  • Direct Query
  • KPIs
  • Drillthrough
  • Perspectives
  • Creating Relationships
  • Hierarchies
  • 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.

In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.

  • Working with PowerPivot
  • Working with Pivot Tables
  • Working with PowerView
  • Importing Data
  • Importing Large Datasets
  • Importing Data with a Query
  • Creating Relationships
  • Creating a Cascading Relationship
  • Power View
  • Understand and utilize PowerPivot.
  • Understand and utilze Pivot Tables.
  • Understand and utilize Power View.