Information Technology Department

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