SOURABH BANSAL

Online Retail Sales Trend

ABOUT
Find CODE
on GitHub
(If Applicable)
The Online Sales Trend Dashboard project is designed to provide a comprehensive view of sales data for the year 2011, utilizing Power BI to offer dynamic visualizations and insightful analysis. This dashboard was developed as part of the Tata Group Data Visualization Job Simulation on Forage. The primary goal of this project is to help businesses understand their sales performance over time, identify top-performing products and customers, and uncover trends across different countries and regions.
Key Features:
Revenue Trend Analysis: A line chart visualizing the monthly revenue trend for the year 2011, helping users to identify peak sales periods and seasonal patterns.
Top Revenue Generating Countries: A bar chart displaying the top 10 countries by revenue, allowing businesses to pinpoint key markets contributing significantly to overall sales.
Top Revenue Generating Customers: A dual-axis bar chart that highlights the top 10 customers by revenue and the quantity of products purchased, providing insights into customer value and purchasing behavior.
Geographical Sales Distribution: A map visualization that illustrates the global sales distribution, enabling users to analyze sales performance across different geographical regions.
Interactive Filters: Date range sliders and country selectors to filter the data dynamically, providing a customizable user experience for detailed analysis.
Requirements:
Power BI Desktop: The primary tool used for creating the visualizations and dashboard.
Dataset: A comprehensive sales dataset containing fields such as Country, CustomerID, InvoiceDate, Revenue, Quantity, and UnitPrice, which is used to generate insights and trends in the dashboard.
The Online Sales Trend Dashboard is an effective tool for visualizing and analyzing sales data, providing valuable insights into revenue trends, customer behavior, and market performance. Through interactive features and comprehensive visualizations, this dashboard empowers businesses to make data-driven decisions, optimize sales strategies, and identify growth opportunities. By leveraging Power BI, users can easily explore and interpret the sales data to enhance their understanding of market dynamics and improve overall business performance.