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:
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.
This lecture covers author introduction, reasons to learn SSAS and MDX on SQL Server 2016.
This lecture provides an overview of BI architecture components like Source Systems, Staging Zone, Landing Zone, Data Warehouse, Data Mart, Reports and Dashboards
This lecture provides an overview of Dimensional Modeling process and architecture
This lecture contains resources for analyzing the sample data warehouse and sample OLTP database used as the source for dimensional modeling.
This lecture provides an overview of Business Intelligence Semantic Model
This lecture provides an overview of SQL Server Analysis Services
This lecture provides an overview of Multidimensional Expressions
This lecture provides a quick comparison between different server modes of SSAS.
This article contains of glossary of SSAS terms and their associated meaning in simplified non-technical language.
This quiz contains interview questions related to SSAS and Dimensional Modeling
This lecture demonstrates the installation of SQL Server 2016 and SQL Server Analysis Services 2016
This lecture demonstrates configuration of some of the important SSAS server properties
This section contains few FAQs and Links to further reference material on MSDN regarding SSAS Installation and Configuration.
This quiz contains interview questions related to SSAS Installation.
This lecture demonstrates installation of AdventureWorks Data Warehouse
This chapter demonstrates how to create a data source and data source view in SSAS 2016 using SSDT
This lecture explains how to create a cube using the SSAS Cube Wizard in SSDT and SQL Server 2016
This lecture covers the details of cube design like cube dimensions, measure groups etc
This lecture covers the details of dimension design and important properties related to dimensions
This lecture demonstrates how to create user hierarchies and configure the same.
This lecture demonstrates the process of cube deployment, and browsing the cube from SSMS
This article contains links to reference material for designing and developing SSAS Dimensions, Measures and Cubes.
This quiz contains interview questions related to SSAS Cube Design, Dimension Design, Measures Design, Hierarchy Design and SSAS Cube Deployment.
This lecture demonstrates the installation of SSAS 2016 Adventureworks database on the SSAS server
This lecture demonstrates and explains different MDX queries related to MDX fundamentals
This lecture demonstrates and explains different MDX queries related to browsing dimensions, attributes, members, cells, tuples, sets etc using MDX
This lecture demonstrates and explains different MDX queries related accessing individual members of a dimension and sorting data in a MDX query
This lecture demonstrates and explains filtering data using various MDX functions and methods.
This lecture demonstrates and explains creation of a subcube, named sets, calculated sets and measures and other concepts using MDX query language
This lecture explains development of calculated measures and KPIs using MDX
Learn how to use MDX in a SSRS Report to query data from SSAS Cube and report the same.
This article contains 50+ ready to use MDX queries explained throughout this section.
This article list all the MDX terms and its meaning in simplified non-technical language.
This quiz contains interview questions related to Multimdimensional Expressions (MDX) query language.
This lecture explains SSAS administration tasks like processing dimensions, measures and cubes
This lecture explains SSAS administration tasks related to Backup and Restore
This lecture explains SSAS administration tasks related to query logging, exception logging and replaying server events using file recorder trace file.
This lecture explains the use of Database Synchronization Wizard in SSAS and developing scripts for cubes, dimensions and measures in SSAS
This lecture covers the topic of data security and cell security in SSAS 2016
This article contains links to reference material regarding SSAS Administration related tasks.
This quiz contains interview questions related to SSAS Administration and SSAS Security.
This lecture demonstrates development of translations and fine tuning dimensions and measures already in production
This lecture demonstrates the use of Aggregation Design Wizard and development of aggregations using the Aggregation Design Wizard in SSAS 2016
This lecture explains the methods of partitioning a measure group and configuring the storage modes in SSAS 2016
This lecture contains links to reference material related to SSAS Advance Techniques.
This quiz contains interview questions related to SSAS Aggregation Design and SSAS Partitioning.
This lecture demonstrates interception of MDX queries using profiler and analysis of the same in SSAS 2016
This lecture explains the use of Usage Based Optimization Wizard in SSAS 2016 to optimize aggregations
This lecture demonstrates the use of performance counters in SSAS 2016
This lecture contains links to reference material related to SSAS Performance Tuning.
This quiz contains interview questions related to SSAS Performance Tuning.
This lecture discusses different applications of data mining in real world scenarios.
This lecture explains the problem definition phase of data mining process.
This lecture explains the data preparation phase of data mining process.
This lecture explains the data exploration phase of data mining process.
This lecture explains the model building and training phase of data mining process.
This lecture explains the validation and testing phase of data mining process.
This lecture explains the deployment phase of data mining process.
This lecture explains the different data mining algorithms available in SQL Server for data mining applications.
This article contains links to reference materials regarding different data mining algorithms in SQL Server 2016 and SSAS.
This quiz contains interview questions related to Data Mining.
This lecture explains the method of developing a data mining model and data mining structure using a data warehouse.
This lecture explains the analysis and testing of the data mining model.
This lecture explains the application of prediction methods on a data mining model.
This lecture explains the method of reusing an existing data mining structure for a new data mining model.
This lecture explains the method of developing a data mining model using an OLAP Cube as the data source.
This lecture explains the method of testing and browsing the output of a data mining model that uses OLAP Cube as the data source.
This section would cover the methods of querying and developing reports from a Data Mining model using Microsoft Office.
This lecture contains links to reference material related to development of SSAS Data Mining Models.
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.
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.
-|- 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.
-|- 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.
-|- 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
Master of Science with major in Computer Applications and Information Technology