This interactive Excel Sales Dashboard was built to empower Revenue Operations (RevOps) teams with crystal-clear visibility into regional, personal, and platform-based sales performance. Designed to help business stakeholders quickly assess performance across countries, cities, POS technologies, and opportunity owners, this project brings raw data to life with elegant and insightful visuals.
Created by Tosin Bello, a data analyst and data scientist focused on business intelligence and data storytelling.
This project demonstrates how Microsoft Excel can serve as a lightweight yet powerful BI (Business Intelligence) tool, capable of delivering deep sales insights in a scalable and interactive format.
Use Case: RevOps and executive sales teams who need instant, digestible performance overviews for strategy reviews, investor reporting, and internal KPIs.
- Total Turnover: ₦1.2B+ (toggleable in CAD, EUR, GBP, USD).
- Top 3 Performing Countries:
- 🇺🇸 United States: ₦324.4M
- 🇪🇸 Spain: ₦247.4M
- 🇫🇷 France: ₦245.5M
- Bottom 3 Countries by Sales:
- Czech Republic, Ireland, and Reunion (₦400k – ₦1M)
- Top Cities by Revenue:
- London leads with ₦102M, followed by Chicago and Paris.
- Opportunity Owner Performance:
- Amanda Nelson tops the leaderboard at ₦645.5K, with others like Sherry Mercer and Samuel Fischer closely trailing.
- POS System Impact:
- Toast dominates POS turnover at ₦221.2M, vastly outperforming PI Electronique and Lightspeed Series.
- Advanced Excel Dashboarding:
- Interactive slicers, PivotTables, dynamic bar charts, KPI visuals, and clean UI design.
- Data Visualization & Storytelling:
- Translated structured sales data into actionable insights through effective layout, hierarchy, and contextual filtering.
- Business Intelligence Thinking:
- Dashboard built to answer real-world RevOps questions: "Who’s performing best?", "Where are we growing?", "Which tools deliver ROI?"
| Tool | Purpose |
|---|---|
| Microsoft Excel | Dashboard development, slicers, visuals |
| Power Query (optional) | For scalable data transformation (if required) |
| Adobe/Canva (optional) | Color theory and brand aesthetics (for dashboard polish) |
Employers need data analysts who can do more than just clean data—they need professionals who translate data into impact. This dashboard is a perfect example of that skill:
✅ Fast insights,
✅ Executive-ready visuals,
✅ Multi-dimensional analysis in one screen.
📧 Email: [email protected]
🔗 LinkedIn: Tosin Bello
💡 Looking to turn your raw sales data into a boardroom-ready decision tool? Let’s talk.