Building OLAP Solutions using SQL Server Analysis Services
The “Building OLAP solutions using SQL Server Analysis Services” course builds on the beginner and intermediate Excel skills you have already mastered either on the job or personally. This course is designed for individuals with no prior experience in SSAS. In this course, you will learn how to create Tabular OLAP cubes. You will also familiarize yourself with DAX expressions
Target Audience
- Beginners (New to SSAS)
- Experienced developers willing to enhance their SSAS Skills
Course format
- Both in-class and online class options are available
- Homework is assigned after every class
- Students will be assigned individual projects at the beginning of the course which they will work on throughout the duration of the course
- Each student will give a presentation on the final project at the end of the course
- We provide continuous support after completion of this program. Students are also given 24/7 access to online resources.
- Students are assigned projects to work on and present at the end of the course
- 12 months contnuous support after completion of course
Cost & Payment Terms
The cost of this 8 week course is $2,000.
There are 2 payment options:
- Option 1: Full payment due at the beginning of the course
- Option 2: Half due at the beginning of the course and remaining half due by the beginning of week 4
Discounts are available to those who qualify
Course Dates & Duration
The normal course duration is 60 hours, spread over 8 weeks. Classes will be held on weekday evenings, and on weekends.
Prerequisites
knowledge of T-SQL
Intermediate understanding of database design and concepts
Course Outline
Part I: Tabular OLAP Model (16 hours)
- OLAP basics
- Tabular Model Architecture
- Visual Studio and Server Setup
- Data modeling Overview (Using PowerPivot)
- Creating a tabular model
- Loading data into a tabular model
Part II: Data Analysis Expression (30 Hours)
- DAX - Basic
- Understanding Evaluation Context
- Time Intelligence in DAX
- DAX - Advanced
Part III: Tabular Cube Administration (14 hours)
- Security
- Deployment
- Optimization
- Partitioning
- Processing Options
- Monitoring