Course Duration
4 Weekends
Course Price
₦ 50,000.00
Course Level
Beginner-Intermediate
Course Overview
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, participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses. PostgreSQL, Oracle and more.
What You Will Learn
- Install and configure SSAS
- Understand the relationship between SSAS, SSIS, and SSRS
- Apply data modelling to extract business insights from data
- Design OLAP (Online Analytical Processing)
- Query and manipulate data using the DAX query language
- Deploy real-world BI solutions using SSAS
Course Requirements
- A working PC
- Prior knowledge of SQL
Target Audience
- BI (Business Intelligence) professionals
- Data Analysts
- Database and data warehousing professionals
