Data Modeling with SQL Business Intelligence 

POWER BI FLOWCHART

Course Duration: 2 Days

About This Course

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular model, data modeling, and DAX.

Audience Profile

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

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 drill through.
  • Understand perspectives.
  • Understand and utilize PowerPivot.
  • Understand and utilize Pivot Tables.
  • Understand and utilize Power View.

Prerequisites

MS DA-100 Analyzing Data with Power BI

OR

MS PL 300 Microsoft Power BI Data Analyst

Course Outline

Module 1: Course Overview

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

Module 2: What is the Tabular Model?

Lessons

  • Analysis Services Installation and Architecture: One Product, Two Models
  • Version Changes: SQL Server Analysis Services
  • Important Terms
  • SQL Server Data Tools for Tabular

Module 3: Working in Tabular

Lessons

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

Module 4: Working in Tabular

Lesson

  • 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

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

Module 6: Using DAX and MDX

Lessons

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

Module 7: Building Data Models

Lessons

  • Importing Related Tables
  • Creating Relationships
  • Hierarchies
  • Direct Query
  • KPIs
  • Drillthrough
  • Perspectives

Module 8: Excel PowerPivot and Tabular

Lessons

  • Working with PowerPivot
  • Working with Pivot Tables
  • Working with PowerView