Madhav_store_Power_BI_Dashboard

Power BI Dashboard Project

Discover Madhav Store’s E-commerce sales analysis through our interactive Power BI dashboard. Cleaned and modeled from Orders.csv and Details.csv, this project offers key insights on top-performing states, popular product categories, profitable months, and valuable customers. Use these findings to enhance sales strategies, target discounts effectively, and optimize promotions for increased profitability. Explore the potential of data-driven decision-making in the e-commerce sector.

Project Key Points -

• Data Collection
• Data cleaning
• Data modeling
• Data visualization
• Databoard design
• Sharing insights

Problem Statement/objective -

We want to analyze Madhav Stores sales data across india and create interactive dashboard using Power BI.

Dataset -

• Orders.csv
• Details.csv

What i did?

• Transformed Data (Cleaning, Formatting, Performing aggregate function, grouping etc.)

• Used DAX queries for calculating AOV(Average Order Value)

• Implemented important KPI’s to visually represent and monitor our data like (sum of amount, sum of quantity, sum of profit, sum of AOV)

• Used Various charts(Donut Chart, Stacked Bar chart, Stacked Column chart, card, Slicer etc.) according to categories

Insights & recommendation -

• The top four states promoting maximum sales and profit are Maharashtra, Madhya Pradesh, Gujarat, and Delhi.

• Clothing category is the most popular for shopping, followed by Electronics and Furniture. Offering exciting discounts, coupons, and offers can attract customers and improve sales in these categories.

• The months of January, March, August, October, and November generate the highest profit. Introducing seasonal collections and providing relevant offers, coupons, and discounts during these months can boost sales.

• Harivansh, Madhav, Madan Mohan, Shiva, and Vishakha are frequent customers who contribute significantly to sales and profit. Rewarding them with gifts, discount coupons, and special offers can attract other customers to the store.

• Cash on Delivery (COD) is the most preferred mode of payment. Offering COD as a payment option for every product can enhance customer convenience.

• Profitable sub-categories within Electronics, Furniture, and Clothing include printers, bookcases, and sarees. The best results were achieved in Quarter 1 and Quarter 4.