🛒 Walmart Sales Analytics Dashboard (Power BI)

A comprehensive Power BI project that analyzes Walmart store sales across time, locations, departments, and external factors like holidays and weather. This dashboard provides actionable, business-ready insights to optimize operations and sales strategies.

---

📚 Table of Contents

• 📊 Dashboard Pages & Insights
• 📦 Dataset Information
• 🛠 Tools Used
• 📘 Dashboard PDF Preview
• 🚀 How to Use
• 🧠 Author
• ⭐️ Give a Star

---

📊 Dashboard Pages & Insights

📄 Page 1: Sales Overview

• Line Chart: Weekly Sales Trend with optional rolling average.
• Donut Chart: Sales Contribution by Year.
• Bar Chart: Top 10 Performing Stores.
• Stacked Column Chart: Sales by Store Type.

💡 Key Insights:
• Track sales fluctuations over time.
• Identify high-performing stores.
• Analyze performance by store type.

---

📄 Page 2: Store & Department Analysis

• Matrix Table: Weekly Sales by Store and Department.
• Bar Chart: Top 10 Departments by Total Sales.
• Map Visual: Store locations with sales volume indicators.

💡 Key Features:
• Conditional formatting to highlight performers.
• Drill-through navigation to department-level data.
• Geospatial sales performance insights.

---

📄 Page 3: Holiday & External Factors Impact

• Line Chart: Sales Trends with Holiday markers.
• Scatter Plot: Weekly Sales vs. Temperature.
• Line Chart: Weekly Sales vs. Fuel Price.
• Bar Chart: Holiday vs. Non-Holiday Week Sales.

💡 Business Impact:
• Understand sales behavior during holidays.
• Identify influence of weather and fuel prices.
• Enhance planning with seasonal trends.

---

📦 Dataset Information

Feature	Description
Rows	421,570
Columns	18
Format	CSV
Sample Columns	Store, Dept, Date, Weekly_Sales, CPI, Unemployment, Fuel_Price, etc.
Source	Walmart Sales Dataset (public)

---

🛠 Tools Used

Tool	Purpose
Power BI	Data modeling, DAX, dashboard visuals
Python (optional)	Data preprocessing (pandas)
Excel/CSV	Raw data handling and import

---

📘 Dashboard PDF Preview

📄 View the full interactive dashboard design here:
👉 Walmart Sales Analytics Dashboard (PDF)

---

🚀 How to Use

1. Clone the repository or download the .pbix files.
2. Open any .pbix file in Power BI Desktop.
3. Interact with visuals and slicers.
4. Modify or extend visuals as needed for your analysis.

---

🧠 Author

Priyanka Malavade
🎓 Aspiring Data Analyst | Turning data into decisions
📧 [email protected]
🔗 LinkedIn

---

⭐️ Give a Star

If you found this project helpful or inspiring, feel free to ⭐️ star this repo — it helps others find it too!