Data Analytics Bootcamp
Syllabus
Statistical Thinking
SQL
Python
Tableau
Lab
Capstone
Statistical Thinking
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
Statistics
Statistics Session 01: Data Layers and Bias in Data
What is Data Analytics, Data Layers, Types of Biases
This chapter introduces the foundations of data analytics and statistical thinking.
Students explore how data becomes insight, what types of analytics exist, and how…
Statistics Session 02: Data Types
Data Types, Central Tendancy
Statistics is the branch of mathematics that transforms numbers (data) into useful information fohr decision makers.
Statistics Session 03: Probabilistic Distributions
Continues Distributions
In Data Analytics, we
rarely
know outcomes
with certainty
.
Statistics Session 04: Probabilistic Distributions
Discrete Probability Distributions
Up to this point, we focused on
continuous distributions
, where variables can take infinitely many values within a range.
Statistics Session 05: Sampling
Sampling
In statistics:
Statistics Session 06: Inferential Statistics
Hypothesis Testing
In the
statistical world
, a
hypothesis
is an assumption about a specific population parameter, such as a mean, a proportion, or a standard deviation.
No matching items