Request or Schedule a Class

Data Modeling with SQL Business Intelligence 

POWER BI FLOWCHART

Course Duration: 2-Days

Course Overview

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

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

At Course Completion

  • Analyze Services Installation and Architecture:  One Product, Two Models
  • Utilize of SQL Server Data Tools for Tabular
  • Import, load data, and examine views in data sources
  • Utilize SQL, Excel, Flat Files, Azure, and SharePoint as data sources
  • Query data with MDX and DAX
  • Understand DAX data types, operator overloading, and operations
  • Import related tables and create relationships, hierarchies, and KPIs.
  • Understand Direct Query, drill through, and perspectives
  • Integrate Power Pivot and  Pivot Tables

Prerequisites

MS PL 300 Microsoft Power BI Data Analyst

Course Outline

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

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

Working in Tabular

  • Projects
  • Importing
  • Loading Data
  • Examining Views
  • Deployment
  • Understand and utilize projects.
  • Understand and utilize importing.
  • Understand and utilize loading data.
  • Understand and utilize examining views.
  • Understand and utilize deployment.

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

DAX and MDX

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

Building Data Models

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

Excel PowerPivot and Tabular

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

You may also be interested in:

Power BI

Dax for Business Intelligence

MS PL 300 Microsoft Power BI Data Analyst