This project was completed as part of the Tata Data Visualisation: Empowering Business with Effective Insights job simulation on the Forage platform in July 2025. The objective was to analyze large-scale retail data, uncover business insights, and present executive-ready visualizations for leadership decision-making.
As a data analyst intern, I was tasked with delivering insights that would inform business strategy using Tableau. I analyzed over 12,000+ rows of retail transaction data, designed 4 distinct visualizations, and compiled an executive dashboard based on key questions from the CEO and CMO.
- Tableau – for data visualization and dashboard design
- Excel – for data cleaning and exploration
- Data Storytelling – for presenting visual insights to stakeholders
- Executive Communication – writing business questions & presentations
- Prepared 4 stakeholder-specific questions:
- CEO → Focused on seasonality and revenue trends
- CMO → Targeted geographical performance and market expansion
- Completed an applied quiz focused on data storytelling and visual cognition.
- Learned when and why to choose the most effective chart types based on the audience, purpose, and complexity of the data — applying core visualization principles like clarity, comparison, and simplicity.
-
Created the following Tableau visuals:
- Line Chart – Monthly revenue trends
📈 Insight: Revenue grew by 40% from August to November, peaking at $1.5M - Bar Chart (excluding UK) – Top 10 countries by revenue
🌍 Insight: Netherlands, Ireland, Germany, France show highest growth potential - Color-Graded Comparison – Top 10 customers
👥 Insight: Low revenue dependence on single buyers (only 17% variance) - Map Chart – Regional sales overview
🗺️ Insight: Expansion opportunities in Asia, Africa & Americas
- Line Chart – Monthly revenue trends
-
These were integrated into a single interactive dashboard for executive decision-making.
- Recorded a final walkthrough video explaining:
- Each chart selection logic
- Formatting choices (color, layout)
- Strategic recommendations for leadership
- Demonstrated proficiency in data storytelling, dashboard interactivity, and tailoring communication for CXO-level stakeholders.
👉 Click here to view the interactive dashboard
| Focus Area | Insight |
|---|---|
| Revenue Trend | Growth spike starts in September; Q4 sales peak at ~$1.5M |
| Country Expansion | Focus on Ireland, Germany, Netherlands, France |
| Customer Segments | Distributed purchase behavior – stable revenue stream |
| Regional Gaps | Weak presence in Asia & Africa – expansion recommended |
Shrabani Singha
Aspiring Data Analyst | 3rd Year B.Tech (Electrical Engineering)
🎓 NIT Agartala | 🎖️ Siemens & Infosys Scholar
📧 LinkedIn | GitHub
This repository and its contents are intended for educational and portfolio purposes only.
All company names, datasets, and simulations are part of a virtual experience hosted by Forage. No commercial use is allowed.