IE Warning
Your browser is out of date!

This website uses the latest web technologies so it requires an up-to-date, fast browser!
Try Firefox or Chrome!
Back to top
Twitter Logo
LinkedIn Logo Google+ Logo
Telephone: 023 9270 4041

Microsoft SQL Sever LogoMicrosoft SQL Server Analysis Services (SSAS) Course

Course Objectives

Microsoft SQL Server Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting you design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases. For data mining applications, Analysis Services lets you design, create, and visualise data mining models that are constructed from other data sources by using a wide variety of industry-standard data mining algorithms.

Course Modules

The following modules will be will be covered on the course.

  1. Introduction to SSAS
  2. Multidimensional BISM
  3. Understanding MDX
  4. Data Sources & Data Source Views
  5. Dimension Design
  6. Cube Design
  7. Advanced Dimension Design
  8. Advanced Cube Design
  9. Administration and Management
  10. Data Mining
  11. Analysis Cubes
  12. BISM Tabular Mode and PowerPivot

Target Audience

This course is intended for end users to Microsoft SQL Server.

Course Reviews

I have attended all the SQL Server courses, this was the last for me and has tied everything together. I am looking forward to putting all the skills that I have learnt into practice. Thank you.
William Martin - Portsmouth International Port