|Course Title||SQL Analysis
|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)
|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.|
|Location||Brittain Hall / BH-214|
NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
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
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