Microsoft Power BI Intermediate

"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"