SQL Server Analysis Services - SSAS, Data Mining & Analytics
4.1 (317 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,028 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Analysis Services - SSAS, Data Mining & Analytics to your Wishlist.

Add to Wishlist

SQL Server Analysis Services - SSAS, Data Mining & Analytics

SQL Server, SSAS, MDX, DAX, Data Warehouse, Data Mining, Multi Dimensional Data Modeling, Tabular Model, SSRS, Power BI
4.1 (317 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,028 students enrolled
Created by Siddharth Mehta
Last updated 5/2017
English
Current price: $50 Original price: $200 Discount: 75% off
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 20 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
  • Develop Data Mining Models on algorithms like Decision Trees, Naive Bayes, Clustering, Neural Network, Time Series, Linear Regression and Sequence Clustering
  • Test your knowledge with more than 150 SSAS, MDX, DAX and Data Mining interview or Microsoft BI certification practice test questions. Every few weeks, new interview questions are added to the course.
  • Design, Model and Build SSAS database, data warehouse or data mart, and database objects like facts, dimensions, cubes, measures, perspectives, etc
  • Deploy SSAS solutions and learn SSAS administration tasks like backup and restore, processing dimensions and measures, building aggregations, etc
  • Develop MDX and DAX code with confidence
  • Develop SSRS Reports using MDX as query language and SSAS as data source
  • Debug issues and performance tune SSAS solutions for optimal performance
  • Learn about Microsoft Business Intelligence Architecture, and understand how SSAS 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.
View Curriculum
Requirements
  • No prior knowledge of SSAS, MDX, Dimensional modeling or Data Mining is required.
  • Basic working knowledge of SQL Server like working with tables, views, stored procedures etc is required.
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 14 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.

Who is the target audience?
  • Open minded professionals seeking to give a competitive edge to their carrer in the field of data and analytics should definitely consider in enrolling for this course
  • This course is for those who want to start a career in the analytics space by learning a niche skill
  • If you are planning to appear for a SSAS job interview or MS BI Certification, this course is for you
  • Students planning to take 70-768 microsoft certification should enroll in this course as the course covers almost entire topics of the exam.
  • Data mining professionals are very rare and having even a basic or intermediate training on Data Mining is a huge plus. Students who wants to add a plus on their resume should take this course.
  • MDX developers are one of the most sought after professionals in the analytics data space. This course is for those who are ready to invest their time in a complex skill to differentiate themselves from the crowd.
  • This course is specially designed for those working or who want to work in the role of MS BI Architect, MDX Developer, SSAS Administrator, SSAS Architect, SSAS Developer, Data Modeler, MS BI Developer, SSAS Performance Engineering Specialist and others
  • SSAS Tabular and DAX is the newest trend in the self-service Analytics using SSAS. Students interested in this part of the BI should enroll in this course
Curriculum For This Course
78 Lectures
07:54:06
+
Introduction
1 Lecture 11:56

This lecture covers author introduction, reasons to learn SSAS and MDX on SQL Server 2016.

Preview 11:56
+
Fundamentals and Technology Overview
8 Lectures 59:07

This lecture provides an overview of BI architecture components like Source Systems, Staging Zone, Landing Zone, Data Warehouse, Data Mart, Reports and Dashboards

Preview 07:49

This lecture provides an overview of Dimensional Modeling process and architecture

Analyzing Dimensional Model
14:26

This lecture contains resources for analyzing the sample data warehouse and sample OLTP database used as the source for dimensional modeling.

Resources for downloading and analyzing sample Data Warehouse and OLTP database
00:11

This lecture provides an overview of Business Intelligence Semantic Model

Business Intelligence Semantic Model Overview
07:51

This lecture provides an overview of SQL Server Analysis Services

SSAS Overview
14:17

This lecture provides an overview of Multidimensional Expressions

Multidimensional Expressions Overview
11:19

This lecture provides a quick comparison between different server modes of SSAS.

Comparison of SSAS Multidimensional, Tabular and Data Mining modes
00:51

This article contains of glossary of SSAS terms and their associated meaning in simplified non-technical language.

SQL Server 2016 Ebook Download Link and Glossary of SSAS Terminologies
02:23

This quiz contains interview questions related to SSAS and Dimensional Modeling

SSAS and Dimensional Modeling Interview Questions / Practice Test Exam Questions
13 questions
+
SQL Server Analysis Services (SSAS) Installation
3 Lectures 15:21

This lecture demonstrates the installation of SQL Server 2016 and SQL Server Analysis Services 2016

Installing SQL Server and SSAS
07:27

This lecture demonstrates configuration of some of the important SSAS server properties

Configuring SSAS
06:06

This section contains few FAQs and Links to further reference material on MSDN regarding SSAS Installation and Configuration.

Resources and FAQ for SSAS Installation and Configuration
01:48

This quiz contains interview questions related to SSAS Installation.

SSAS Installation and Config Interview Questions / Practice Test Exam Questions
6 questions
+
Cube Design and Development
8 Lectures 48:21

This lecture demonstrates installation of AdventureWorks Data Warehouse

Attaching Data Warehouse
04:15

This chapter demonstrates how to create a data source and data source view in SSAS 2016 using SSDT

Data Source and Data Source Views
08:03

This lecture explains how to create a cube using the SSAS Cube Wizard in SSDT and SQL Server 2016

Developing Cube using Cube wizard
04:53

This lecture covers the details of cube design like cube dimensions, measure groups etc

Cube Design
07:42

This lecture covers the details of dimension design and important properties related to dimensions

Dimension Design
11:49

This lecture demonstrates how to create user hierarchies and configure the same.

Hierarchy Design
03:18

This lecture demonstrates the process of cube deployment, and browsing the cube from SSMS

Preview 08:05

This article contains links to reference material for designing and developing SSAS Dimensions, Measures and Cubes.

Resources for Design and Development of SSAS Cube, Dimension, Measures
00:16

This quiz contains interview questions related to SSAS Cube Design, Dimension Design, Measures Design, Hierarchy Design and SSAS Cube Deployment.

SSAS Cube Development Interview Questions / Practice Test Exam Questions
20 questions
+
Multidimensional Expressions - Practical code development
10 Lectures 01:18:48

This lecture demonstrates the installation of SSAS 2016 Adventureworks database on the SSAS server

Installing OLAP database
05:26

This lecture demonstrates and explains different MDX queries related to MDX fundamentals

Fundamentals of MDX Query
10:33

This lecture demonstrates and explains different MDX queries related to browsing dimensions, attributes, members, cells, tuples, sets etc using MDX

Querying Object hiearchy - Dimensions, Attributes and Members
09:52

This lecture demonstrates and explains different MDX queries related accessing individual members of a dimension and sorting data in a MDX query

Navigating and Sorting data
11:36

This lecture demonstrates and explains filtering data using various MDX functions and methods.

Filtering Data
11:35

This lecture demonstrates and explains creation of a subcube, named sets, calculated sets and measures and other concepts using MDX query language

Named Sets and Subcubes
06:49

This lecture explains development of calculated measures and KPIs using MDX

Calculated Measures and KPIs
10:24

Learn how to use MDX in a SSRS Report to query data from SSAS Cube and report the same.

SSRS with MDX
08:06

This article contains 50+ ready to use MDX queries explained throughout this section.

50+ Ready-to-use MDX Queries
02:36

This article list all the MDX terms and its meaning in simplified non-technical language.

Glossary of MDX Terms
01:51

This quiz contains interview questions related to Multimdimensional Expressions (MDX) query language.

MDX Interview Questions / Practice Test Exam Questions
28 questions
+
Administration
6 Lectures 33:44

This lecture explains SSAS administration tasks like processing dimensions, measures and cubes

Processing Dimensions, Measurses and Cubes
09:47

This lecture explains SSAS administration tasks related to Backup and Restore

Backup and Restore
04:15

This lecture explains SSAS administration tasks related to query logging, exception logging and replaying server events using file recorder trace file.

Query Logging, Exception Logging and Flight Recorder
07:19

This lecture explains the use of Database Synchronization Wizard in SSAS and developing scripts for cubes, dimensions and measures in SSAS

Scripting and Synchronizing Databases
03:43

This lecture covers the topic of data security and cell security in SSAS 2016

SSAS Security
08:26

This article contains links to reference material regarding SSAS Administration related tasks.

Resources for SSAS Administration
00:14

This quiz contains interview questions related to SSAS Administration and SSAS Security.

SSAS Administration Interview Questions / Practice Test Exam Questions
16 questions
+
Advance Techniques
4 Lectures 35:12

This lecture demonstrates development of translations and fine tuning dimensions and measures already in production

Fine tuning and Multi-lingual Support
11:49

This lecture demonstrates the use of Aggregation Design Wizard and development of aggregations using the Aggregation Design Wizard in SSAS 2016

Aggregation Design
11:17

This lecture explains the methods of partitioning a measure group and configuring the storage modes in SSAS 2016

Partitioning and Storage Modes
11:57

This lecture contains links to reference material related to SSAS Advance Techniques.

Resources for SSAS Advance Techniques
00:09

This quiz contains interview questions related to SSAS Aggregation Design and SSAS Partitioning.

SSAS Aggregation Design Interview Questions / Practice Test Exam Questions
11 questions
+
Performance Tuning
4 Lectures 17:35

This lecture demonstrates interception of MDX queries using profiler and analysis of the same in SSAS 2016

Query interception and analysis
06:19

This lecture explains the use of Usage Based Optimization Wizard in SSAS 2016 to optimize aggregations

Usage based performance optimization
05:17

This lecture demonstrates the use of performance counters in SSAS 2016

Performance Counters
05:53

This lecture contains links to reference material related to SSAS Performance Tuning.

Resources for SSAS Performance Tuning
00:06

This quiz contains interview questions related to SSAS Performance Tuning.

SSAS Performance Tuning Interview Questions / Practice Test Exam Questions
7 questions
+
Basics of Data Mining Concepts and Data Mining Algorithms
9 Lectures 36:38

This lecture discusses different applications of data mining in real world scenarios.

Applications of Data Mining
06:05

This lecture explains the problem definition phase of data mining process.

Problem Definition for Data Mining with SSAS
04:14

This lecture explains the data preparation phase of data mining process.

Data Preparation for Data Mining with SSAS
02:11

This lecture explains the data exploration phase of data mining process.

Data Exploration for Data Mining with SSAS
03:29

This lecture explains the model building and training phase of data mining process.

Building and Training Models for Data Mining with SSAS
04:06

This lecture explains the validation and testing phase of data mining process.

Validating model for Data Mining with SSAS
04:26

This lecture explains the deployment phase of data mining process.

Deploying models for Data Mining with SSAS
03:03

This lecture explains the different data mining algorithms available in SQL Server for data mining applications.

Data Mining Algorithms
08:42

This article contains links to reference materials regarding different data mining algorithms in SQL Server 2016 and SSAS.

Resources for Data Mining Algorithms in SQL Server 2016 and SSAS
00:22

This quiz contains interview questions related to Data Mining.

Data Mining Interview Questions / Practice Test Exam Questions
11 questions
+
Developing Data Mining Models using SQL Server and SSAS
8 Lectures 01:02:09

This lecture explains the method of developing a data mining model and data mining structure using a data warehouse.

Building a Relational Data Mining Model and Data Mining Structure
12:53

This lecture explains the analysis and testing of the data mining model.

Analyzing and Testing a Relational Data Mining Model
14:17

This lecture explains the application of prediction methods on a data mining model.

Applying a Data Mining Model for Prediction
04:14

This lecture explains the method of reusing an existing data mining structure for a new data mining model.

Reusing a Data Mining Structure
06:33

This lecture explains the method of developing a data mining model using an OLAP Cube as the data source.

Building an OLAP Data Mining Model
09:43

This lecture explains the method of testing and browsing the output of a data mining model that uses OLAP Cube as the data source.

Analyzing Cube with Data Mining Dimension
07:39

This section would cover the methods of querying and developing reports from a Data Mining model using Microsoft Office.

Developing Data Mining Reports using Microsoft Office
06:36

This lecture contains links to reference material related to development of SSAS Data Mining Models.

Resources for SSAS Data Mining Model Development
00:14

This quiz contains interview questions related development of data mining models, data mining algorithms, data mining structure, developing data mining reports, and data mining visualizations.

Data Mining Interview Questions / Practice Test Exam Questions
14 questions
3 More Sections
About the Instructor
Siddharth Mehta
4.1 Average rating
458 Reviews
5,279 Students
7 Courses
Published Author, Microsoft MVP Alumni, Sr. Tech Arch

My name is Siddharth Mehta. I work in the role of a Senior Technology Architect with a multinational IT firm. I have career experience of more than 14 years in the IT industry working with multinational IT companies and Fortune 500 clients. 

Industry Experience

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

-|- I usually work as a lead architect for a portfolio of applications in web, mobile, BI, Analytics, Data warehousing, Reporting, Collaboration, CMS, NoSQL and other categories.

-|- In my present role, I remain responsible for Arch Design, Tech Stack selection, Infra design, 3rd party products evaluation and procurement, and Performance engineering. My primary specialty is Microsoft SQL Server and Microsoft Business Intelligence. I usually work with MS BI integration with cross technologies like Elasticsearch / Lucene, MongoDB, Sharepoint 2013 and 2010, jQuery based framework like Highcharts and GoJS, jQueryMobile, Bootstrap, iOS xCode framework, and many others.

Authoring Achievements

-|- I have authored more than 200 articles and tutorials collectively for online publications like mssqltips, sqlserverperformance, sqlservercental, techrepublic and others.

-|- I have authored / co-authored as well as reviewed books for print-media publication houses like Manning publication, Packt publication.

-|- I have also authored a whitepaper for MSDN Library titled: Bulk report generation using SSIS and SSRS 2008 R2.

Certifications

-|- TOGAF 9 Part I & II certified architect
-|- CITA-F certified architect
-|- HCAHD (Hortonworks Hadoop certified)
-|- MCSD.Net, and MCTS in SQL Server maintenance as well as Developing BI apps using SQL Server
-|- Certified Sr. Technology Architect as well as Digital Architect

Academics

Master of Science with major in Computer Applications and Information Technology