Certification training
58Lectures
7h 28m 29sDuration
Vendor
SSAS Data Mining and Analytics from Scratch: SSAS, Data Mining and Analytics from Scratch
Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.
Best seller
certification training
58 lessons arranged in a guided course path
Course overview
Study with a clear path.
Move through focused sections, review lecture timing, and return directly to the objectives that need more work.
Sequenced lessons
Follow the course in order or jump directly to the section you need to revisit.
Video-first prep
Use concise lecture blocks for technical review before moving into exam practice.
Fast access
Your purchased course becomes available in the member area after confirmed payment.
Curriculum
Course sections.
13 sections, 58 lessons, and lecture-level duration details.
01
Introduction, Why to learn SSAS and MDX, What you'll need
11m 34s
01
Business Intelligence Solution Components Overview
7m 37s
02
Analyzing Dimensional Model
14m 22s
03
Business Intelligence Semantic Model Overview
7m 44s
04
SSAS Overview
14m 10s
05
Multidimensional Expressions Overview
11m 7s
01
Installing SQL Server and SSAS
7m 24s
02
Configuring SSAS
6m 3s
01
Attaching Data Warehouse
4m 12s
02
Data Source and Data Source Views
8m
03
Developing Cube using Cube wizard
4m 49s
04
Cube Design
7m 38s
05
Dimension Design
11m 45s
06
Hierarchy Design
3m 15s
07
SSAS Deployment
8m 1s
01
Installing OLAP database
5m 22s
02
Fundamentals of MDX Query
10m 29s
03
Querying Object hiearchy - Dimensions, Attributes and Members
9m 49s
04
Navigating and Sorting data
11m 32s
05
Filtering Data
11m 32s
06
Named Sets and Subcubes
6m 46s
07
Calculated Measures and KPIs
10m 21s
08
SSRS with MDX
8m 2s
01
Processing Dimensions, Measurses and Cubes
9m 42s
02
Backup and Restore
4m 12s
03
Query Logging, Exception Logging and Flight Recorder
7m 15s
04
Scripting and Synchronizing Databases
3m 39s
05
SSAS Security
8m 23s
01
Fine tuning and Multi-lingual Support
11m 44s
02
Aggregation Design
11m 12s
03
Partitioning and Storage Modes
11m 54s
01
Query interception and analysis
6m 16s
02
Usage based performance optimization
5m 14s
03
Performance Counters
5m 50s
01
Applications of Data Mining
6m 2s
02
Problem Definition for Data Mining with SSAS
4m 10s
03
Data Preparation for Data Mining with SSAS
2m 7s
04
Data Exploration for Data Mining with SSAS
3m 25s
05
Building and Training Models for Data Mining with SSAS
4m 2s
06
Validating model for Data Mining with SSAS
4m 22s
07
Deploying models for Data Mining with SSAS
2m 59s
08
Data Mining Algorithms
8m 38s
01
Building a Relational Data Mining Model and Data Mining Structure
12m 48s
02
Analyzing and Testing a Relational Data Mining Model
14m 12s
03
Applying a Data Mining Model for Prediction
4m 11s
04
Reusing a Data Mining Structure
6m 30s
05
Building an OLAP Data Mining Model
9m 39s
06
Analyzing Cube with Data Mining Dimension
7m 36s
07
Developing Data Mining Reports using Microsoft Office
6m 32s
01
Installing Tabular SSAS
4m 47s
02
Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project
6m 55s
01
Developing Tables, Relationships, and Hierarchies
14m 3s
02
Developing Calculated Columns and Measures using DAX
6m 56s
03
Developing Key Performance Indicators using DAX
5m 38s
04
Configuring Perspectives in Tabular SSAS
3m 54s
05
Querying SSAS Tabular Data Model using DAX
13m 55s
06
Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office
5m 25s
01
Course Wrapup
2m 48s