Course SYLLABUS - LDA COURSES
Data Analytics Certificate Course
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
- Tableau vs. PowerBI
Module 5A: 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 5B: 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 5C: 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 5D: 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 6: Introduction to Databases
- Module 6 Overview
- Understanding Databases
- SQL vs Databases
Module 7A: 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 7B: 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 7: Exercises
- Module 7: 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 8: Wrap-up!
- Module 8 Overview
- Introduction to Python
- Introduction to R
- Introduction to PowerBI
- Introduction to Google Data Studio
- Tips for Effective Job Search
- Why Should You Consider Having a Data Analytics Portfolio
- Self Reflection
Tableau Course
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
SQL and Databases Course
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
Microsoft Excel Course
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
Other Ways To Connect
By submitting your phone number, you agree to receive text messages from 1800-400-5321. If you do not wish to receive text messages, reply STOP.
Free 1-on-1 Info Session
Pick a time that works for you!