Data Analytics Bootcamp
Syllabus
Statistical Thinking
SQL
Python
Tableau
Lab
Capstone
Capstone Project
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
Capstone Project
Python
Tableau
SQL
Statistics
No matching items