Intermediate
Data Analyst
A practical, job-ready training program designed for aspiring data analysts. Learn by doing—from Excel to SQL to Python to Power BI. No fluff, just the skills you actually need to break into analytics and land a job. This 10-week program includes hands-on projects, real-world case studies, and career support to build your confidence and your portfolio.
Curriculum
- 10 Sections
- 53 Lessons
- 100h Duration
Week 1: Introduction to Data Analytics & Excel Mastery
6 Lessons
- Role of a Data Analyst
- Data-Driven Decision-Making
- Excel: Functions, Pivot Tables, Charts
- Data Cleaning & Manipulation in Excel
- Intro to Power BI
- Mini Project: Sales Performance Analysis with Excel + Power BI
Week 2: SQL for Data Analysis
6 Lessons
- Database & Relational Model Basics
- SQL: SELECT, WHERE, GROUP BY, JOIN
- Data Filtering, Aggregation, Subqueries
- Hands-on SQL with Real Datasets
- Power BI Integration
- Mini Project: Customer Segmentation with SQL + Power BI
Week 3: Advanced SQL & Data Handling
6 Lessons
- Window Functions, CTEs
- SQL Optimization
- Data Validation & Error Handling
- ETL Concepts
- Power BI Data Modeling
- Mini Project: E-commerce Sales Trend Analysis (SQL + Power BI)
Week 4: Python for Data Analysis (Part 1)
6 Lessons
- Python & Jupyter Setup
- Pandas, NumPy for Data Manipulation
- Data Cleaning
- Exploratory Data Analysis (EDA)
- Exporting DataFrames to Power BI
- Mini Project: Customer Behavior Analysis (Python + Power BI)
Week 5: Python for Automation + APIs
6 Lessons
- Visualization with Seaborn & Matplotlib
- Automating Data Workflows
- Web Scraping with BeautifulSoup
- API Data Fetching
- Python Visuals in Power BI
- Mini Project: Stock Market Analysis + Dashboard
Week 6: Data Visualization & BI Tools
5 Lessons
- Data Storytelling Fundamentals
- Building Dashboards in Power BI / Tableau
- KPIs, Interactivity & Report Building
- Real-World Data Insights
- Mini Project: Sales Analytics Dashboard in Power BI
Week 7: Statistics & Decision-Making
5 Lessons
- Descriptive vs Inferential Stats
- Probability, Hypothesis Testing
- A/B Testing, Correlation & Regression
- Statistical Analysis in Power BI
- Mini Project: Churn Prediction with Power BI
Week 8: Real-World Data & Industry Case Studies
5 Lessons
- Cleaning Raw Datasets
- Full Project Workflow (End-to-End)
- Identifying Business Metrics
- Group Case Study from Industry (Healthcare, E-com, etc.)
- Mini Project: Real-World Dashboard for Business Decisions
Week 9: Career Prep & Placement Training
5 Lessons
- Resume & LinkedIn for Analysts
- Portfolio Building with Projects
- Mock Interviews & Role-Specific Questions
- Critical Thinking Sessions
- Mini Project: Power BI Portfolio Showcase (3 Dashboards)
Week 10: Capstone Project & Final Review
3 Lessons
- Real-World Business Problem
- 1:1 Mentorship & Feedback
- Final Placement Guidance
