---

Detailed Syllabus & Weekly Breakdown

Module 1: Data Foundations & Advanced Excel (Weeks 1–3)

Focus: Understanding data and using spreadsheet power-tools

• Data Basics: Types of data, cleaning principles, and data pipelines.
• Excel Power Functions: VLOOKUP, HLOOKUP, INDEX-MATCH, and advanced conditional formatting.
• Data Summarization: Pivot Tables, Pivot Charts, and basic dashboarding in Excel.
• Statistical Concepts: Mean, median, variance, and standard deviation for business.

Module Outcome: Clean messy spreadsheets and generate interactive Pivot Table dashboards.

Module 2: SQL for Data Analysis (Weeks 4–6)

Focus: Querying relational databases

• SQL Basics: SELECT, FROM, WHERE, and filtering data safely.
• Aggregations: GROUP BY, HAVING, and aggregate functions (SUM, AVG, COUNT).
• Relational Queries: INNER JOIN, LEFT JOIN, and understanding database schemas.
• Advanced SQL: Subqueries, CTEs, and Window functions.

Module Outcome: Extract complex insights from large multi-table databases using SQL.

Module 3: Python Data Visualization (Weeks 7–9)

Focus: Programmatic data wrangling

• Python Basics: Syntax, lists, dictionaries, and loops.
• Pandas Library: Dataframes, series, handling null values, and merging data.
• Matplotlib & Seaborn: Generating programmatic charts, scatter plots, and heatmaps.
• Jupyter Notebooks: Creating reproducible data analysis reports.

Module Outcome: Write Python scripts to clean massive CSV files and generate analytical graphs.

Module 4: BI Dashboards & Capstone (Weeks 10–12)

Focus: Business Intelligence and storytelling

• Power BI / Tableau Basics: Connecting data sources and UI overviews.
• DAX & Calculated Fields: Creating custom metrics for business reporting.
• Storytelling with Data: Designing dashboards that answer specific business questions.
• Capstone Project: End-to-end extraction, cleaning, and visualization of a real business dataset.

Module Outcome: Deliver a professional interactive dashboard that executives can use for decision-making.

Comprehensive Learning Outcomes

• Analytical Mindset: Approach unstructured business problems and formulate data-driven solutions.
• Tool Proficiency: Seamlessly move between Excel, SQL, Python, and BI tools based on the task size.
• Communication: Translate complex data findings into clear, visual stories for non-technical stakeholders.

Assessment Weightage

Assessment Type	Weightage	Focus Area
SQL Query Tests	30%	Weekly tests to ensure syntax and logic correctness in databases.
Python Data Cleaning Project	40%	Taking a highly unformatted dataset and making it ready for BI tools.
Final Dashboard Presentation	30%	Presenting a BI dashboard to a panel as if they were business executives.

The "WhiteCollar" Career Advantage

Every company today generates data, but very few have staff that can interpret it. This course gives you the hard technical skills (SQL, Python) combined with the business logic (Dashboards) to make you an indispensable asset to management teams across any industry.