Data Analysis Course Content:

1. Introduction to Data Analysis
   What is data analysis? Data lifecycle, types of analysis (descriptive, diagnostic, predictive), tools used, and 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, and building a professional portfolio to present to employers.