Introduction
  • Instructor Introduction
  • Course Pre-requisites, Objectives, and Agenda
Fundamentals, Tools Setup and Reference Guides
  • SQL Server Installation
  • Installing Sample Databases
  • SQL Server Basics and Reference Guides
  • SSAS Basics and MDX + DAX Reference Guides
  • Data Mining Basics and Reference Guide
  • Comparison of SSAS Multidimensional vs SSAS Tabular
Basic T-SQL
  • Select Statement - Part 1
  • Select Statement - Part 2
  • Select Statement - Part 3
  • Select Statement - Part 4
  • Joins
  • Grouping
  • Variables & Loops
  • Error Handling and Dynamic SQL
  • Subquery, Pivoting, Ranking, and CTE
  • System Functions and User Defined Functions
  • Stored Procedures
  • Tables and Views
  • Insert / Update / Delete
  • Glossary of SQL Server and T-SQL Terms
Data Analysis Expressions
  • Fundamentals of DAX Expression Language
  • Selecting Data
  • Filtering Data
  • Grouping Data
  • Joining Data
  • Complex Functions
  • Glossary of DAX Terms
Multi-Dimensional Expressions
  • Selecting Data
  • Dimensions, Attributes and Members
  • Navigating Data
  • Sorting Data
  • Filtering Data
  • Calculations
  • Date & Time
  • Aggregations
  • Sets
  • Subcubes
  • Key Performance Indicators
  • Glossary of MDX Terms
Data Mining Extensions
  • Case and Content Queries
  • Prediction Queries
  • Cluster Queries
  • Glossary of DMX Terms
Summary
  • Summary and Next Steps
  • Bonus Lecture - Discounts