This project was completed as part of a data visualization simulation for Tata Insights and Quants (Tata iQ). The goal was to help the CEO and CMO of an online retail store uncover key revenue drivers, seasonal trends, and international growth opportunities using Power BI.
Tools used: Power BI | DAX | Power Query
Focus areas: Data cleaning | Visualization | business storytelling
Analyze seasonal revenue trends to support forecasting
Identify top-performing countries and customers
Map product demand to guide expansion strategy
Ensure data integrity through rigorous cleaning
Visuals & Insights
As we reviewed the monthly revenue for 2011, we observed modest fluctuations through Q1 and Q2, averaging around $0.58M. Momentum begins to build in Q3, with a clear surge from August through November, peaking at $1.16M. While December shows a sharp drop, it’s important to note that the data for December is incomplete, as this analysis was likely requested in early December to inform planning for the following year. Therefore, no definitive conclusion can be drawn for December’s performance.
We found that the Netherlands, Ireland (EIRE), and Germany are driving the bulk of international performance, together contributing over half of all non-UK revenue. France and Australia aren’t far behind, and when you add them in, these five countries account for more than 70% of foreign demand. What’s especially promising is that these markets show a healthy balance between units sold and revenue, which tells us they’re not just buying more — they’re buying higher-value products too.
When we looked at customer-level revenue, Customer 14646 from the Netherlands stood out as the top contributor, generating over $280K on their own. That’s followed by two high-value customers from the United Kingdom, which reinforces the UK’s overall dominance — but it also shows that international customers can absolutely lead in individual performance. We also spotted strong contributions from customers in Ireland (EIRE) and Australia, which adds weight to the case for expanding in those regions.
As we explored the geographic distribution of product quantity, a few clear leaders stood out: the Netherlands, Ireland, Germany, France, and Australia are driving a significant share of international demand outside the UK. Together, these five countries represent a concentrated pocket of activity that’s worth paying close attention to. We also saw moderate traction in markets like Sweden and Switzerland, which suggests that interest isn’t isolated — there’s regional momentum building across Europe and Oceania, pointing to broader growth potential.
Based on our analysis, we recommend the following actions to support international expansion and optimize performance:
Plan inventory and marketing efforts around the Q4 surge, starting in late Q3, to capture peak revenue.
Prioritize expansion in the Netherlands, Ireland, Germany, France, and Australia — together they account for over 70% of non-UK demand.
Engage high-value customers, especially those outside the UK, through loyalty programs and personalized offers.
Test localized strategies in countries like Switzerland and Sweden to boost engagement and validate potential.
This project helped us turn raw data into strategic insights that support real business decisions. By focusing on revenue trends, customer value, and geographic demand, we identified clear opportunities for international growth and seasonal planning. It sharpened our ability to communicate findings in a way that’s both actionable and aligned with leadership goals.