The City of Philadelphia receives hundreds of thousands of 311 service requests each year for issues such as sanitation, street maintenance, graffiti removal, and abandoned vehicles. Using a dataset containing more than 500,000 service requests, I developed an interactive Power BI dashboard to analyze service demand, departmental workload, request resolution performance, and operational trends.

This project demonstrates my ability to transform a large public dataset into an interactive business intelligence solution that supports operational reporting and data-driven decision making.

Objective

Create an interactive dashboard that enables users to:

• Monitor overall service request volume.
• Identify the most common request categories.
• Compare departmental workload.
• Track request resolution performance.
• Explore operational trends through interactive filtering.

Data Preparation

To prepare the dataset for analysis, I:

• Cleaned and transformed the data in Power BI.
• Removed unnecessary fields and standardized data where appropriate.
• Created relationships to support accurate reporting.
• Built DAX measures to calculate key performance indicators (KPIs) and operational metrics.

Dashboard Features

The dashboard includes: