BUSINESS ANALYTICS & AUTOMATED REPORTING

I turn raw business data into decision-ready dashboards and automated reporting systems.

SQL | Python | Tableau | Excel | BI

<aside> 📊

VIEW MY WORK ↓

</aside>

<aside> 💼

HIRE ME ON UPWORK →

</aside>

FEATURED CASE STUDIES

01 — CRM SALES INTELLIGENCE

Problem

Sales data was difficult to interpret — 8,800 raw CRM opportunities gave no clear read on revenue trends, win rates, or where deals were stalling in the pipeline.

Solution

Built an interactive CRM sales dashboard in Excel using pivot tables, pivot charts, slicers, and timelines — cleaning inconsistent close dates and excluding open deals to keep the KPIs reliable.

Key analysis

• Revenue: $10,005,534 total revenue won across 4,238 won deals
• Sales performance: 48.16% win rate · $2,360.90 average deal size · 47.98-day average sales cycle
• Customer trends: Sales agent Sarah generated the highest won revenue
• Pipeline: Most opportunities are lost at the Proposal stage
• KPIs: Product GTX Pro had the highest average deal size; Q4 was the strongest quarter

Business value

Management can see exactly where deals stall, which reps and products drive revenue, and where to focus coaching and pipeline attention — from a self-service dashboard instead of raw CRM exports.

View full case study →