The IT department plays an ever growing and important role in this digital age and ensures the PMC is relevant and ready to serve citizens, as they look to connect with their local government in newer and faster ways afforded by modern information and communications technology.

Select Projects

Enterprise Dashboard

The dashboard solution to be deployed at PMC shall cater to two broad needs analytical and operational decision making.

Analytical dashboards -

Analytical dashboards present insights on the data, in order to facilitate near real time decision making; with such a dashboard, PMC users shall be able to - 

  1. Monitor and set deadlines and resolve citizens’ issues/grievances effectively

  2. Focus on gaining insights from a volume of data collected over time

  3. Use sophisticated models, what-if analysis and pivots to identify patterns and opportunities, and to help align strategic goals with performance management initiatives.

Operational dashboards - 

Operational dashboards are driven by performance in an area/task with respect to its defined KPI, to show if the management is on/off target.


The figure below shows the dashboard framework

Types of Analysis -

Following is the indicative list of analysis capabilities expected out of the dashboard -

  • Financial reports and consolidations
  • Plans and budgets
  • Analysis and models (trends, scenarios and issues)
  • Predictions (Predictive analysis, simulations)
  • Risk analysis (compliance, debt, credits)
  • 360 degree views (Citizens, employees, vendors, agencies)
  • Metrics and indicators (top 10 performance)
  • Sentiment Analysis
  • Quantitative and non-quantitative data analysis

Indicative list of Dashboard Indicators

  • Municipal Financial Indicators (Department-wise/ Ward-wise/ Project-wise)
    • Total Revenue Collection - Collection on date and cumulative collection
    • Department wise revenue collection: Total and segregated
    • Expenditure: list of major heads and amounts
    • Major heads under capital expenditure
    • Total budget and, 
      • Budget- Estimated
      • Budget- Tendered
      • Budget- Work in Progress (Work order and date of work order)
    • Per Capita Own revenue
    • Non-tax revenue as proportion of Own revenue
    • Per Capita Property tax
    • Coverage for Property tax net
    • Property Tax collection performance (Red/Green/Yellow customizable alerts)
    • Water Charges Collection performance (Red/Green/Yellow customizable alerts)
    • Operating Ratio (Expenditure/ Receipts)
    • Salary as % of Revenue
    • Staff per 1000 population
    • Debt Service Ratio (Debt/ Revenue)
  • Municipal Service Delivery Indicators – Water
    • Coverage of water supply connections (As a % with respect to total households in the city)
    • Per capita supply of water
    • Extent of metering of water connections (As a % with respect to households under water supply in the city)
    • Extent of non-revenue water (NRW)
    • Continuity of Water Supply (total continuous hours of supply/day)
    • Efficiency in customer complaints redressal (% of complaints resolved against total complaints received in a week or month)
    • Quality of water supplied (ppm particulate matter)
    • Efficiency in collection of water supply related charges (Invoiced vs. collected amount in a month/quarter/year)
  • Municipal Service Delivery Indicators – Sewerage and Sanitation
    • Coverage of Toilets (as a % of total households or per capita)
    • Coverage of Sewerage services (as a % of total households or per capita)
    • Collection efficiency of sewerage network
    • Adequacy of sewerage treatment capacity (Capacity of STPs in total vs. total sewerage generated in the city)
    • Quality of sewerage treatment (measure of quality of treated water)
    • Efficiency in customer complaints redressal (% of complaints resolved against total complaints received in a week or month)
    • Extent of recycling and reuse in Sewerage (Kms. of pipelines laid for recycled water/ quantity of recycled water generated)
  • Municipal Service Delivery Indicators – Solid waste management
    • Household-level coverage of SWM services (% of total households covered)
    • Efficiency of collection of municipal solid waste (Need to determine the measure)
    • Extent of segregation of municipal solid waste (Need to determine the measure)
    • Extent of municipal solid waste recovered (Need to determine the measure)
    • Extent of scientific disposal of municipal solid waste (Need to determine the measure)
    • Efficiency in redressal of customer complaints (% of complaints resolved against total complaints received in a week or month)
    • Extent of cost recovery in SWM services (Need to determine the measure)
  • Municipal Service Delivery Indicators – Storm Water Drainage
    • Coverage of storm water drainage network (Km. of drainage network laid in the city/Km. of drainage lines per square kilometer of the city area)
    • Incidences of water-logging/flooding reported in a month
  • Municipal Service Delivery Indicators – Road and Transportation
    • Road length per capita
    • Proportion of surfaced roads
    • O&M cost per kilometer of road (Rs. per km)
  • Municipal Service Delivery Indicators – Grievance
    • All Complaints (Aaple Sarkar + Grievance Portal)
    • Pending Complaints- Aaple Sarkar
    • Pending Complaints- Grievance Portal
    • Resolved Complaints- Aaple Sarkar
    • Resolved Complaints- Grievance Dashboard
    • Citizen Satisfaction Score
    • Total Citizen Feedback
    • Grievance Pending For > 60 Days (Aaple Sarkar + Grievance Dashboard)
    • Complaint Pending > 30 Days &< 60 Days
    • Complaint Pending > 15 Days &< 30 Days
    • Complaints pending in time
    • Complaints pending beyond time
  • Municipal Service Delivery Indicators – Establishment Dept.
    • No. of properties rented/leased
    • No. of properties allotted
    • Rent collected per month or per year
    • Efficiency in collection of rent (billed vs. collected amount)
    • Rent collection achieved as per budget vs. actual rent collected