Take this
course

Software Development / Big Data & Analytics

SQL Server Analysis Services - SSAS, Data Mining & Analytics

SQL Server, SSAS, MDX, Data Mining, Data Warehouse, Data Modeling, SSIS, SSRS, Microsoft Business Intelligence Tools, BI

Description

 SQL Server Analysis Services, Data Mining and MDX is a  course in which a student having no experience in data science and analytics would be trained step by step from basics to advanced data science topics like data mining. The intention of this course is to empower students with the knowledge of OLAP, Analytics and Data Mining, which can potentially yield salaries of $85 - $150k based only on your experience of SSAS, MDX and Data Mining.


Course includes job-oriented practical hands-on exercises, theoretical coverage of key concepts, interview questions, practice test questions for certifications and more. This course covers all the topics for developers, administrators as well as aspiring data scientists. New Interview questions are added to the course every few weeks. Anyone pursuing this course would be able to clearly understand about Microsoft Business Intelligence Architecture, and understand how SSAS and Data Mining fits in this architecture along with other tools like SSIS, SSRS, Master Data Services ( MDS ), Data Quality Services ( DQS ), Powerpivot, PowerView, SQL Server Database Engine, SSMS, SSDT and other tools.


SQL Server Analysis Services, Data Mining and MDX is a fast track course to learn practical SSAS ( SQL Server Analysis Services ), Data Mining and MDX code development using the latest version of SQL Server - 2016. No prior experience of working with SSAS / Data Mining or MDX is required.

 
The course is structured in the following categories: Fundamentals, Design, Development, MDX Code development, Administration, Performance Tuning, Data Mining Basics and Data Mining Development. 

Full details

