Project Details

Built a dynamic Excel-based sales analytics report using Pivot Tables, Power Query, and basic DAX to optimize discounting, strengthen negotiation levers, and surface high-potential markets—delivering actionable recommendations to improve sales tactics, customer experience, and revenue.

Key Deliverables:

1. Customer discount effectiveness and negotiation insights
2. Market and country opportunity scans for expansion
3. Interactive, presentation-ready report with clear KPIs

Tech & Skills:

1. Excel Pivot Tables, Power Query, DAX (Basics)
2. Conditional Formatting and report presentation
3. Sales domain metrics and KPI design

Impact:

1. Enabled continuous monitoring and evaluation of sales performance
2. Translated raw data into actionable insights that drive growth and competitiveness

Project Details

In this project, the goal was to build one unified report for stakeholders across sales, marketing, finance, supply chain, and executives—replacing fragmented files and enabling faster, reliable decision-making.

The focus areas were:

Robust star-schema data modeling (10+ tables)
User-empathetic design with intuitive navigation
Drillable insights via reusable DAX measures

I learned and applied the following:

Power Query for ingestion & automation
Basic and complex DAX formulas for KPIs
Data modeling best practices across domains
Selecting visuals and applying design principles
Navigation using bookmarks, slicers, and role-based views
Publishing in Power BI Service with row-level security & scheduled refresh
Collecting stakeholder feedback and iterating
Building Finance, Sales, Marketing & Supply Chain metrics

Outcome: Clearer discount levers, better forecast visibility, and faster alignment on growth and margin priorities.

Live Interactive Dashboard

Project Details

Challenge: Leadership needed insights on customers, products, discounts, and trends to guide pricing, product mix, and market planning—without relying on BI dashboards.

My Task:
Analyzed 10 ad-hoc business questions using SQL.
Designed queries with CTEs, window functions, and optimized joins.
Validated results with edge-case testing and documented assumptions.
Built an executive-ready slide deck summarizing insights and actions.

Approach:
Used modular SQL for scenario analysis across customers, products, and regions.
Applied QA checks (row counts, outlier detection, reconciliation) for reliable outputs.
Structured findings into “What happened, Why it matters, What to do.”

Outcome:
Segmented customers and cohorts, ranked SKUs, quantified discount leakage, and revealed seasonality.
Improved analysis speed, reproducibility, and leadership trust in outputs.
Delivered clear pricing guardrails, targeting priorities, and planning recommendations.