Course 55163-A: Preparing Your Data for Power BI

Microsoft

Course 55163-A: Preparing Your Data for Power BI

Share This Learning Path

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.

Prerequisites

Course outline

Module 1: Course Overview

Module 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 Sessions

Course Overview

Lab Lessons

Lab lessons not available

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

Module Overview

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 well 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 Sessions

What is the Tabular Model

Lab Lessons

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.

Module 3: Working in Tabular

Module Overview

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

Lessons

Projects
Importing
Loading Data
Examining Views
Deployment

Lab Sessions

Working in Tabular

Lab Lessons

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.

Module 4: Understanding Loading Data From Different Sources

Module Overview

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

Lessons

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 Sessions

Understanding Loading Data From Different Sources

Lab Lessons

Lab lessons not 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 5: Using DAX and MDX

Module Overview

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 well cover DAX and walk-through how to use this powerful language.

Lessons

Querying with MDX
Basic DAX Syntax
Evaluation Context
Calculate Function
Time Intelligence

Lab Sessions

Using DAX and MDX

Lab Lessons

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.

Module 6: Building Data Models

Module Overview

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

Lessons

Importing Related Tables
Creating Relationships
Hierarchies
Direct Query
KPIs
Drillthrough
Perspectives

Lab Sessions

Building Data Models

Lab Lessons

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.

Module 7: Excel PowerPivot and Tabular

Module Overview

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

Lessons

Working with PowerPivot
Working with Pivot Tables
Working with PowerView

Lab Sessions

Excel PowerPivot and Tabular

Lab Lessons

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.

Book Your Seat

Find Learning Paths

Course AZ-800T00-A: Administering Windows Server Hybrid Core Infrastructure

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center