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

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

BEST SELLER 58 Lectures 7h 28m 29s

Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.

$14.99 $19.49

Curriculum For This Course

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

  • 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. Installing SQL Server and SSAS
    7m 24s
  • 2. Configuring SSAS
    6m 3s

  • 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. 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. 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. Fine tuning and Multi-lingual Support
    11m 44s
  • 2. Aggregation Design
    11m 12s
  • 3. Partitioning and Storage Modes
    11m 54s

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

  • 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. 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. Installing Tabular SSAS
    4m 47s
  • 2. Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project
    6m 55s

  • 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. Course Wrapup
    2m 48s