Data Analytics Bootcamp — Complete Course

A complete 5-day Data Analytics bootcamp with hands-on labs, notebooks, mini projects, and a capstone — designed for engineering and BCA students.

---

Repository Structure

Dr.-AIT-kids-study-content/
├── Day_1/                          # Foundations: Python, Pandas, Data Cleaning
│   ├── Session_1_Introduction/
│   ├── Session_2_Data_Collection_Cleaning/
│   ├── Session_3_Python_for_Analytics/
│   └── Mini_Project_SuperMart/
│
├── Day_2/                          # EDA & Visualization
│   ├── Session_1_EDA/
│   ├── Session_2_Visualization_Fundamentals/
│   ├── Session_3_Advanced_Visualization/
│   └── Mini_Project_Student_Performance/
│
├── Day_3/                          # SQL & Business Analytics
│   ├── Session_1_SQL/
│   ├── Session_2_Business_Analytics/
│   └── Session_3_Presentation/
│
├── Day_4/                          # BI Tools & Dashboard Development
│   ├── Session_1_BI_Tools/
│   ├── Session_2_Dashboard_Building/
│   ├── Session_3_Capstone_Initiation/
│   └── extras/
│
├── Day_5_6/                        # Capstone Completion & Valedictory
│   ├── Session_1_Capstone_Development/
│   ├── Session_2_Presentation_Evaluation/
│   └── Session_3_Valedictory/
│
└── Capstone_Data_Analysis_Project/ # HR Analytics Capstone (reference)
    ├── data/
    └── notebooks/

---

Course Curriculum

Day	Theme	Sessions	Mini Project
Day 1	Foundations	Intro to Analytics · Data Cleaning · Python & Pandas	SuperMart Sales Intelligence
Day 2	Explore & Visualize	EDA · Visualization Fundamentals · Advanced Visualization	Student Performance Dashboard
Day 3	SQL & Business Thinking	SQL Queries · Business Analytics · Data Storytelling	Business Intelligence Case Study
Day 4	BI Tools & Dashboards	Power BI / Tableau · Dashboard Building · Capstone Initiation	Kevin Cookie Company
Day 5 & 6	Capstone & Valedictory	Capstone Development · Presentations · Valedictory	HR Analytics Capstone

---

Quick Start

Prerequisites

pip install pandas numpy matplotlib seaborn requests jupyter

Tool	Version
Python	3.8+
Pandas	1.5+
NumPy	1.20+
Matplotlib	3.5+
Seaborn	0.12+

Run Day 1 Mini Project

cd Day_1/Mini_Project_SuperMart/scripts
python 00_generate_data.py
python supermart_analysis.py

Run Day 2 Complete Notebook

Open Day_2/Day_2_Complete_EDA_and_Visualization.ipynb in VS Code or Jupyter and run all cells.

Run Individual Session Labs

# Day 1
python Day_1/Session_1_Introduction/Lab_VSCode_Dataset_Exploration.py
python Day_1/Session_2_Data_Collection_Cleaning/Lab_VSCode_Data_Cleaning.py
python Day_1/Session_3_Python_for_Analytics/Lab_VSCode_Dataset_Manipulation.py

# Day 2
python Day_2/Session_1_EDA/Lab_VSCode_EDA.py

---

Google Colab

To run notebooks in Google Colab:

1. Go to colab.research.google.com
2. File → Open notebook → GitHub tab
3. Paste this repo URL and select any .ipynb file

---

Learning Outcomes

Upon completing this bootcamp, students will be able to:

• Explain the Data Analytics lifecycle end-to-end
• Clean and preprocess real-world datasets using Python and Pandas
• Conduct Exploratory Data Analysis (EDA) with statistical summaries
• Build professional visualizations with Matplotlib and Seaborn
• Write SQL queries for structured data analysis
• Construct interactive dashboards in Power BI or Tableau
• Extract actionable business insights from data
• Present analytical findings to a non-technical audience

---

Evaluation Criteria

Component	Weight
Lab Participation	20%
Practical Assignments	25%
Capstone Dashboard Quality	25%
Insight Interpretation	15%
Final Presentation	15%

---

Data Analytics Bootcamp — Building real skills, one day at a time.