55163: Preparing Your Data for Power BI Training

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

Lab: Course Overview

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.

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

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.

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

Lab: Working in Tabular

• Creating a Tabular Project

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.

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

Lab: Understanding Loading Data From Different Sources

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.

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

Lab: Using DAX and MDX

• DAX Syntax
• DAX Data Types and Operator Overloading
• DAX Operators
• DAX Values
• Measures
• Calculated Columns
• Evaluation Contexts
• Date Calculations

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.

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

Lab: Building Data Models

• Creating Relationships
• Hierarchies

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.

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

Lab: Excel PowerPivot and Tabular

• Importing Data
• Importing Large Datasets
• Importing Data with a Query
• Creating Relationships
• Creating a Cascading Relationship
• 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.