Data Analytics Bootcamp
Syllabus
Statistical Thinking
SQL
Python
Tableau
Lab
Capstone
Tableau
Syllabus
Statistical Thinking
Statistics
Statistics Session 01: Data Layers and Bias in Data
Statistics Session 02: Data Types
Statistics Session 03: Probabilistic Distributions
Statistics Session 04: Probabilistic Distributions
Statistics Session 05: Sampling
Statistics Session 06: Inferential Statistics
Slides
Course Intro
Descriptive Stats
Data Types
Continuous Distributions
Discrete Distributions
Sampling
Hypothesis Testing
SQL
SQL
Session 01: Intro to Relational Databases
Session 02: Intro to PostgreSQL
Session 03: DA with SQL | Data Types & Constraints
Session 04: DA with SQL | Filtering
Session 05: DA with SQL | Numeric Functions
Session 06: DA with SQL | String Functions
Session 07: DA with SQL | Date Functions
Session 08: DA with SQL | JOINs
Session 09: DA with SQL | Advanced SQL
Session 10: DA with SQL | Advanced SQL Functions
Session 11: DA with SQL | UDFs, Stored Procedures
Session 12: DA with SQL | Advanced Aggregations
Session 13: DA with SQL | Final Project
Slides
Intro to Relational Databases
Intro to PostgreSQL
Basic Queries: DDL DLM
Filtering
Numeric Functions
String Functions
Date Functions
Normalization and JOINs
Temporary Tables
Advanced SQL Functions
Reporting and Analysis with SQL
Advanced Aggregations
Python
Python
Session 01: Programming for Data Analysts
Session 02: Python basic Syntax, Data Structures
Session 03: Introduction to Pandas
Session 04: Advanced Pandas
Session 05: Intro to Data Visualization
Session 06: Data Visualization
Session 07: Working with Dates
Session 08: Data Visualization | Plotly
Session 09: Customer Segmentation | RFM
Slides
Data Analyst
Tableau
Tableau
Tableau Session 01: Introduction to Tableau
Tableau Session 02: Intermediate Visual Analytics
Tableau Session 03: Advanced Analytics
Tableau Session 04: Dashboard Design & Performance
Slides
Data Analyst
Data Analyst
Data Analyst
Data Analyst
Tableau
Tableau
Tableau Session 01: Introduction to Tableau
This session introduces the
foundations of Tableau
, a leading platform for
interactive data visualization and business intelligence
.
Tableau Session 02: Intermediate Visual Analytics
By the end of this session, students will be able to:
Tableau Session 03: Advanced Analytics
In previous sessions, we focused on:
Tableau Session 04: Dashboard Design & Performance
Strorytelling, Color Theory, UX Principles For Dashboard Design
This session focuses on
how to design dashboards that are clear, beautiful, and performant
.
Students learn the foundations of visual storytelling, color theory, UX…
No matching items
