SQL Analysis

Return to schedule


Course Title SQL Analysis
Course Number 900-049-EQ
Platform Windows
Duration 24 hours
Gouvernement du Québec fee (taxes incl.)
General Public fee (taxes incl.)
Schedule Saturday 9:00 a.m. – 4:30 p.m.;  Last class 9:00 a.m. – 12:00 p.m.
(30 minutes for lunch)
Dates Winter 2019
Prerequisites SQL – Beginner, Intermediate, Advanced and/or experience with Microsoft SQL Server
Target Audience  This course is aimed at data analysts, Business Intelligence developers, consultants or members of BI development teams who are about to create a project using Microsoft SQL Server Analysis Services Tabular Model.
Instructor Khattar Daou
Location Brittain Hall /  BH-214

NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours

Course Description:

Microsoft SQL Server Analysis Services (SSAS) provides Online Analytical Processing (OLAP) and data mining features and capabilities to business intelligence (BI) projects and solutions. The tabular model in Analysis Services provides an easy-to-use and handy way for business users to access their data.

Analysis Services also offers rich experiences to BI users through interoperability in Microsoft Office and Microsoft SharePoint Server, helping people gain, use, and share insight.

This training course describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project and we’ll be focusing exclusively on Tabular Model. You will learn how to simplify the process of building complex solutions by taking advantage of the rich modeling capabilities in Analysis Services.

Topics to be covered:
Module 1 – Microsoft SQL Server Analysis Services (SSAS)
• Introducing Microsoft SQL Server Analysis Services (SSAS).
• What Is Analysis Services and Why Should I Use It?
• Describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project.
• Understanding the SQL Server Data Tools Tabular Model Authoring Environment

Module 2 – Analysis Services 2012 Architecture
• The Tabular Model
• Data Sources
• Import Data
• Understanding Data Analysis Expressions (DAX) in Tabular Models

Module 3 – Microsoft SQL Server Data Tools
• Working with SQL Server Data Tools
• Create a new tabular model project in SQL Server Data Tools.
• Import data from a SQL Server relational database into a tabular model project.
• Create and manage relationships between tables in the model.
• Create and manage calculations, measures, and Key Performance Indicators that help users analyze model data.
• Create and manage perspectives and hierarchies that help users more easily browse model data by providing business and application specific viewpoints.
• How to create partitions that divide table data into smaller logical parts that can be processed independent

Module 4 – Building a Tabular Model
• Loading Data into Tables
• Working in the Diagram View
• Rename columns
• Creating calculated columns and measures using DAX formulas
• Deployment

Module 5 – Querying a Tabular Model in Excel
• Connecting to a Tabular Model
• Browsing a Workspace Database
• Connecting to a Deployed Database
• Filter the table data prior to importing

Module 6 – Querying a Tabular Model in Power View
• Creating a Connection to a Tabular Model
• Building a Basic Power View Report
• Adding Charts and Slicers
• Interacting with a Report