Nixon Store Sales Dashboard - Automate and Analyze

Introducing My New Nixon Store Sales Dashboard

I’m excited to share my first Power BI project, a comprehensive sales dashboard based on data from a super shop with around 6,000 rows.

This dashboard features:

✅ Sales, Quantity, Profit & Avg. Delivery: A summary of total sales, quantity sold, profit margins, and average delivery times.

✅ Segment-Wise Sales: A donut chart providing insights into sales performance across different customer segments.

✅ Monthly Sales & Profit Trends (2019-2020): Two line charts showing the monthly sales and profit trends for 2019 and 2020. Despite lower sales in October both years, profits remained strong.

✅ Sales by Ship Mode: This chart shows that standard delivery is the most preferred shipping method among customers.

✅ Sales by Sub-Category: A bar chart breakdown of product categories, with mobile phones and office supplies leading in orders.

✅ Sales by Payment Mode & Region: Detailed insights into customer preferences for payment methods and sales performance across various regions. The interactive filter allows users to select specific regions (e.g., East, South, West) to view data accordingly.

✅ Interactive Map Visualization: A map that visualizes sales distribution across different regions.

✅ Sales Forecasting: On page 2, I have included a basic forecast of sales for the next 15 days. Hovering over the forecast line reveals insights into upcoming sales.

Insight:

Working on this dashboard helped me sharpen my skills in Power Query for data cleansing and DAX for generating meaningful insights. By leveraging various visualizations like line charts, donut charts, and bar charts, I’ve been able to analyze customer behavior and identify key sales trends. This dashboard demonstrates how data analytics can guide decision-making and optimize store operations.

I welcome any feedback and look forward to connecting with others interested in data analytics in retail