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 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 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
Data Analytics Certificate Course
CLASS | CONCEPTUAL LEARNING | HANDS-ON LEARNING |
1 | Introduction to Data Analytics What is Data, Data Analytics, Data Science Modern Data Ecosystem Data Professionals Foundational Data Tools Your Future in Data Analytics & Data Science Types of Data Analytics Finding Datasets | Overview of Foundational Data Tools Exploring Datasets |
2 | Data Foundations Data Types Data Structures File Formats Data Sources Languages Data Repositories ETL Process Data vs Big Data Review 5 Vs of Data in the context of Big Data Key Concepts in Data Science Difference b/w Data Concepts, Tools, Techniques & Software Machine Learning vs AI vs Deep Learning | Overview of MS Excel
|
3 | Working with Data Simplified Data Analysis Process Exploratory Data Analysis (EDA) Complete Data Analysis Process (CAP methodology) | Data Analysis using MS Excel Data Validation |
4 | Data Visualization Importance of Data Visualization Types of Data Visualizations Industry Best Practices | Overview of Tableau |
5 | Data Storytelling & Presentation Creating Dashboards Data Storytelling | Data Analysis & Data Visualization using Tableau |
6 | Introduction to Database Management Understanding Databases | Overview of SQL |
7 | Data Validation What is Data Validation and why is it necessary? Analyzing Data using SQL and comparing results against Excel | SQL Queries Data Validation |
8 | Review & Recap + Brief Intro to Python R PowerBI | Presentations |
Tableau Course
CLASS | CONCEPTUAL LEARNING | HANDS-ON LEARNING |
1 | Introduction to Data Analytics & Data Visualization What is Data, Data Analytics, Data Visualization Types of Data Analytics Types of Data Visualizations Importance of Data Visualization | Overview of Tableau Finding and Exploring Datasets |
2 | Data Foundations Data Types Data Structures File Formats Data Sources Working with Data Simplified Data Analysis Process Exploratory Data Analysis (EDA) Complete Data Analysis Process (CAP methodology) | ■ Exploratory Data Analysis with Tableau ■ Learning how to work with Tableau I |
3 | Data Visualization Industry Best Practices | ■ Learning how to work with Tableau II |
4 | Data Storytelling & Presentation Creating Dashboards Data Storytelling Comparison to Microsoft PowerBI and Google Data Studio | Data Analysis & Data Visualization using Tableau |
Excel Course
CLASS | CONCEPTUAL LEARNING | HANDS-ON LEARNING |
1 | Introduction to Data Analytics What is Data, Data Analytics, Data Science Types of Data Analytics Finding Datasets | Overview of MS Excel Exploring Datasets |
2 | Data Foundations Data Types Data Structures File Formats Data Sources | Data Analysis with MS Excel using V-lookups, Pivot Tables and If statements
|
3 | Working with Data Simplified Data Analysis Process Exploratory Data Analysis (EDA) Complete Data Analysis Process (CAP methodology) | Data Analysis using MS Excel (continued) with more functions Data Validation |
4 | Data Visualization Importance of Data Visualization Types of Data Visualizations Industry Best Practices Data Storytelling & Presentation Creating Dashboards Data Storytelling | Data Visualization with MS Excel |
SQL Course
CLASS | CONCEPTUAL LEARNING | HANDS-ON LEARNING |
1 | Introduction to Data Analytics What is Data, Data Analytics, Data Science Types of Data Analytics Finding Databases Data Foundations Data Types Data Structures File Formats Data Sources Introduction to Database Management Understanding Databases | Overview of SQL |
2 | Introduction to Database Management Understanding Databases (continued) | Writing SQL Queries Data Validation |
3 | Data Validation What is Data Validation and why is it necessary? Analyzing Data using SQL and comparing results against Excel | More practice with SQL including Joins |
4 | SQL with Mode Understanding different SQL tools | Introduction to Mode for |
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!