| 1  | Introduction to Data Analysis  | What is data analysis? Data lifecycle, types of analysis (descriptive, diagnostic, predictive), tools used, career paths in the field
| 2  | Excel for Data Analysis  | Data cleaning, formulas, filters, conditional formatting, pivot tables, charts, and scenario analysis
| 3  | SQL Fundamentals  | Introduction to databases, basic SQL commands: SELECT, WHERE, JOIN, GROUP BY, generating reports from multiple tables, hands-on applications
| 4  | Data Analysis with SQL  | Practical analysis exercises on real datasets (sales, HR, products), writing professional queries
| 5  | Power BI – Part 1  | Importing data from Excel and SQL, data modeling, building relationships between tables
| 6  | Power BI – Part 2  | Creating interactive reports, using DAX, building professional dashboards, visualizing KPIs
| 7  | Analytical Thinking & Decision-Making  | How to interpret results and extract insights; case studies on data-driven decision-making
| 8  | Capstone Project  | Each student works on a real-world dataset and delivers: a full analysis report, Power BI dashboard, and SQL queries
| 9  | Job Market Preparation  | How to write a data analyst CV, common interview questions, building a professional portfolio to present to employers