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
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
Tableau
Tableau
Session 01: Introduction to Tableau
This session introduces the
foundations of Tableau
, a leading platform for
interactive data visualization and business intelligence
.
Session 02: Intermediate Visual Analytics
By the end of this session, you should be able to:
Session 03: Advanced Analytics
In previous sessions, we focused on building visualizations, working with filters and parameters, and creating calculated fields. We also introduced key concepts such as
rela…
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…
Session 05: Sales Analysis Dashboard
Advanced Dashboards | 1
In the comming two sessions we are going to build solid dashboards first of all to enrich our portfolio and obtain advanced dashboard development skills.
Session 06: Customer Analysis Dashboard
Advanced Dashboards
The purpose of this dashboard is to analyze customer behavior, customer quality, purchasing patterns, and long-term customer value within the retail business.
Session 07: Spatial Analytics
Working with Geographic Data in Tableau
Spatial analytics
focuses on analyzing data that contains a geographic component.
No matching items
