Student-Survey-Analytics-Retail-Spending-Dashboard

🎓 Student Survey Analytics – Retail Spending Dashboard

🔗 Live Dashboard Link

A Power BI dashboard that analyses student retail spending habits across different store locations and settings. The project uses survey data to uncover spending patterns on categories like video games, books, gadgets, toys, and more.

---

📂 Dataset

• Source: Student Survey dataset
• Fields include: Store Setting, Store Location, Age, Purchase Amounts (by category), User Mapping

---

🔍 Key Features

• Tabular View with conditional formatting based on Total Amount of Purchase (TAP):
  • Red: < 35,000
  • Yellow: 35,000–60,000
  • Blue: ≥ 60,000
• Matrix View: Outdoor sports spending by Age and Store Setting
• Funnel Chart: TAP by Store Setting with percentage of first
• Pie Chart: TAP by Store Location (Suburban only)
• Scatter & Sand Dance Plots: Age-wise comparison of spending on sports and video games
• Q&A Visuals: Avg. age & Donut chart for purchases by store location

• Row-Level Security: Role-based access (e.g., user sees only data for specific regions)

📌 Built to explore student shopping behaviour and demonstrate Power BI features like RLS, Q&A, and scheduled refresh.