Module Zero: Course Introduction
Module One: Introduction to Data Analytics and the Data Analyst Role
Module Two: Data Analytics and Visualization using Tableau
-
Tableau Fundamentals - Introduction (9:45)
-
Tableau Fundamentals - Download, Installation and Datasets (1:07)
-
Tableau Fundamentals - Interface Walk-through (12:37)
-
Importing and Joining data sets in Tableau (6:29)
-
Tableau Report 1 - Customer per Shipment Country (7:42)
-
Creating Calculated Fields in Tableau (7:52)
-
Tableau Report 2 - Creating Forecasts in Tableau (4:27)
-
Tableau Report 3 - Revenue per Category (2:44)
-
Tableau Report 4 - Actual vs Target (4:01)
-
Tableau Dashboard 1 - Sales Dashboard (3:17)
-
Tableau Dashboard 2 (5:27)
-
Tableau Stories (14:08)
Module Three: Analyzing data using SQL on AWS RDS
-
Introduction to SQL (8:00)
-
Free AWS Account Setup (12:07)
-
AWS Relational Database Service (RDS) Setup (11:09)
-
Azure Data Studio - Download and Install (3:23)
-
Create Database, Schemas and Tables (4:43)
-
SQL Select Statement (6:56)
-
SQL WHERE Clause (6:05)
-
SQL ORDER BY Clause (1:57)
-
SQL Arithmetic Operators (3:33)
-
Concatenation in SQL (4:12)
-
SQL Comparison Operators (5:26)
-
LIKE operator & SQL Logical Operators (7:45)
-
SQL Group Functions (SUM, GROUPBY, MIN, ..) (14:55)
-
SQL Joins (15:03)
-
SQL SubQuery (7:23)
-
Window Functions (5:17)
-
SQL Create Statement (5:04)
-
SQL Insert Statement (9:10)
-
SQL Update Statement (7:09)
-
SQL Drop & Delete Statement (5:18)
-
SQL Views (7:31)
-
Shutting Down AWS RDS Instance (1:29)
-
Hands-on SQL Exercises (1:41)
-
Solution to SQL Exercises
Module Four: AWS Cloud Data Analytics
Bonus Section - Career Mentoring Module
