Skip to content
UdemySQLPaid courseAll LevelsCertificate

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

icon
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

icon
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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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

icon
More courses by Siddharth Mehta

$10.99

$10.99

$15.99

$49.99

$39.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.3

1,322 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 1,322 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100