Syllabus

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 of the Course

Brief Intro to Other Data Tools (for continued learning beyond this course)

Creating your Analytics Portfolio

Effective Job Search Tips

Optional Presentations (Tableau Project)

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 Part 1

3

Data Visualization

Industry Best Practices

Learning how to work with Tableau Part 2

4

Data Storytelling & Presentation

Creating Dashboards

Data Storytelling

Comparison to Microsoft PowerBI and Google Data Studio

Data Analysis & Data Visualization using Tableau

Optional Presentation (Tableau Project)

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 Relational Databases

Overview of SQL

2

Introduction to Database Management

Understanding Relational 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

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