Getting Started
  • Introduction
  • Objectives: SQL basics
  • SQL Basics
  • SQL Tools
  • Installing SQL Express,SSMS, Sample Database
  • Summary: SQL Basics
Writing SQL queries
  • Objectives: Writing SQL Queries
  • Writing SQL in SSMS
  • Joining two tables with SQL
  • Different types of Joins
  • Joining multiple tables
  • Summarising a table
  • Creating SQL calculations
  • Filtering data with the WHERE clause
  • Summary: Writing SQL queries
Creating the right data model for analysis
  • Objectives: Creating the right model for analysis
  • Turning database tables into star schemas
  • Building the Transaction table
  • Building the Product table
  • Building the Customer table
  • Building the Calendar table
  • Reviewing the model and creating a visualisation
  • Summary: Creating the right data model for analysis
Cleaning data to make for a better model
  • Objectives: Cleaning data to make for a better model
  • Fixing the customer issue
  • Fixing issues with Power Query
  • Changing the shape of data with Power Query (no SQL required)
  • Transforming Excel data and adding it to the model
  • Summary: Cleaning data to make for a better model
Generating insight with DAX calculations
  • Objectives: Generating insights with DAX calculations
  • Introduction to DAX
  • Creating DAX measures
  • Creating measures with expressions
  • Adding to the filter context programatically
  • Manipulating the filter context
  • Summary: Generating insights with DAX
Creating executive ready dashboards
  • Objectives: Creating executive level dashboards
  • Starting the dashboard
  • Completing the dashboard
  • Summary: Creating executive level dashboards
New features as of Nov-16
  • Introduction
  • Forecasting
  • Extracting information from fields
  • Arc GIS maps
  • Shape maps (ESRI)
  • Drilling to data