SSAS Data Mining and Analytics from Scratch: SSAS, Data Mining and Analytics from Scratch

What’s included

$14.99 / $24.99

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

4.59

Pay once, own it forever

Video Courses

Introduction

Lectures	Duration
1. Introduction, Why to learn SSAS and MDX, What you'll need	11m 34s

1. Introduction, Why to learn SSAS and MDX, What you'll need

11m 34s

Fundamentals and Technology Overview

Lectures	Duration
1. Business Intelligence Solution Components Overview	7m 37s
2. Analyzing Dimensional Model	14m 22s
3. Business Intelligence Semantic Model Overview	7m 44s
4. SSAS Overview	14m 10s
5. Multidimensional Expressions Overview	11m 7s

1. Business Intelligence Solution Components Overview

7m 37s

2. Analyzing Dimensional Model

14m 22s

3. Business Intelligence Semantic Model Overview

7m 44s

4. SSAS Overview

14m 10s

5. Multidimensional Expressions Overview

11m 7s

SQL Server Analysis Services (SSAS) Installation

Lectures	Duration
1. Installing SQL Server and SSAS	7m 24s
2. Configuring SSAS	6m 3s

1. Installing SQL Server and SSAS

7m 24s

2. Configuring SSAS

6m 3s

Cube Design and Development

Lectures	Duration
1. Attaching Data Warehouse	4m 12s
2. Data Source and Data Source Views	8m
3. Developing Cube using Cube wizard	4m 49s
4. Cube Design	7m 38s
5. Dimension Design	11m 45s
6. Hierarchy Design	3m 15s
7. SSAS Deployment	8m 1s

1. Attaching Data Warehouse

4m 12s

2. Data Source and Data Source Views

3. Developing Cube using Cube wizard

4m 49s

4. Cube Design

7m 38s

5. Dimension Design

11m 45s

6. Hierarchy Design

3m 15s

7. SSAS Deployment

8m 1s

Multidimensional Expressions - Practical code development

Lectures	Duration
1. Installing OLAP database	5m 22s
2. Fundamentals of MDX Query	10m 29s
3. Querying Object hiearchy - Dimensions, Attributes and Members	9m 49s
4. Navigating and Sorting data	11m 32s
5. Filtering Data	11m 32s
6. Named Sets and Subcubes	6m 46s
7. Calculated Measures and KPIs	10m 21s
8. SSRS with MDX	8m 2s

1. Installing OLAP database

5m 22s

2. Fundamentals of MDX Query

10m 29s

3. Querying Object hiearchy - Dimensions, Attributes and Members

9m 49s

4. Navigating and Sorting data

11m 32s

5. Filtering Data

11m 32s

6. Named Sets and Subcubes

6m 46s

7. Calculated Measures and KPIs

10m 21s

8. SSRS with MDX

8m 2s

Administration

Lectures	Duration
1. Processing Dimensions, Measurses and Cubes	9m 42s
2. Backup and Restore	4m 12s
3. Query Logging, Exception Logging and Flight Recorder	7m 15s
4. Scripting and Synchronizing Databases	3m 39s
5. SSAS Security	8m 23s

1. Processing Dimensions, Measurses and Cubes

9m 42s

2. Backup and Restore

4m 12s

3. Query Logging, Exception Logging and Flight Recorder

7m 15s

4. Scripting and Synchronizing Databases

3m 39s

5. SSAS Security

8m 23s

Advance Techniques

Lectures	Duration
1. Fine tuning and Multi-lingual Support	11m 44s
2. Aggregation Design	11m 12s
3. Partitioning and Storage Modes	11m 54s

1. Fine tuning and Multi-lingual Support

11m 44s

2. Aggregation Design

11m 12s

3. Partitioning and Storage Modes

11m 54s

Performance Tuning

Lectures	Duration
1. Query interception and analysis	6m 16s
2. Usage based performance optimization	5m 14s
3. Performance Counters	5m 50s

1. Query interception and analysis

6m 16s

2. Usage based performance optimization

5m 14s

3. Performance Counters

5m 50s

Basics of Data Mining Concepts and Data Mining Algorithms

Lectures	Duration
1. Applications of Data Mining	6m 2s
2. Problem Definition for Data Mining with SSAS	4m 10s
3. Data Preparation for Data Mining with SSAS	2m 7s
4. Data Exploration for Data Mining with SSAS	3m 25s
5. Building and Training Models for Data Mining with SSAS	4m 2s
6. Validating model for Data Mining with SSAS	4m 22s
7. Deploying models for Data Mining with SSAS	2m 59s
8. Data Mining Algorithms	8m 38s

1. Applications of Data Mining

6m 2s

2. Problem Definition for Data Mining with SSAS

4m 10s

3. Data Preparation for Data Mining with SSAS

2m 7s

4. Data Exploration for Data Mining with SSAS

3m 25s

5. Building and Training Models for Data Mining with SSAS

4m 2s

6. Validating model for Data Mining with SSAS

4m 22s

7. Deploying models for Data Mining with SSAS

2m 59s

8. Data Mining Algorithms

8m 38s

Developing Data Mining Models using SQL Server and SSAS

Lectures	Duration
1. Building a Relational Data Mining Model and Data Mining Structure	12m 48s
2. Analyzing and Testing a Relational Data Mining Model	14m 12s
3. Applying a Data Mining Model for Prediction	4m 11s
4. Reusing a Data Mining Structure	6m 30s
5. Building an OLAP Data Mining Model	9m 39s
6. Analyzing Cube with Data Mining Dimension	7m 36s
7. Developing Data Mining Reports using Microsoft Office	6m 32s

1. Building a Relational Data Mining Model and Data Mining Structure

12m 48s

2. Analyzing and Testing a Relational Data Mining Model

14m 12s

3. Applying a Data Mining Model for Prediction

4m 11s

4. Reusing a Data Mining Structure

6m 30s

5. Building an OLAP Data Mining Model

9m 39s

6. Analyzing Cube with Data Mining Dimension

7m 36s

7. Developing Data Mining Reports using Microsoft Office

6m 32s

Tabular SSAS - Installation and Setup

Lectures	Duration
1. Installing Tabular SSAS	4m 47s
2. Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project	6m 55s

1. Installing Tabular SSAS

4m 47s

2. Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project

6m 55s

SSAS Tabular Data Model - Design and Development

Lectures	Duration
1. Developing Tables, Relationships, and Hierarchies	14m 3s
2. Developing Calculated Columns and Measures using DAX	6m 56s
3. Developing Key Performance Indicators using DAX	5m 38s
4. Configuring Perspectives in Tabular SSAS	3m 54s
5. Querying SSAS Tabular Data Model using DAX	13m 55s
6. Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office	5m 25s

1. Developing Tables, Relationships, and Hierarchies

14m 3s

2. Developing Calculated Columns and Measures using DAX

6m 56s

3. Developing Key Performance Indicators using DAX

5m 38s

4. Configuring Perspectives in Tabular SSAS

3m 54s

5. Querying SSAS Tabular Data Model using DAX

13m 55s

6. Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office

5m 25s

Conclusion

Lectures	Duration
1. Course Wrapup	2m 48s

1. Course Wrapup

2m 48s