Ottawa - Albert & Metcalfe

116 Albert Street, Ottawa, Canada, K1P 5G3

Across the street from the World Exchange Plaza. The Ottawa Shaw Centre and CF Rideau Centre shopping mall 10 minutes away.

Ottawa - 343 Preston

Regus, 343 Preston Street, Ottawa, Canada, K1S 1N4

On the top floor of a distinctive office tower that's highly visible from Highway 417, you will find Regus 343 Preston Centre in Ottawa. Only a 10 minute drive from downtown Ottawa, a short stroll away from Downs Lake, and located near the lively intersection of Preston Gladstone in Little Italy.

Explore Our Courses

Business Intelligence with SSAS

 14 Hours
SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools. In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses. By the end of this training, participants will be able to:
  • Install and configure SSAS
  • Understand the relationship between SSAS, SSIS, and SSRS
  • Apply multidimensional data modeling to extract business insights from data
  • Design OLAP (Online Analytical Processing) cubes 
  • Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
  • Deploy real-world BI solutions using SSAS
Audience
  • BI (Business Intelligence) professionals
  • Data Analysts
  • Database and data warehousing professionals
 
Format of the Course
  • Interactive lecture and discussion
  • Lots of exercises and practice
  • Hands-on implementation in a live-lab environment
Course Customization Options
  • This training is based on the latest version of Microsoft SQL Server and SSAS.
  • To request a customized training for this course, please contact us to arrange.
Read more...

Last Updated:

Upcoming Courses

Business Intelligence with SSAS

2025-06-30 09:30
14 hours
Ottawa - Albert & Metcalfe
CA$ 3,514 (Online)
CA$ 4,034 (Classroom)

Business Intelligence with SSAS

2025-07-14 09:30
14 hours
Ottawa - 343 Preston
CA$ 3,514 (Online)
CA$ 4,074 (Classroom)

Business Intelligence with SSAS

2025-07-28 09:30
14 hours
Ottawa - Albert & Metcalfe
CA$ 3,514 (Online)
CA$ 4,034 (Classroom)

Other regions in Canada

Other Countries

These courses are also available in other countries

Consulting

SSAS Consulting
Online SQL Server Analysis Services training in Ottawa, SSAS (SQL Server Analysis Services) training courses in Ottawa, Weekend MS SQL Server Analysis Services courses in Ottawa, Evening MS SSAS training in Ottawa, MS SSAS instructor-led in Ottawa, MS SSAS instructor in Ottawa, Online MS SQL Server Analysis Services training in Ottawa, SSAS private courses in Ottawa, MS SQL Server Analysis Services one on one training in Ottawa, Weekend Microsoft SSAS training in Ottawa, SQL Server Analysis Services (SSAS) coaching in Ottawa, Microsoft SQL Server Analysis Services trainer in Ottawa, MS SQL Server Analysis Services classes in Ottawa, Evening Microsoft SQL Server Analysis Services courses in Ottawa, SQL Server Analysis Services instructor-led in Ottawa, SQL Server Analysis Services (SSAS) boot camp in Ottawa, MS SQL Server Analysis Services on-site in Ottawa