mcAfee-secured website

Course name Databases Courses SSAS Data Mining and Analytics from Scratch: SSAS, Data Mining and Analytics from Scratch

SSAS Data Mining and Analytics from Scratch Video Course

SSAS Data Mining and Analytics from Scratch Video Course is developed by Databases Courses Professionals to help you pass the SSAS Data Mining and Analytics from Scratch exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass SSAS, Data Mining and Analytics from Scratch exam.

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