Project Overview

This analysis provides a structured operational view of maintenance activities across residential blocks, focusing on complaint volume, service response, and infrastructure reliability.

The dashboard highlights the relationship between maintenance demand and service performance, revealing how recurring issues and workload distribution impact operational efficiency.

With a total of 87 complaints recorded, the system tracks resolution progress across Resolved (45), In-Progress (20), and Pending (22) cases, providing a real-time snapshot of facility performance.

Process, Steps, and Methodology

The system was developed using a structured operational analytics workflow:

Data Structuring & Integration (Google Sheets → Power BI)
Raw complaint records were cleaned, standardized, and structured in Google Sheets, then connected to Power BI through a live data pipeline with scheduled refresh for continuous updates.

Operational KPI Development
Key metrics were defined to monitor service performance, including:

• Total complaints

• Resolution status (Resolved, Pending, In-Progress)

• Complaint distribution by category and block

Visualization & Dashboard Design
Interactive visuals were built to:

• Track complaint trends by category

• Monitor service resolution progress

• Identify high-demand residential blocks

• Provide real-time operational visibility

• 
  

Business Questions

• Which maintenance categories generate the highest complaint volume?

• Which residential blocks experience the highest service demand?

• What proportion of complaints are resolved versus pending?

• Where are service delays or operational bottlenecks occurring?

• Which issues indicate recurring infrastructure weaknesses?

Key Insights and Findings

1. Maintenance Demand Concentration

Plumbing issues represent the highest volume of complaints (30 cases), followed by carpentry (18) and electrical (16), indicating recurring infrastructure pressure points within core building systems.

2. Uneven Service Demand Across Blocks

Complaint distribution shows that certain blocks (e.g., Four and Six with 16 cases each) generate significantly higher service demand compared to others, suggesting localized infrastructure strain or usage intensity.

3. Service Performance & Workload Pressure

Out of 87 total complaints:

• 45 have been resolved

• 20 are in progress

• 22 remain pending

This indicates a moderate resolution rate but sustained operational backlog, reflecting ongoing maintenance workload and possible resource constraints.

4. Operational Visibility & Process Improvement

The transition from unstructured complaint records to a centralized dashboard significantly improves:

• Monitoring of service progress

• Identification of recurring issues

• Decision-making speed for maintenance prioritization

5. Category-Based Infrastructure Risk

Lower-frequency categories such as ventilation and water supply still indicate critical but less frequent failures, which may require preventive monitoring despite lower volume.

Recommendations

• Preventive Maintenance Strategy
  High-frequency categories (especially plumbing) require scheduled inspections and proactive maintenance to reduce recurring complaints.

• Block-Level Intervention
  Residential blocks with higher complaint volumes should be prioritized for infrastructure assessment and targeted maintenance actions.

• Service Efficiency Tracking
  Introduce resolution time tracking (SLA-based KPIs) to reduce pending backlog and improve service delivery speed.

• Resource Allocation Optimization
  Align maintenance teams and resources with demand-heavy categories and high-pressure blocks.

Expected Impact

• Improved maintenance response efficiency

• Reduced recurrence of infrastructure-related complaints

• Better allocation of maintenance resources

• Enhanced operational visibility and reporting

• Increased resident satisfaction through faster issue resolution