No Collections Here
Sort your projects into collections. Click on "Manage Collections" to get started
Revenue Strategy & Customer Behavior Analysis
Interactive dashboard built in Tableau for analyzing global revenue performance.
Case Study 1:
Global E-Commerce Revenue Strategy Dashboard
Subtitle: Analyzing customer behavior, product performance, and geographic revenue patterns to identify growth opportunities.
Goals
E-commerce businesses generate large volumes of transactional data, but identifying the key drivers of revenue growth requires structured analysis.
The goal of this project was to analyze global retail transaction data to understand:
• Which product categories drive the most revenue?
• How revenue is distributed across customer segments
• Whether revenue is concentrated among a small group of customers
• Which geographic markets generate the highest sales?
​
The objective was to design an interactive dashboard that allows stakeholders to quickly identify revenue drivers and strategic opportunities.
The Data
Dataset: Global Online Retail Transaction Data
The dataset used in this project is a global retail transaction dataset containing over 500,000 e-commerce transactions from an international online retailer.
Each row represents a single product purchase within a customer order.
​
The dataset contains transactional records from an international e-commerce retailer, including:
-
Invoice Number – unique transaction identifier
-
Customer ID – unique customer identifier
-
Product Description – purchased product name
-
Stock Code – product SKU
-
Quantity – number of units purchased
-
Unit Price – price per unit
-
Invoice Date – timestamp of purchase
-
Country – location of customer
​
The data was cleaned and transformed to create derived metrics such as:
-
Revenue = Quantity × Unit Price
-
Customer Revenue = SUM of revenue per customer
-
Customer Segment = grouped customers into high, medium, and low value based on revenue rank
-
Category Mapping = product descriptions grouped into broader product categories
Tools Used:
Tableau
Excel
Data Cleaning & Transformation
Data Visualization
Business Analytics​​​
Methodology
The analysis focused on three key areas of business performance:
Revenue Performance
• Monthly revenue trends to identify seasonality
Product Performance
• Category-level revenue contribution
• Product demand intensity by country
Customer Behavior
• Customer revenue segmentation
• Pareto analysis to evaluate revenue concentration
These analyses were combined into an interactive dashboard designed for executive decision-making.
Key Insights
Revenue peaks during the holiday season indicating strong seasonal demand patterns.
The majority of revenue comes from low-value customers indicating a large base of smaller transactions.
Storage & Bags and Home Decor generate the largest share of revenue suggesting these categories are key product drivers.
The top 10 customers generate ~18% of total revenue showing moderate customer concentration.
Revenue is heavily concentrated in the United Kingdom highlighting the company's strongest geographic market.
Medium-value customers produce revenue comparable to high-value customers suggesting strong mid-tier purchasing behavior.
Recommendations:
Based on the analysis, several strategic opportunities emerge:
Expand high-performing product categories
Storage & Bags and Home Decor represent strong revenue drivers and could benefit from targeted promotions or expanded inventory.
​
Leverage seasonal demand
Revenue peaks during holiday periods, suggesting marketing campaigns should focus heavily on seasonal promotions.
​
Develop mid-tier customer retention strategies
Medium-value customers generate strong revenue and represent a growth opportunity through loyalty programs or targeted marketing.
​
Explore geographic expansion strategies
The concentration of revenue in the United Kingdom suggests opportunities to expand marketing or logistics capabilities in other European markets.