Practical Data Analysis – SQL & Tableau with Real Projects

Course Curriculum

Chapter 1: Introduction and Thank you!

Lecture 1: Introduction

Chapter 2: Download SQL Server Management studio and Adventureworks database

Lecture 1: Download SQL Server Management studio and Adventureworks database

Chapter 3: What is SQL and a Relational Database?

Lecture 1: SQL, Relational Database and Entity Relationship Diagram

Lecture 2: Quick SSMS overview

Chapter 4: Beginner SQL

Lecture 1: Select, From, Where, And, Or

Lecture 2: Select, From, Where, And, Or – Questions and Answers

Lecture 3: Upper and Lower

Lecture 4: IN and NOT IN operators

Lecture 5: Distinct, Like and Order By

Chapter 5: Intermediate SQL

Lecture 1: Inner Join

Lecture 2: Left and Right Join

Lecture 3: Joins – 2 Questions and Answers

Lecture 4: Union and Union All

Chapter 6: Aggregate Functions

Lecture 1: Sum, Round and Group by

Lecture 2: Having and Practice Question

Lecture 3: Count

Lecture 4: Max and Min

Lecture 5: Average

Lecture 6: Questions on Aggregate Functions

Chapter 7: Sub Query and Common Table Expression (CTE)

Lecture 1: Sub Queries

Lecture 2: Common Table Expression (CTE)

Chapter 8: Case Statement and Flags

Lecture 1: Case When

Lecture 2: Flags

Chapter 9: Window Functions

Lecture 1: Row_number()

Lecture 2: Row Number Q and A

Lecture 3: Lead and Lag

Chapter 10: Date Functions

Lecture 1: Year, Month, Day and Get Date

Lecture 2: DateDiff

Lecture 3: DateAdd

Lecture 4: Date table

Lecture 5: Cast and Convert

Lecture 6: Joining tables on more than one condition

Lecture 7: Date Functions – Questions and Answers

Chapter 11: String Functions

Lecture 1: Concat

Lecture 2: Substring

Chapter 12: Google Sheets and Pivot Tables

Lecture 1: Google Sheets – Pivot Tables

Lecture 2: Any Questions?

Chapter 13: Adventureworks Analysis Project

Lecture 1: Countries' Sales by Age Group

Lecture 2: Products' Sales by Age Group

Lecture 3: Sales in USA and Australia compared

Lecture 4: Products First Reorder Date

Lecture 5: Products with high stock levels

Lecture 6: Sales on Promotion

Lecture 7: Change in value between a customers' first and last purchase

Chapter 14: Profile of customers who purchased a bike

Lecture 1: Customers by commute distance and country

Lecture 2: Amount of bike purchases by salary

Lecture 3: Sales for customers with children vs no children

Lecture 4: Putting it together

Lecture 5: Additional Analysis – Next Product Purchased after Bike Part 1

Lecture 6: Additional Analysis – Next Product Purchased after Bike Part 2

Chapter 15: Create Tableau Dashboard

Lecture 1: Getting the data for Tableau

Lecture 2: Download and install Tableau Public

Lecture 3: Tableau Overview

Lecture 4: Create Dual Axies Chart

Lecture 5: Create Country sales donut chart

Lecture 6: Create stacked bar chart and grouping our data

Lecture 7: Create Sales Cards

Lecture 8: Accessories bar chart

Lecture 9: Building our dashboard

Lecture 10: Format and publish the dashboard to Tableau Public

Lecture 11: Add Additional Sheet to Dashboard – Country Sales in a Map

Lecture 12: Add Additional Sheet to Dashboard – Running Total Chart

Chapter 16: Create your Own Stock Price Tracker

Lecture 1: What we'll do in this section

Lecture 2: Getting our Data

Lecture 3: Connect Tableau to Data Source and Change Default Properties

Lecture 4: Build our Candlestick Chart

Lecture 5: Create our Volume and Volatility Charts

Lecture 6: Import Logos to Tableau

Lecture 7: Create Last Price and % Change Cards

Lecture 8: Put Dashboard Together

Lecture 9: Format & Publish our Dashboard

Lecture 10: Add 2 Additional Cards – One Year Low and One Year % Change

Chapter 17: More Tableau Practice – Stock Portfolio Dashboard

Lecture 1: Introduction – What you will do in this section

Lecture 2: Getting our Stock Data

Lecture 3: Download Tableau and Connect to Data Source