SQL Server Analysis Services - SSAS, Data Mining & Analytics

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