Curriculum

  • Introduction
    Lesson 1 - Introduction
    This section would cover the reasons to learn SSAS and MDX, necessary HW/SW before starting the course and introduction of the instructor
    11:57
  • Fundamentals and Technology Overview
    Business Intelligence Solution Components Overview
    This lecture provides an overview of BI architecture components like Source Systems, Staging Zone, Landing Zone, Data Warehouse, Data Mart, Reports and Dashboards
    7:50
    Analyzing Dimensional Model
    This lecture provides an overview of Dimensional Modeling process and architecture
    14:27
    Business Intelligence Semantic Model Overview
    This lecture provides an overview of Business Intelligence Semantic Model
    7:52
    SSAS Overview
    This lecture provides an overview of SQL Server Analysis Services
    14:18
    Multidimensional Expressions Overview
    This lecture provides an overview of Multidimensional Expressions
    11:20
  • SQL Server Analysis Services (SSAS) Installation
    Installing SQL Server and SSAS
    This lecture demonstrates the installation of SQL Server 2016 and SQL Server Analysis Services 2016
    7:28
    Configuring SSAS
    This lecture demonstrates configuration of some of the important SSAS server properties
    6:07
  • Cube Design and Development
    Attaching a Data Warehouse
    This lecture demonstrates installation of AdventureWorks Data Warehouse
    4:16
    Data Source and Data Source Views
    This chapter demonstrates how to create a data source and data source view in SSAS 2016 using SSDT
    8:04
    Developing Cube using Cube Wizard
    This lecture explains how to create a cube using the SSAS Cube Wizard in SSDT and SQL Server 2016
    4:54
    Cube Design
    This lecture covers the details of cube design like cube dimensions, measure groups etc
    7:43
    Dimension Design
    This lecture covers the details of dimension design and important properties related to dimensions
    11:50
    Hierarchy Design
    This lecture demonstrates how to create user hierarchies and configure the same.
    3:19
    SSAS Deployment
    This lecture demonstrates the process of cube deployment, and browsing the cube from SSMS
    8:06
  • Multidimensional Expressions - Practical Code Development
    Installing OLAP Database
    This lecture demonstrates the installation of SSAS 2016 Adventureworks database on the SSAS server
    5:27
    Fundamentals of MDX Query
    This lecture demonstrates and explains different MDX queries related to MDX fundamentals
    10:34
    Querying Object Hierarchy - Dimensions, Attributes, and Members
    This lecture demonstrates and explains different MDX queries related to browsing dimensions, attributes, members, cells, tuples, sets etc using MDX
    9:53
    Navigating and Sorting Data
    This lecture demonstrates and explains different MDX queries related accessing individual members of a dimension and sorting data in a MDX query
    11:37
    Filtering Data
    This lecture demonstrates and explains filtering data using various MDX functions and methods.
    11:36
    Named Sets and Subcubes
    This lecture demonstrates and explains creation of a subcube, named sets, calculated sets and measures and other concepts using MDX query language
    6:51
    Calculated Members and KPIs
    This lecture explains development of calculated measures and KPIs using MDX
    10:26
  • Administration
    Processing Dimensions, Measures and Cubes
    This lecture explains SSAS administration tasks like processing dimensions, measures and cubes
    9:48
    Backup and Restore
    This lecture explains SSAS administration tasks related to Backup and Restore
    4:16
    Query Logging, Exception Logging and Flight Recorder
    This lecture explains SSAS administration tasks related to query logging, exception logging and replaying server events using file recorder trace file.
    7:20
    Scripting and Synchronizing Databases
    This lecture explains the use of Database Synchronization Wizard in SSAS and developing scripts for cubes, dimensions and measures in SSAS
    3:44
    SSAS Security
    This lecture covers the topic of data security and cell security in SSAS 2016
    8:27
  • Advance Techniques
    Fine tuning and Multi-lingual Support
    This lecture demonstrates development of translations and fine tuning dimensions and measures already in production
    11:50
    Aggregation Design
    This lecture demonstrates the use of Aggregation Design Wizard and development of aggregations using the Aggregation Design Wizard in SSAS 2016
    11:18
    Partitioning and Storage Modes
    This lecture explains the methods of partitioning a measure group and configuring the storage modes in SSAS 2016
    11:58
  • Performance Tuning
    Query Interception and Analysis
    This lecture demonstrates interception of MDX queries using profiler and analysis of the same in SSAS 2016
    6:20
    Usage based performance optimization
    This lecture explains the use of Usage Based Optimization Wizard in SSAS 2016 to optimize aggregations
    5:18
    Performance Counters
    This lecture demonstrates the use of performance counters in SSAS 2016
    5:55
  • Basics of Data Mining Concepts and Data Mining Algorithms
    Applications of Data Mining
    This lecture discusses different applications of data mining in real world scenarios.
    6:06
    Problem Definition for Data Mining with SSAS
    This lecture explains the problem definition phase of data mining process.
    4:15
    Data Preparation for Data Mining with SSAS
    This lecture explains the data preparation phase of data mining process.
    2:12
    Data Exploration for Data Mining with SSAS
    This lecture explains the data exploration phase of data mining process.
    3:30
    Building and Training Models for Data Mining with SSAS
    This lecture explains the model building and training phase of data mining process.
    4:07
    Validating Model for Data Mining with SSAS
    This lecture explains the validation and testing phase of data mining process.
    4:27
    Deploying models for Data Mining with SSAS
    This lecture explains the deployment phase of data mining process.
    3:04
    Data Mining Algorithms
    This lecture explains the different data mining algorithms available in SQL Server for data mining applications.
    8:43
  • Developing Data Mining Models using SQL Server and SSAS
    Building a Relational Data Mining Model and Data Mining Structure
    This lecture explains the method of developing a data mining model and data mining structure using a data warehouse.
    12:54
    Analyzing and Testing a Relational Data Mining Model
    This lecture explains the analysis and testing of the data mining model.
    14:18
    Applying a Data Mining Model for Prediction
    This lecture explains the application of prediction methods on a data mining model.
    4:15
    Reusing a Data Mining Structure
    This lecture explains the method of reusing an existing data mining structure for a new data mining model.
    6:34
    Building an OLAP Data Mining Model
    This lecture explains the method of developing a data mining model using an OLAP Cube as the data source.
    9:44
    Analyzing Cube with Data Mining Dimension
    This lecture explains the method of testing and browsing the output of a data mining model that uses OLAP Cube as the data source.
    7:40
    Developing Data Mining Reports using Microsoft Office
    This section would cover the methods of querying and developing reports from a Data Mining model using Microsoft Office.
    6:37
  • Summary
    Course Wrapup
    This lecture summarizes the topics learned in the entire course
    3:31

Skills

  • Data Algorithm
  • Data Structures
  • Data Analytics

Similar Courses