- This project presents an interactive Google Looker Studio dashboard built on global e-commerce data to uncover sales performance, customer behavior, and market trends. With KPIs, interactive filters, and visual storytelling, it highlights insights on revenue growth, customer loyalty, product demand, and regional opportunities.
- This project delivers an interactive Looker Studio dashboard to analyze global e-commerce performance across revenue, orders, customers, and product categories. It provides actionable insights to optimize marketing strategies, improve customer retention, and guide product expansion decisions.
- Key KPIs such as total revenue, average order value, total orders, and total customers provide a quick overview, while filters allow deeper exploration by country, product category, and time period.
- Analyze overall customer base and identify top contributors to revenue.
- Track product category performance and uncover best-selling items.
- Compare global sales distribution and discover high-value markets.
- Provide clear KPIs for revenue, orders, and average order value.
- Build an interactive reporting tool with filters for country, product, and year.
- Key Metrics Overview – Total Revenue ($8.27M), Total Orders (18.5K), Total Customers (4.3K), Average Order Value ($446.6), Total Quantity (4.9M).
- Monthly Sales Trends – Revenue and quantity trends across 2010–2011 highlighting seasonal peaks.
- Product Performance – Top 10 products and categories driving revenue contribution.
- Customer Insights – Segmentation of high-value vs frequent customers; top 10 customers by revenue.
- Regional Analysis – Top countries by average order value and product category distribution.
- Refunds & Cancellations – Monitoring financial impact of refunds across regions.
- Interactive Filters – By country, product category, customer ID, description, and year.
- DashBoard Previews |PAGE 1|PAGE 2|
- Total Revenue: $8,278,519
- Total Orders: 18,536
- Total Customers: 4,372
- Average Order Value: $446.62
- Total Quantity Sold: 4.9M
- Average Basket Size: 264 products
- Revenue Growth – Which months show peak performance and how can campaigns align with seasonality?
- Customer Dependence – How much revenue comes from the top 10 customers, and how to retain them?
- Market Expansion – Which countries deliver higher average order values, and where should we expand?
- Product Strategy – Which categories and products dominate sales, and where should investment focus?
- Refund Control – Which regions have higher refunds, and what operational fixes are required?
- Revenue Contribution by Product Category – Tree map & bar chart views.
- Monthly Sales Trends – Revenue vs quantity growth.
- Top 10 Products by Revenue – Product-wise sales leaders.
- Customer Segmentation – Frequency vs revenue scatter analysis.
- Top Countries by Avg Order Value – Global comparison of spending patterns.
- Refunds & Cancellations Table – Region-wise refund tracking.
- Interactive Filters – For flexible deep-dive analysis.
- Previw & Download the full Dashboard |GET DOCUMENT|
Dataset Used: Global E-Commerce Sales Data (2010–2011)
|DOWNLOAD|
| Column Name | Description |
|---|---|
| InvoiceNo | Unique Invoice Number |
| Country | Customer’s Country |
| CustomerID | Unique Customer Identifier |
| Product Category | Category grouping (Bags, Toys, Stationery) |
| Description | Product description |
| Quantity | Number of units sold |
| Revenue | Total sales amount |
| Refund Revenue | Refund/cancellation amount |
| Year | Transaction Year (2010/2011) |
- Google Looker Studio → Dashboard design & visualization
- Google Sheets / CSV → Data source integration
- Data Cleaning → Removing duplicates, categorizing products
- Calculated Fields → Revenue KPIs, Avg Order Value, Basket Size
- Storytelling → Turning data into business insights
- The business generated $8.27M revenue across 18.5K orders with clear seasonal peaks, showing opportunities for campaign alignment.
- A small group of top customers contributed over $1.3M revenue, proving the need for customer loyalty programs.
- The UK leads in total sales, while Netherlands & Australia show higher avg order values ($1K–$3K), highlighting premium markets.
- Product sales are dominated by “Other” category (74%), followed by Bags & Accessories (10%) and Home & Kitchen.
- Refunds are concentrated in the UK & Germany, signaling operational issues that need attention.
- Previw & Download the full StoryFile |GET DOCUMENT|
- Revenue is seasonal, peaking above $3.5M in high-demand months.
- Top 10 customers drive major revenue, retention is critical.
- Premium markets exist in countries with higher avg order values.
- Decorative, lifestyle, and gifting products dominate sales.
- Refund reduction can directly improve profitability.
- This project demonstrates how Google Looker Studio can turn raw e-commerce data into actionable insights.
By analyzing revenue, customers, products, and markets, the dashboard connects operational data with business strategy. - It enables businesses to:
- Maximize seasonal revenue through planned campaigns.
- Build loyalty programs to retain high-value customers.
- Expand strategically into premium international markets.
- Optimize product portfolios to match customer demand.
- Reduce revenue leakage through refund control.
- The storytelling approach transforms millions of sales records into a clear roadmap for e-commerce growth and decision-making.