Ssas Sql Server Analysis Services 2016 Mdx Training

Develop SSAS cubes from data warehouse on Multidimensional & Tabular modes with Dimensional & Data Mining Models

Last updated 2022-01-10 | 4

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

What you'll 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.

* 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

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.

Course content

13 sections • 89 lectures

Introduction 1 lectures

Introduction, Why to learn SSAS and MDX, What you'll need Preview 11:56

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

Fundamentals and Technology Overview 9 lectures

Business Intelligence Solution Components Overview Preview 07:49

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

Analyzing Dimensional Model Preview 14:26

This lecture provides an overview of Dimensional Modeling process and architecture

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

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

Business Intelligence Semantic Model Overview Preview 07:51

This lecture provides an overview of Business Intelligence Semantic Model

SSAS Overview Preview 14:17

This lecture provides an overview of SQL Server Analysis Services

Multidimensional Expressions Overview Preview 11:19

This lecture provides an overview of Multidimensional Expressions

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

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

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

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

SSAS and Dimensional Modeling Interview Questions / Practice Test Exam Questions

This quiz contains interview questions related to SSAS and Dimensional Modeling

SQL Server Analysis Services (SSAS) Installation 4 lectures

Installing SQL Server and SSAS Preview 07:27

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

Configuring SSAS Preview 06:06

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

Resources and FAQ for SSAS Installation and Configuration Preview 01:43

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

SSAS Installation and Config Interview Questions / Practice Test Exam Questions

This quiz contains interview questions related to SSAS Installation.

Cube Design and Development 9 lectures

Attaching Data Warehouse Preview 04:15

This lecture demonstrates installation of AdventureWorks Data Warehouse

Data Source and Data Source Views Preview 08:03

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

Developing Cube using Cube wizard Preview 04:53

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

Cube Design Preview 07:42

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

Dimension Design Preview 11:49

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

Hierarchy Design Preview 03:18

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

SSAS Deployment Preview 08:05

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

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

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

SSAS Cube Development Interview Questions / Practice Test Exam Questions

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

Multidimensional Expressions - Practical code development 11 lectures

Installing OLAP database Preview 05:26

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

Fundamentals of MDX Query Preview 10:33

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

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

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

Navigating and Sorting data Preview 11:36

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

Filtering Data Preview 11:35

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

Named Sets and Subcubes Preview 06:49

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

Calculated Measures and KPIs Preview 10:24

This lecture explains development of calculated measures and KPIs using MDX

SSRS with MDX Preview 08:06

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

50+ Ready-to-use MDX Queries Preview 02:20

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

Glossary of MDX Terms Preview 01:43

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

MDX Interview Questions / Practice Test Exam Questions

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

Administration 7 lectures

Processing Dimensions, Measurses and Cubes Preview 09:47

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

Backup and Restore Preview 04:15

This lecture explains SSAS administration tasks related to Backup and Restore

Query Logging, Exception Logging and Flight Recorder Preview 07:19

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

Scripting and Synchronizing Databases Preview 03:43

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

SSAS Security Preview 08:26

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

Resources for SSAS Administration Preview 00:08

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

SSAS Administration Interview Questions / Practice Test Exam Questions

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

Advance Techniques 5 lectures

Fine tuning and Multi-lingual Support Preview 11:49

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

Aggregation Design Preview 11:17

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

Partitioning and Storage Modes Preview 11:57

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

Resources for SSAS Advance Techniques Preview 00:05

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

SSAS Aggregation Design Interview Questions / Practice Test Exam Questions

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

Performance Tuning 5 lectures

Query interception and analysis Preview 06:19

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

Usage based performance optimization Preview 05:17

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

Performance Counters Preview 05:53

This lecture demonstrates the use of performance counters in SSAS 2016

Resources for SSAS Performance Tuning Preview 00:03

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

SSAS Performance Tuning Interview Questions / Practice Test Exam Questions

This quiz contains interview questions related to SSAS Performance Tuning.

Basics of Data Mining Concepts and Data Mining Algorithms 10 lectures

Applications of Data Mining Preview 06:05

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

Problem Definition for Data Mining with SSAS Preview 04:14

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

Data Preparation for Data Mining with SSAS Preview 02:11

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

Data Exploration for Data Mining with SSAS Preview 03:29

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

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

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

Validating model for Data Mining with SSAS Preview 04:26

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

Deploying models for Data Mining with SSAS Preview 03:03

This lecture explains the deployment phase of data mining process.

Data Mining Algorithms Preview 08:42

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

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

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

Data Mining Interview Questions / Practice Test Exam Questions

This quiz contains interview questions related to Data Mining.

Developing Data Mining Models using SQL Server and SSAS 9 lectures

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

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

Analyzing and Testing a Relational Data Mining Model Preview 14:17

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

Applying a Data Mining Model for Prediction Preview 04:14

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

Reusing a Data Mining Structure Preview 06:33

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

Building an OLAP Data Mining Model Preview 09:43

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

Analyzing Cube with Data Mining Dimension Preview 07:39

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

Developing Data Mining Reports using Microsoft Office Preview 06:36

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

Resources for SSAS Data Mining Model Development Preview 00:08

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

Data Mining Interview Questions / Practice Test Exam Questions

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.

Tabular SSAS - Installation and Setup 5 lectures

Introduction to SSAS - Tabular Mode, Vertipaq Engine & Data Analysis Expressions Preview 01:39

This lecture lists down some important introductory points to remember regarding SSAS, Vertipaq Engine and DAX.

Installing Tabular SSAS Preview 04:50

This lecture demonstrates the installation of SSAS in Tabular Mode.

Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project Preview 06:59

This lecture explains how to restore a sample SSAS tabular database, sample data warehouse and how to configure a sample SSAS Tabular project.

Resources for SSAS Tabular Installation Preview 00:11

This lecture contains links to reference materials related to SSAS Installation and Configuration.

SSAS Tabular Interview Questions \ Practice Test Questions

This quiz contains interview questions / practice test questions related to SSAS Tabular Installation and Configuration.

SSAS Tabular Data Model - Design and Development 12 lectures

Developing Tables, Relationships, and Hierarchies Preview 14:07

This lecture explains the process of developing SSAS Tabular Model with practical demonstration.

Basics and Terminologies of SSAS Tabular Modeling and Data Analysis Expressions Preview 03:46

Developing Calculated Columns and Measures using DAX Preview 07:00

This lecture demonstrates how to create calculated columns and measures in a SSAS Tabular Data Model using DAX.

Developing Key Performance Indicators using DAX Preview 05:42

This lecture demonstrates how to create a Key Performance Indicator in a SSAS Tabular Data Model

Configuring Perspectives in Tabular SSAS Preview 03:58

This lecture demonstrates how to create and manage perspectives in SSAS Tabular.

Difference between In-Memory and DirectQuery query modes Preview 01:44

Querying SSAS Tabular Data Model using DAX Preview 14:01

This lecture explains the use of DAX Expression language and the different aspects of DAX through practical examples and DAX queries.

Ready to use DAX Queries Preview 00:47

This lecture contains DAX queries used during the DAX querying chapter and other useful DAX queries.

Security in SSAS Tabular Preview 01:51

Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office Preview 05:28

This lecture explains how to develop powerview, pivot table, pivot chart and SSRS reports from a SSAS Tabular Data Model

Resources for SSAS Tabular Model Development Preview 00:07

This lecture contains links to reference material related to SSAS Tabular Design and Development