SQL Analysis Services (SSAS)

Return to schedule




Course title SQL Analysis Services (SSAS)
Course number 900-049-EQ-02
Platform Windows
Duration 24 hours
Emploi-Québec fee (taxes incl.) $48
General public fee (taxes incl.) $571.20
Schedule Saturday; 9 a.m. – 4:30 p.m. (30 minute lunch)
Dates February 8, 15, 22, 29; First class on February 8, 1 p.m. – 4 p.m.
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 BH-407
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 will 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