SQL Server Analysis Services - SSAS, Data Mining & Analytics (Udemy.com)
Develop SSAS cubes from data warehouse on Multidimensional & Tabular modes with Dimensional & Data Mining Models
Created by: Siddharth Mehta
Last updated March 2019
What you will learn
- Downloadable Course Content - FREE SQL Server 2016 EBook, 150+ Interview Questions, 100+ curated reference material links, 70+ MDX / DAX Queries, Links to 1 Sample OLTP Database and 1 Sample Data Warehouse with sample data - schema diagrams - documentation - dimensional modeling workbook, 1 Sample Multidimensional OLAP Database + 1 Sample Tabular OLAP Database containing fully functional cube with sample data, and Full project developed in the course.
- By end of this course, you should be able to work with actual clients, technology architects, or team leads on a large scale SQL Server Analysis Services / MDX / Data Mining Project
- Learn SQL Server Analysis Services ( SSAS ) Multi-dimensional as well as Tabular, Multidimensional Data Expressions ( MDX ) query language, Data Analysis Expressions (DAX) expression language and Data Mining on latest version of SQL Server - 2016 on a fast track with more practicals and limited theory necessary for fundamentals.
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.3 out of 5higher than 22% of them
- Reviews1,322#125 of 389 by number of reviews
- Length7.9 hourslonger than 59% of them
- Last updatedMarch 2019earlier than 74% of them
Course Description
Top 4 Reasons to take this course:
1) You can learn SSAS, Data Mining and Analytics from scratch as well as ask questions directly to a Published Author, Microsoft MVP, and a Senior Technology Architect with more than 15 years of experience who actively practices Business Intelligence, Data Mining and Analytics in real-world client projects internationally.
2) In a single course, without any prior analytics experience - You can learn three query languages used for analytics - MDX, DAX and DMX. Along with this you learn SSAS in such detail that you can apply for a job of SSAS Developer / Admin / Architect, and also prepare yourself for Microsoft certification 70-768.
3) You get to train yourself for any SSAS, MDX, DAX, and Data Mining interview with more than 150+ interview questions. If you still have any questions, you can ask those questions to me.
4) Downloadable Course Content:
FREE SQL Server 2016 EBook Link
150+ Interview Questions
100+ curated reference material links
70+ Ready-to-use MDX / DAX Queries
Links to 1 Sample OLTP Database and 1 Sample Data Warehouse with sample data - schema diagrams - documentation - dimensional modeling workbook
Links to 1 Sample Multidimensional OLAP Database + 1 Sample Tabular OLAP Database containing fully functional cube with sample data
Full project developed in the course.
Course Description
SQL Server Analysis Services, Data Mining and Analytics is a course in which a student having no experience in data science and analytics would be trained step by step from basics to advanced data science topics like data mining. The intention of this course is to empower students with the knowledge of OLAP, Analytics and Data Mining, which can potentially yield salaries of $85 - $150k based only on your experience of SSAS, MDX, DAX and Data Mining.
Course includes job-oriented practical hands-on exercises, theoretical coverage of key concepts, interview questions, practice test questions for certifications and more. This course covers all the topics for developers, administrators as well as aspiring data scientists. New Interview questions are added to the course every few weeks. Anyone pursuing this course would be able to clearly understand about Microsoft Business Intelligence Architecture, and understand how SSAS and Data Mining fits in this architecture along with other tools like SSIS, SSRS, Master Data Services ( MDS ), Data Quality Services ( DQS ), Powerpivot, PowerView, SQL Server Database Engine, SSMS, SSDT and other tools.
SQL Server Analysis Services, Data Mining and MDX is a fast track course to learn practical SSAS ( SQL Server Analysis Services ), Data Mining and MDX code development using the latest version of SQL Server - 2016. No prior experience of working with SSAS / Data Mining or MDX is required.
The course is structured in the following categories: Fundamentals, Design, Development, MDX Code development, Administration, Performance Tuning, Data Mining Basics and Data Mining Development, Tabular SSAS Installation and Configuration, and Tabular SSAS Design and Development as well as DAX programming.
Instructor Details
- 4.3 Rating
1,322 Reviews
Siddharth Mehta
Udemy's Top 10% of most engaging instructors
My name is Siddharth Mehta. I have career experience of more than 15 years in the IT Industry and am presently working as Enterprise Cloud Architect. I am published author on many online and print-media publications. I have taught thousands of students on Udemy and have number of courses on Data and Analytics.
Would you consider learning from just any hobbyist who knows programming or someone who just teaches programming without practically using it in the real world, or someone who has experience of using the technology in real world on multi-million dollar large-scale projects globally ? I will teach you everything I know about the subject, from my years of practical experience in the field of BI, Data, Analytics, Cloud and Data Science.
If you are interested in learning more about me, below are some of my career highlights:
I have career experience of more than 15+ years and am presently working in New York Metro region as Enterprise Architect for a life-sciences proprietary multi-tenant product technology portfolio, managing an ecosystem of ISVs and tenants. Below are some of my career highlights:
-|- International experience of working across geographies (US, UK, Singapore) for multi-national clients in Banking, Logistics, Government, Media Entertainment, Products, Life Sciences and other domains
More courses by Siddharth Mehta
Mastering AWS Glue, QuickSight, Athena & Redshift Spectrum (2020)
3.8 (3,745 Reviews)
Provider: Udemy
Time: 18.4h
$10.99
Mastering Amazon Redshift Development & Administration (2022)
4.3 (2,552 Reviews)
Provider: Udemy
Time: 18.3h
$10.99
AWS Data Architect Bootcamp - 43 Services 500 FAQs 20+ Tools (2019)
4.5 (1,340 Reviews)
Provider: Udemy
Time: 30.4h
$15.99
SQL Server Master Data Services for Master Data Management (2019)
4.0 (289 Reviews)
Provider: Udemy
Time: 2.7h
$49.99
Mastering SSRS Reports Development for Mobile Devices (2019)
4.3 (38 Reviews)
Provider: Udemy
Time: 6h
$39.99
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Iber.DIGITAL Cristina Loredana Coca Z032 on 9/16/2019
Goes on fast forward mode on 99% of the concepts. The course is fine if used like an "index". Lessons are of 5-15 minutes, explained briefly and after each of them I needed to spend hours in search of additional material. The course is fine, it gives a broad perspective and gives you a path of learning, but prepare for an intensive search of your own. Still quite good, just don't expect to just do this course and become a certified expert.
By Craig A. Simmons on 5/25/2019
Thank you for a really good informative course. I learned so much from it. I signed up for this course with the premise that there was a Completion Certificate at the conclusion. Is there a place that I am not looking to find my Certificate? Thank you again.
By Godspower Onwuka on 10/30/2018
Wow. This course is loaded and rich in content. I enjoyed learning the course and have acquired much knowledge in SSAS. I followed the course tutor patiently in all the course slides and practice alongside as he progress, as I got to the middle of the course I understand very quick ahead and that really helped me to finish the course. I will recommend this course to anyone who is serious to learn without being critics, learning with patience, hands-on practice and I-can-do mentality. You will certainly gain a good measurable knowledge in this course.
By Darek Spiewak on 5/2/2018
This course is good but could be so much better. It's comprehensive, true, but some topics should still be presented in more depth, e.g., MDX or Data Mining. Just an opinion of mine. MDX is a very powerful language and has great capabilities... as well as many gotchas. And it's the gotchas that people should be aware of; these, however, were not touched upon in the course. For instance, subcubes are very often tricky to get right and don't always behave the way people would want them to. This should be studied in more depth. Also, data mining is a big, big topic and I think more time should have been devoted to it. But overall, it's not bad. I'm pretty satisfied with the content. Thank you.
By Abhishek Mitra on 2/6/2018
HI, Siddharth has explained each and every concept in BI & SSAS in a beautiful manner with a proper example that help me a lot to understand that how to understood to architecture of SSAS and designing the cube and others concepts of Datawarehousing /Business Intelligence. Thanks a lot.
By Christos Tsiaras on 1/8/2018
I particularly liked that almost everything that I was expecting to listen has been covered in this course. A few parts were too slow and other parts too fast. There was more time spend in topics easy to understand and less time spent in harder areas. Some of the questions have typos or are not clear. I would recommend reviewing questions. Overall it is a nice course which I recommend and I will certainly use the material as reference. Thanks!
By Avik Sadhu on 7/5/2017
I found the quality is overall better than average but couple of things need to be included that I mentioned in Q&A interactions with trainer like extended events for performance tuning in SSAS. Second more in depth syntax for DAX (intermediate level) should be included like MDX - one session is not sufficient. Third cube processing thru SSIS incrementally should be included.
By Brian Swinderman on 6/28/2017
So far, this has only built 1 extremely simple cube. I would like to see more cube examples. Administration section wasn't useful to me but might be for a DBA. I think building more cube structures would be helpful. Maybe building a cube with more than 1 perspective would be helpful. After completing the course, I increased my rating from a 2 start to 3 1/2. The sections on Data Mining were more in-depth on the different functions available. The instructor also went into more detail in the sections on Tabular SSAS. I still stand by my original comments about needing more instruction on building cubes. If that section had more examples with a little more complexity, I would have rated the course much higher.
By Lakeside David-Debo on 4/19/2017
A very elaborate, thorough and interesting course. Though I struggled a bit owing to the instructor's accent and low sound quality of the video in some sections but, overall, I feel it is a good course and it will definitely get me from Zero to Hero. This is one of those courses that I'll definitely recommend to anyone looking to get a headstart in the field of Data Mining & Analytics. You'll definitely get a bang for your buck! No doubts!
By Rafeeq Badiger on 3/24/2017
Based on what I have learnt it is a very good course on SSAS. Tutorials are to the point and clearly explained. Quiz questions keep you engaged and helps to quickly recollect the information you learnt. I am able to easily follow and do hands on at the same time.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 86 / 100











