Retail Sales and Product Performance Dashboard

Overview: This highly interactive Retail Sales and Product Performance Dashboard provides a comprehensive view of key sales metrics across various product lines and cities. Built in Power BI, the dashboard enables users to analyze monthly revenue trends, units sold by category and location, average unit prices, and payment method preferences. A unique feature allows users to toggle between different currencies (UAH and USD), with real-time currency conversion based on the latest exchange rates, making it versatile for both local and international stakeholders.

Objectives:

• To track and visualize total revenue, units sold, and average unit price across different months, product categories, and cities.
• To enable users to dynamically switch between currencies, enhancing usability for diverse audiences.
• To provide insights into consumer purchasing behaviors, including preferred payment methods, across various product lines.

Features:

• Total Revenue by Month: A line chart visualizing the monthly revenue, helping to identify seasonal trends or monthly fluctuations in sales performance.
• Units Sold by Product Category and City: A clustered bar chart displaying units sold across different categories (e.g., electronic accessories, fashion accessories, etc.) and cities (Mandalay, Naypyitaw, Yangon), allowing for easy comparison of city-level sales performance.
• Units Sold by Month: A bar chart showing the total units sold each month, providing insight into product demand over time.
• Average Unit Price by Product Line: A bar chart comparing the average unit price across different product categories, helping to assess pricing strategy and positioning.
• Payment Type Share: A pie chart illustrating the breakdown of payment methods (credit card, e-wallet, cash), which can offer insights into customer preferences and inform payment strategy.

Target Audience: The dashboard is designed for retail managers, business analysts, and financial teams who need to monitor sales performance, make data-driven decisions on pricing and inventory, and understand customer purchasing behavior.

Technologies Used:

• Power BI for interactive data visualization and dashboard creation
• Real-time currency conversion feature, ensuring accuracy in financial analysis for multiple currencies

Impact: By leveraging this dashboard, stakeholders can gain insights into revenue trends, regional and category-based performance, and customer payment preferences. The currency conversion feature enhances accessibility and usability for both local and international users, facilitating informed business decisions in a global retail environment.