Data Analytics Bootcamp
Syllabus
Statistical Thinking
SQL
Python
Tableau
Lab
Capstone
Lab Sessions
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
Session 10: A/B Testing
Session 11: Cohort Analysis
Session 12: Simple Linear Regression and Forecasting
Session 13: Logistic Regression
Session 14: Clustering
Session 15: Geoanalytics
Session 16: SQL Alchemy
Slides
Grammar of Graphics
Data Analyst
Tableau
Tableau
Session 01: Introduction to Tableau
Session 02: Intermediate Visual Analytics
Session 03: Advanced Analytics
Session 04: Dashboard Design & Performance
Session 05: Sales Analysis Dashboard
Session 06: Customer Analysis Dashboard
Session 07: Spatial Analytics
Slides
Data Analyst
Data Analyst
Data Analyst
Data Analyst
Lab Sessions
Python
Git
GitHub
SQL
Tableau
Docker
Vs Code
Lab Session
Download Visual Studio Code from the official website:
download link
Docker
Lab Sessions
Download Docker Desktop from the official website:
download link
Git and GitHub
Lab Sessions
To verify that Git is installed, run:
Python
Lab Sessions
Download
Miniconda
from the official website:
download link
Tableau
Lab Sessions
You must create a
Tableau Public account
before working with the tool.
No matching items
