Course Code: 18967

55163 Preparing Your Data for Power BI

Class Dates:
11/4/2021
9/2/2021
Length:
2 Days
Cost:
$995.00
Class Time:
Technology:
Office
Delivery:

Overview

  • Course Overview
  • This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.
  • Audience
  • The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.

Prerequisites

Course Details

  • At Course Completion
  • 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 utilze Pivot Tables
  • Understand and utilize Power View
  • Module 1: Course Overview
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • Lab 1: Course Overview
  • Module 2: What is the Tabular Model?
  • Analysis Services Installation and Architecture: One Product, Two Models
  • Version Changes: SQL Server Analysis Services
  • Important Terms
  • SQL Server Data Tools for Tabular
  • Lab 1: What is the Tabular Model?
  • Module 3: Working in Tabular
  • Projects
  • Importing
  • Loading Data
  • Examining Views
  • Deployment
  • Lab 1: Working in Tabular
  • Module 4: Working in Tabular
  • Understand and utilize projects.
  • Understand and utilize importing.
  • Understand and utilize loading data
  • Understand and utilize examining views
  • Understand and utilize deployment
  • Module 5: Understanding Loading Data From Different Sources
  • 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 1: Understanding Loading Data From Different Sources
  • Module 6: Using DAX and MDX
  • Querying with MDX
  • Basic DAX Syntax
  • Evaluation Context
  • Calculate Function
  • Time Intelligence
  • Lab 1: Using DAX and MDX
  • Module 7: Building Data Models
  • Importing Related Tables
  • Creating Relationships
  • Hierarchies
  • Direct Query
  • KPIs
  • Drillthrough
  • Perspectives
  • Lab 1: Building Data Models
  • Module 8: Excel PowerPivot and Tabular
  • Working with PowerPivot
  • Working with Pivot Tables
  • Working with PowerView
  • Lab 1: Excel PowerPivot and Tabular