SSAS Data Mining and Analytics from Scratch Video Course

Curriculum For This Course

• 1. Introduction 1 Videos 00:11:56
  • Introduction, Why to learn SSAS and MDX, What you'll need 11:34
• 2. Fundamentals and Technology Overview 5 Videos 00:55:42
  • Business Intelligence Solution Components Overview 07:37
  • Analyzing Dimensional Model 14:22
  • Business Intelligence Semantic Model Overview 07:44
  • SSAS Overview 14:10
  • Multidimensional Expressions Overview 11:07
• 3. SQL Server Analysis Services (SSAS) Installation 2 Videos 00:13:33
  • Installing SQL Server and SSAS 07:24
  • Configuring SSAS 06:03
• 4. Cube Design and Development 7 Videos 00:48:05
  • Attaching Data Warehouse 04:12
  • Data Source and Data Source Views 08:00
  • Developing Cube using Cube wizard 04:49
  • Cube Design 07:38
  • Dimension Design 11:45
  • Hierarchy Design 03:15
  • SSAS Deployment 08:01
• 5. Multidimensional Expressions - Practical code development 8 Videos 01:14:21
  • Installing OLAP database 05:22
  • Fundamentals of MDX Query 10:29
  • Querying Object hiearchy - Dimensions, Attributes and Members 09:49
  • Navigating and Sorting data 11:32
  • Filtering Data 11:32
  • Named Sets and Subcubes 06:46
  • Calculated Measures and KPIs 10:21
  • SSRS with MDX 08:02
• 6. Administration 5 Videos 00:33:30
  • Processing Dimensions, Measurses and Cubes 09:42
  • Backup and Restore 04:12
  • Query Logging, Exception Logging and Flight Recorder 07:15
  • Scripting and Synchronizing Databases 03:39
  • SSAS Security 08:23
• 7. Advance Techniques 3 Videos 00:35:03
  • Fine tuning and Multi-lingual Support 11:44
  • Aggregation Design 11:12
  • Partitioning and Storage Modes 11:54
• 8. Performance Tuning 3 Videos 00:17:29
  • Query interception and analysis 06:16
  • Usage based performance optimization 05:14
  • Performance Counters 05:50
• 9. Basics of Data Mining Concepts and Data Mining Algorithms 8 Videos 00:36:16
  • Applications of Data Mining 06:02
  • Problem Definition for Data Mining with SSAS 04:10
  • Data Preparation for Data Mining with SSAS 02:07
  • Data Exploration for Data Mining with SSAS 03:25
  • Building and Training Models for Data Mining with SSAS 04:02
  • Validating model for Data Mining with SSAS 04:22
  • Deploying models for Data Mining with SSAS 02:59
  • Data Mining Algorithms 08:38
• 10. Developing Data Mining Models using SQL Server and SSAS 7 Videos 01:01:55
  • Building a Relational Data Mining Model and Data Mining Structure 12:48
  • Analyzing and Testing a Relational Data Mining Model 14:12
  • Applying a Data Mining Model for Prediction 04:11
  • Reusing a Data Mining Structure 06:30
  • Building an OLAP Data Mining Model 09:39
  • Analyzing Cube with Data Mining Dimension 07:36
  • Developing Data Mining Reports using Microsoft Office 06:32
• 11. Tabular SSAS - Installation and Setup 2 Videos 00:11:49
  • Installing Tabular SSAS 04:47
  • Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project 06:55
• 12. SSAS Tabular Data Model - Design and Development 6 Videos 00:50:16
  • Developing Tables, Relationships, and Hierarchies 14:03
  • Developing Calculated Columns and Measures using DAX 06:56
  • Developing Key Performance Indicators using DAX 05:38
  • Configuring Perspectives in Tabular SSAS 03:54
  • Querying SSAS Tabular Data Model using DAX 13:55
  • Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office 05:25
• 13. Conclusion 1 Videos 00:03:30
  • Course Wrapup 02:48