Preparing Your Data for Power BI

Session Detail:    Classroom 2 Day

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

Prerequisites

A working knowledge of SQL Server.

Who Can Benefit

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

Session Outline

Class Outline

Module 1: Course Overview

  • Lesson 1: Introduction
  • Lesson 2: Course Materials
  • Lesson 3: Facilities
  • Lesson 4: Prerequisites
  • Lesson 5: What We’ll Be Discussing

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?

  • Lesson 1: Analysis Services Installation and Architecture: One Product, Two Models
  • Lesson 2: Version Changes: SQL Server Analysis Services
  • Lesson 3: Important Terms
  • Lesson 4: 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

  • Lesson 1: Projects
  • Lesson 2: Importing
  • Lesson 3: Loading Data
  • Lesson 4: Examining Views
  • Lesson 5: Deployment

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

  • Lesson 1: Data Sources
  • Lesson 2: Data Credentials
  • Lesson 3: SQL as a Source
  • Lesson 4: Excel as a Source
  • Lesson 5: Flat Files as a Source
  • Lesson 6: Azure as a Source
  • Lesson 7: SharePoint as a Source
  • Lesson 8: Sorting During Load

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

  • Lesson 1: Querying with MDX
  • Lesson 2: Basic DAX Syntax
  • Lesson 3: Evaluation Context
  • Lesson 4: Calculate Function
  • Lesson 5: Time Intelligence

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

  • Lesson1: Importing Related Tables
  • Lesson 2: Creating Relationships
  • Lesson 3: Hierarchies
  • Lesson 4: Direct Query
  • Lesson 5: KPIs
  • Lesson 6: Drillthrough
  • Lesson 7: Perspectives

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 drill through
  • Understand perspectives

Module 7: Excel PowerPivot and Tabular

  • Lesson 1: Working with PowerPivot
  • Lesson 2: Working with Pivot Tables
  • Lesson 3: Working with PowerView

After completing this module, students will be able to:

  • Understand and utilize PowerPivot
  • Understand and utilize Pivot Tables
  • Understand and utilize Power View

Need to train your team?

All of our sessions can be customized to meet your team’s specific needs. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Preparing Your Data for Power BI

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now