<aside>
🎯
IMPACT
Built a live revenue dashboard showing Total Revenue,
Conversion Rate, and Sales by Region — auto-updating
from a Google Sheet. Eliminates manual reporting and
gives leadership a single-screen view of business
health in under 5 seconds.
</aside>
🔴 The Problem
Executives and sales leaders make decisions based on
gut feel because there is no single place to see
revenue, conversion rates, and regional performance
in real time. Building reports manually in
spreadsheets takes hours and goes stale immediately.
🔵 My Approach
Built a Looker Studio dashboard connected directly
to a Google Sheet that auto-updates whenever new
data is entered. Leadership gets a single-screen
view of critical revenue metrics with visual
breakdowns by region and time period.
⚙️ Step-by-Step Execution
- Created a dataset with fields: Date, Region,
Revenue ($), Deals Closed, Leads Generated
- Connected data source to Looker Studio
- Built 2 KPI scorecards: Total Revenue
and Conversion Rate
- Built bar chart showing Revenue by Region
(East, West, South, North)
- Built line chart showing Revenue trend
over time (Feb → Jan)
- Applied dark professional theme with
clear labels and consistent styling
📊 Results
- Revenue and conversion rate visible in a
single screen — no spreadsheet digging needed
- Regional performance gaps immediately visible —
West region outperforming East by 2x
- Dashboard updates automatically when new
data is added — zero manual refresh needed
- Demonstrates ability to translate raw data
into executive-ready visual reporting
🧠 Key Learnings
- Dashboard design is about hierarchy — the most
important numbers (Revenue, Conversion Rate)
go at the top before any charts
- Dark theme improves readability for executive
presentations compared to default white