📊 NYC 311 Noise Complaints Dashboard (New York & Brooklyn)

Power BI dashboard

---

📌 Project Overview

This project aims to provide meaningful insights into noise-related complaints submitted by New Yorkers. Using Excel’s advanced features, the dashboard enables users to filter, explore, and interpret complaint data by category, location, time, and channel of reporting.

---

✅ Key Features

• 📍 Borough Selection (Brooklyn, NYC)
• 🔊 Complaint Type Filters (Commercial, Vehicle, Park, etc.)
• 🕒 Time-of-Day Analysis (Morning, Evening, Night)
• 📅 Monthly Complaint Trends
• ☎️ Channel-wise Complaint Reporting (Phone, Online, Mobile)
• 📈 Dynamic Charts and KPIs:
  • Total complaints
  • Status: Closed / In Progress
  • Average resolution time (days)
  • Monthly line chart & time-of-day bar charts

---

🛠 Tools Used

• Microsoft Excel

  • Pivot Tables

  • Slicers

  • Donut & Line Charts

  • Conditional Formatting

  • Dashboard Layout Design

  • • Power BI

  • DAX

  • Power Query

  • NYC Open Data (311 Noise Complaints)

  • Conditional Formatting

---