2-Week Data Analytics Crash Training¶
From zero to job-ready in 10 days. This is a hands-on, project-driven bootcamp covering the full analytics stack — SQL, Python, Pandas, Power BI, Tableau, and more.
What You'll Learn¶
| Week 01 — Foundations | Week 02 — Tools & Advanced | |
|---|---|---|
| Day 1 | Intro to Data Analytics + Excel | Power BI Basics & Dashboards |
| Day 2 | SQL Basics + SQL Advanced | Tableau + Business Analytics |
| Day 3 | Python + NumPy & Pandas | Advanced Excel + KPI Design |
| Day 4 | Data Cleaning + EDA | ML for Analysts + Storytelling |
| Day 5 | Visualization + Statistics | Capstone Project + Mock Interview |
Who This Course Is For¶
Every note in this course is written for three audiences simultaneously:
Beginners
Career switchers and people learning analytics for the first time. Core concepts are jargon-free and grounded in business examples.
Mid-level analysts
Practitioners who know the tools but want to sharpen fundamentals and fill gaps. Look for the For mid-level analysts callouts.
Senior analysts
Professionals preparing for interviews, learning advanced SQL/Python patterns, or building a portfolio. Look for the For senior analysts callouts and the [Senior] interview questions.
7 Real-World Projects¶
Complete guided projects using the same tools and workflows you'd use on the job.
| # | Project | Tools |
|---|---|---|
| 1 | Sales Dashboard | Excel, SQL, Power BI |
| 2 | Customer Churn Analysis | Python (Pandas), SQL |
| 3 | HR Analytics Dashboard | Excel, Power BI, Python |
| 4 | COVID-19 Data Analysis | Python, matplotlib, SQL |
| 5 | E-commerce Analytics | SQL, Python, Tableau |
| 6 | Financial Performance Analysis | Excel, SQL, Power BI |
| 7 | IPL Sports Analytics Dashboard | Python, SQL, Tableau |
Interview Preparation¶
The Interview Prep section contains:
- SQL Question Bank — 100+ questions with full answers, tiered by difficulty
- Pandas Interview Questions — 150+ questions with a full Jupyter notebook masterclass
- Excel, KPI, Dashboard, and Business Case questions — everything an interviewer might ask
How to Use This Course¶
As a student in the live bootcamp: Follow the daily schedule. Start with the agenda file for each session, work through the topic files in order, and complete the practice exercises before moving on.
Self-paced: Start with Week 01, Day 01. The navigation footer at the bottom of each page links to the next file — just keep clicking forward.
Interview prep only: Jump straight to Interview Prep in the navigation. The SQL Q&A and Pandas questions are complete and ready to use.
Project-based: Pick a project from the Projects section, read the business problem, and work through each file. Dataset links are in dataset-guide.md.