Syllabus

Course SYLLABUS - LDA COURSES

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

Message or Call us on WhatsApp

Text or Call

Free 1-on-1 Info Session

Pick a time that works for you!

Scroll to top
0 Item | $0.00
View Cart