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

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.

$14.99 / $24.99

Introduction

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

Fundamentals and Technology Overview

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

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

Cube Design and Development

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

Multidimensional Expressions - Practical code development

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

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

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

Performance Tuning

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

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

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

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

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

1. Course Wrapup
2m 48s