Project Name: Sales Analysis Dashboard

1. Situation (Project Overview):

"I worked on a Sales Analysis project aimed at helping the business team understand customer behavior, product performance, and regional sales trends using SQL."

2. Task (Your Responsibility):

"My responsibility was to write efficient SQL queries to clean the data, perform analysis, and prepare datasets for dashboard visualization."

3. Action (How You Did It):

"I worked with tables like Orders, Customers, Products, and Regions. I used INNER and LEFT JOINS to combine data across these tables. I performed the following:

• Cleaned the data by filtering null values, correcting inconsistent product names, and removing duplicates.

• Used GROUP BY and aggregate functions to calculate monthly revenue, total units sold, and average order value.

• Implemented Window Functions to rank top-selling products by region and analyze customer purchase frequency.

• Used Common Table Expressions (CTEs) to break down complex queries, like finding repeat customers who increased their spending month-over-month.

• Created views for dynamic reporting in Power BI and optimized queries using indexing and subquery reduction where needed."

4. Result (Outcome/Impact):

"The business was able to identify the top 10 products driving 60% of revenue and launched focused promotions that increased Q3 sales by 12%. My queries also powered a dashboard that was used regularly by sales managers to monitor KPIs."

---

✅ Technical Skills Highlighted:

• JOINS (INNER, LEFT)

• Aggregations and GROUP BY

• CTEs

• Window Functions (RANK, ROW_NUMBER, etc.)

• Data cleaning with WHERE, CASE WHEN

• Query optimization (indexing, subqueries)

• Integration with Power BI