Call us or whatsapp us 08103382376  or Request a call back !

Microsoft SQL Server Analysis Services (SSAS)

5 Day Microsoft SQL Server Analysis Services (SSAS) Intensive Course  – Make sense of data

What is Analysis Services ?

Microsoft SQL Server Analysis Services (SSAS) is an online analytical data engine which is used in decision support and Business Analytics providing analytical data for business reports and client applications such as Excel, Reporting Services reports and other data visualization tools.

About the course

This 5 day course will give delegates a thorough study on using Microsoft SQL Server Analysis Services. The course will teach participants how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement Multidimensional OLAP (Online Analytical Processing) cubes to support Business Intelligence Solutions. The couse will explain how to develop Analysis Services databases, starting with dimensional modelling process and continuing with the development of dimensions and cubes. The course will teach participants how to deploy and process Analysis Services databases. This course assumes no prior experience with Analysis Services.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft SQL Server Analysis Services (SSAS).

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: Basic knowledge of Business Intelligence and relational database systems.

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1
Introduction to SQL Server Analysis Services

  • Business Intelligence Overview
  • What is Microsoft Business Intelligence?
  • Overview of SQL Server Analysis Services
  • Introduction to SQL Server Data Tools
  • Understanding and Configuring Visual Studio
  • Overview of OLAP and OLTP
  • Data Warehouse Design
  • Creating a SSAS Project
  • Creating an Analysis Services Database

Understanding Data Sources and Data Source Views

  • Supported SSAS Data Sources
  • How to create a Data Source using the Data Source View Wizard & Designer
  • How to create a Data View

Day 2
Understanding SSAS Cubes

  • What are Cubes
  • Creating Cubes with the Cube Wizard
  • Creating Cube Dimensions
  • Relationship Types:No Relationship, Regular, Fact, Many to Many
  • Measure and Measure Groups
  • Formatting Measures
  • Calculated Members: Creating Calculations
  • Formatting Calculations
  • Creating Perspectives
  • Creating Translations
  • Browsing Perspectives and Translations
  • Deploying Browsing a Cube
  • How to query a cube in SQL Server Management Studio

Dimension Design

  • The Dimension Wizard
  • Working with the Dimension Designer:Attributes, Attribute Relationships ,User Hierarchies
  • Role Playing Dimensions
  • Referenced Dimensions
  • Browsing a Dimension
  • Defining Translations in Dimensions
  • Creating Snowflake Dimensions
  • Deploying Dimensions

Day 3
Introduction to MDX Queries

  • What is MDX
  • Understanding MDX Syntax
  • Using MDX Query editor in SSMS
  • Understanding MDX Functions and Tasks
  • Understanding Measures and Measure Groups
  • Hierarchies & Hierarchy Levels
  • Members
  • Cells
  • Tuples
  • Sets
  • MDX Queries

SSAS Administration

  • Implementing SSAS Security
  • Implementing XMLA Scripts in SSMS
  • Processing SSAS Objects
  • Managing Partitions
  • Understanding SSAS Database Backup and Restore

Day 4
Managing Deployment

  • Deployment Overview
  • Deployment Mechanics
  • Deployment using SQL Server Data Tools
  • Deployment using Deployment Wizard
  • Understanding Deployment Scripts

Managing Partitions and Database Processing

  • Understanding Dimension Storage Modes
  • Understanding Partition Storage Modes
  • Processing a Dimension
  • Processing a Cube
  • Working with Partitions
  • Creating Partitions

Day 5
Implementing Security

  • Understanding Roles
  • Securing Administrative Access
  • Assigning Database level administrative Access
  • Securing Data Access
  • Granting Access to Cubes
  • Restricting Access to Dimension Members
  • Restricting Access to Cells

Advanced Monitoring and Management Tools

  • Monitoring Analysis Services using Windows Reliability and Performance Monitor
  • Monitoring Analysis Services using SQL Server Profiler

Retrieving Data and Analysing Cubes with Microsoft tools

  • Accessing Analysis Services using Excel 2007
  • Creating Reporting Services Reports
  • Analysing Data in Excel
  • Analysing Data in PowerPivot

Your Trainer

Our international certified trainers are highly experienced Microsoft SQL Server Analysis Services practitioners who have real-world expertise.

Key Information

I – All course material including a copy of Microsoft Analysis Services Unleashed book will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed Microsoft Analysis Services.

IIII – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire use the form above or call 08103382376

    Your Name (required)

    Your Email (required)



    Your Message

    Microsoft SQL Server Analysis Services Course

    ₦300,000per course