Data Analytics with Excel & SQL

Excel ko ek analyst ki tarah use karna seekho.

Use lookup formulas — VLOOKUP, XLOOKUP and INDEX-MATCH

Use logical formulas — IF, IFS, AND, OR for decision-based columns

Apply text and date formulas to clean raw data

Set up data validation rules to prevent bad data entry

Use conditional formatting to highlight important values

Bade dataset ko seconds me summary me badal do.

Build a Pivot Table to summarise a large dataset

Add calculated fields and grouped values to a Pivot Table

Build a Pivot Chart linked to a Pivot Table

Use Goal Seek and Data Tables for What-If Analysis

Explain when to use a Pivot Table versus a formula-based summary

Real company data database me hota hai — usse nikalna seekho.

Explain what a relational database and a table are

Write SELECT queries to retrieve specific columns

Use WHERE to filter rows based on one or more conditions

Use ORDER BY and LIMIT to sort and restrict results

Explain primary and foreign keys with a simple example

Ek table kabhi poori kahani nahi batati — jodna seekho.

Explain INNER JOIN, LEFT JOIN and their difference

Write a query joining two related tables

Write a query joining three or more tables

Explain common join mistakes and how to avoid them

Use table aliases to write cleaner multi-table queries

Ab numbers se insight nikalna seekho — total, average, trend.

Use GROUP BY with COUNT, SUM and AVG functions

Use HAVING to filter grouped results

Write nested/sub-queries for a multi-step analysis

Combine joins, grouping and filtering in one analytical query

Explain how to validate a query's results against the raw data

Data ko numbers ki jagah picture ki tarah dikhao.

Choose the right chart type for a given dataset and message

Build bar, line and combo charts in Excel

Explain what Power Query is used for

Import and clean a dataset using Power Query

Combine data from two sources using Power Query

Ab sab kuch jod kar ek professional dashboard banao.

Plan a dashboard layout around key business questions

Add slicers and filters to make a dashboard interactive

Link charts and Pivot Tables to respond to slicer selections

Apply clean formatting and branding to a dashboard

Test the dashboard with sample user questions

Ab ek real-jaisa messy dataset khud handle karo.

Select a real-style business dataset for the capstone project

Clean and prepare the dataset using Excel and Power Query

Query the dataset using SQL to extract key metrics

Identify 3-4 key business questions the data can answer

Draft initial findings from the analysis

Ab apna analysis ek dashboard aur presentation me convert karo.

Build a complete interactive dashboard for the capstone dataset

Design a short presentation summarising key findings

Recommend business actions based on the analysis

Present the capstone project to peers or a mentor

Incorporate feedback into a final polished version