This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.
This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.
The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.
This module explains how the class will be structured and introduces course materials and additional administrative information.
Introduction
Course Materials
Facilities
Prerequisites
What We’ll Be Discussing
Course Overview
Lab lessons not available
Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.
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.
Analysis Services Installation and Architecture: One Product, Two Models
Version Changes: SQL Server Analysis Services
Important Terms
SQL Server Data Tools for Tabular
What is the Tabular Model
SQL Server Data Tools for Tabular
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.
In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.
Projects
Importing
Loading Data
Examining Views
Deployment
Working in Tabular
Creating a Tabular Project
Understand and utilize projects.
Understand and utilize importing.
Understand and utilize loading data.
Understand and utilize examining views.
Understand and utilize deployment.
In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.
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
Understanding Loading Data From Different Sources
Lab lessons not available
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.
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.
Querying with MDX
Basic DAX Syntax
Evaluation Context
Calculate Function
Time Intelligence
Using DAX and MDX
DAX Syntax
DAX Data Types and Operator Overloading
DAX Operators
DAX Values
Measures
Calculated Columns
Evaluation Contexts
Date Calculations
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.
In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.
Importing Related Tables
Creating Relationships
Hierarchies
Direct Query
KPIs
Drillthrough
Perspectives
Building Data Models
Creating Relationships
Hierarchies
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.
In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.
Working with PowerPivot
Working with Pivot Tables
Working with PowerView
Excel PowerPivot and Tabular
Importing Data
Importing Large Datasets
Importing Data with a Query
Creating Relationships
Creating a Cascading Relationship
Power View
Understand and utilize PowerPivot.
Understand and utilze Pivot Tables.
Understand and utilize Power View.
Sign Up to our newsletter, and stay always up to date with latest IT certifications
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
View all the provided certifications and there relevant courses. Book online for a certification exam.
Copyright reserved to ICTC. Proudly Crafted by GTP Works