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

( 0 Reviews )

Created by: Siddharth Mehta

Produced in 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.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course Description

Top 4Reasons to take this course:
1)You can learn SSAS, Data Mining and Analytics from scratchas well asask questions directly toa Published Author, Microsoft MVP, and aSenior Technology Architect with more than 15 years of experience who actively practices BusinessIntelligence, Data Mining and Analytics in real-worldclient 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 SSASDeveloper / 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 Link150+ Interview Questions100+ curated reference material links70+ Ready-to-useMDX / DAXQueriesLinks to 1 Sample OLTP Database and 1 Sample Data Warehouse with sample data - schema diagrams - documentation - dimensional modeling workbookLinks to1 Sample Multidimensional OLAP Database + 1 Sample Tabular OLAP Database containing fully functional cube with sample dataFull project developed in the course.
Course DescriptionSQLServer Analysis Services, Data Mining and Analyticsis a course in whicha student having no experience in data science andanalyticswould be trained step by step from basics toadvanceddata science topics like data mining. Theintention 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 onlyon your experience of SSAS, MDX, DAX and Data Mining.
Course includes job-orientedpractical hands-on exercises, theoretical coverage of key concepts,interview questions, practice test questions for certificationsand more. This coursecovers all the topics fordevelopers,administrators as well as aspiring data scientists. NewInterview questions are added to the courseevery few weeks. Anyone pursuing this course would be able to clearly understandabout 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.
SQLServer Analysis Services, Data Mining and MDXis afast track course to learn practical SSAS ( SQLServer Analysis Services ), Data Miningand MDX code development using the latest version of SQLServer - 2016. No prior experience of working with SSAS/ Data Mining orMDX isrequired.
The course is structured in the following categories:
Fundamentals, Design, Development, MDXCode development, Administration,Performance Tuning, Data Mining Basics and Data Mining Development, Tabular SSASInstallation and Configuration, and Tabular SSASDesign and Development as well as DAXprogramming.
Who this course is for:
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 courseThis course is for those who want to start a career in the analytics space by learning a niche skillIf you are planning to appear for a SSAS job interview or MS BI Certification, this course is for youStudents 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 othersSSAS 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

Time: 7.5h

Instructor Details

Siddharth Mehta

0.0 Rating
0 Reviews

Udemy's Top 10%of most engaging instructors
My name is Siddharth Mehta. I have career experience of more than 15years in the ITIndustryand am presently working as Enterprise CloudArchitect. 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 ?Iwill teach you everything Iknow about the subject, from my years of practical experience in the field of BI, Data, Analytics, Cloud and Data Science.
If you are interested inlearning more about me, below aresome 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
-|- Lead architecture of multi-million dollar portfolios containing apps in Cloud, web, mobile, BI, Ana