Module 1: Introduction to Data Analytics
• Module 1 Overview
• What is Data, Data Analytics & Data Science
• Modern Data Ecosystem
• Different Data Professionals / Jobs
• Foundational Data Tools
• Your Future in Data Analytics & Data Science
• Types of Data Analytics / Data Analysis
• Finding Good Datasets
• Horizontal vs Vertical Datasets
• Difference between a Dataset and a Database
• Framing a Business Problem
• Data Analytics Portfolio
Module 1A: Exercises
• Module 1: Exercises Overview
• Find and Explore Good Datasets
• Optional: Document Initial Thoughts
• Optional: Industry Check
• Optional: My Career Aspirations
Module 2: Introduction to Data Science • Module 2 Overview
• Module 2 Slides
• A Closer Look at Machine Learning
• Predictive Analytics vs. Forecasting
• Algorithms
• Text Analytics
• GenAI
Module 3: Data Visualization
• Module 4 Overview
• Module 4 Slides
• Introduction to Data Visualization
• Types of Data Visualization Their Applications
• Data Visualization Best Practices
• Tableau vs. PowerBI
Module 4A: Introduction to Tableau
• Module 5A Overview
• Tableau: Introduction
• Tableau Public Overview
• Tableau: Setup
• Additional Resources: Scatterplot Example
• Additional Resources: Tableau Chart Catalogue
• Additional Resources: Microsoft Excel: Example of Exploratory Data Analysis using Significant Volcanic Eruptions Dataset from Tableau
• Additional References: Free Tableau Training Videos
Module 4B: Working with Tableau
• Module 5B Overview
• Creating Common Data Visualizations
• Advanced Formatting for Common Charts
• Joins vs. Relationships (Blending Data)
• Calculated Fields
• Sort, Filter, Highlight
• Groups vs Sets
• Timeseries Analysis & Dual Axis
• Creating Animations using Pages
• Advanced Features: Introducing Parameters
• Advanced Features: Introducing LODs
Module 4C: Storytelling with Tableau
• Module 5C Overview
• What is a Dashboard
• Creating a Beginner Friendly Dashboard
• Creating an Intermediate Level Dashboard
• Creating an Advanced Level Dashboard
• Creating Stories
Module 4D: Exercises • Module 5D: Exercises Overview
• Tableau Beginner Level Practice Exam
• Tableau Intermediate Level Practice
• Tableau Advanced Level Practice
• Redo AirBnB Questions with Tableau
• Replicate Iris Cluster Creation
• Optional: Replicate creating Fertility Rate Dashboard
Module 1: Introduction to Data Analytics
• Module 1 Overview
• What is Data, Data Analytics & Data Science
• Modern Data Ecosystem
• Different Data Professionals / Jobs
• Foundational Data Tools
• Your Future in Data Analytics & Data Science
• Types of Data Analytics / Data Analysis
• Finding Good Datasets
• Horizontal vs Vertical Datasets
• Difference between a Dataset and a Database
• Framing a Business Problem
• Data Analytics Portfolio
Module 1A: Exercises
• Module 1: Exercises Overview
• Find and Explore Good Datasets
• Optional: Document Initial Thoughts
• Optional: Industry Check
• Optional: My Career Aspirations
Module 2: Introduction to Data Science (Optional)
• Module 2 Overview
• Module 2 Slides
• A Closer Look at Machine Learning
• Predictive Analytics vs. Forecasting
• Algorithms
• Text Analytics
• GenAI
Module 3: Introduction to Databases
• Module 6 Overview
• Understanding Databases
• SQL vs Databases
Module 4A: SQL Setup
• Module 7A Overview
• SQLite Studio: Introduction & Setup
• SQLite Studio: Examples of SQL Queries
• Mode: Introduction & Setup
• Mode: Practicing SQL Queries
• SQL Notes with Examples
Module 4B: SQL Practice
• Module 7B Overview
• Querying Data
• Sorting & Filtering Data
• Column Aggregations: Min, Max, Avg, Sum
• Row Aggregations: Group By & Having
• Subqueries
• Joins – Two Different Ways!
• SQL Tutorial W3 School
Module 6: Exercises
• Module 4 Exercises Overview
• SQL Practice Exam (with Answer Key)
• Mode: SQL Practice Assignment – Grocery Store
• Mode: Tutorial + SQL Challenge
• SQLite Studio: Northwind Database Practice
• SQL Tutorial
• SQL Murder Mystery Challenge
• Additional SQL Practice
Module 6: Wrap-up!
• Why Should You Consider Having a Data Analytics Portfolio
• Self Reflection
Module 1: Introduction to Data Analytics
• Module 1 Overview
• What is Data, Data Analytics & Data Science
• Modern Data Ecosystem
• Different Data Professionals / Jobs
• Foundational Data Tools
• Your Future in Data Analytics & Data Science
• Types of Data Analytics / Data Analysis
• Finding Good Datasets
• Horizontal vs Vertical Datasets
• Difference between a Dataset and a Database
• Framing a Business Problem
• Data Analytics Portfolio
Module 1A: Exercises
• Module 1: Exercises Overview
• Find and Explore Good Datasets
• Optional: Document Initial Thoughts
• Optional: Industry Check
• Optional: My Career Aspirations
Module 2: Introduction to Data Science
• Module 2 Overview
• Module 2 Slides
• A Closer Look at Machine Learning
• Predictive Analytics vs. Forecasting
• Algorithms
• Text Analytics
• GenAI
Module 3: MS Excel / Google Spreadsheet
• Module 3 Overview
• MS Excel vs. Google Sheets
• Google Sheet: Setup
• MS Excel: Setup
• MS Excel: Introduction
• MS Excel: Data Visualization
• Google Sheets: Data Visualization
• Pivot Tables
• MS Excel: Example of Exploratory Data Analysis using Significant Volcanic Eruptions Dataset from Tableau
• MS Excel: Example of Data Analysis with Wellbeing Toronto Dataset from City of Toronto Data Portal
Module 3A: Exercises
• Working with MS Excel / Google Sheets
• Unpivoting Data
• Practice with AirBnB Dataset: Data Analysis with MS Excel / Google
• Exploratory Data Analysis with MS Excel / Google Sheets
Module 4: Data Visualization
• Module 4 Overview
• Module 4 Slides
• Introduction to Data Visualization
• Types of Data Visualization Their Applications
• Data Visualization Best Practices
Pick a time that works for you!