Reference Dashboard 1.0 Release Notes

Release Summary

Metabase, an open source business intelligence platform is being used for visualising the reference dashboard of iFIX.

Financial transactions done on mGramSeva such as demand generation, receipt collection, addition of bill and payment record come into Metabase through iFIX in the form of Fiscal events.

These Fiscal event line items are aggregated to form various data points that provide insights to department officials on Reference Dashboard(Metabase)

Release Description

Here, we’ll see how different options on Metabase works.

Open

Filters on the Dashboard

Date/Time Filter

Date & time filter on the dashboard is defaulted to the current financial year since most of the calculations and visualisations makes sense when viewed from a fiscal year perspective rather than an individual week/month view. However, users can change to respective dates and most charts will be filtered to the selected time range.

Department Hierarchy Filter

Currently there are 6 levels of hierarchy as per administration set up by the Department of Water supply and Sanitation Punjab. These are State, Zone, Circle, Division, Sub Division, Section, Gram Panchayat. 

All these filters are independent and work on the dashboard irrespective of whether other filters in the hierarchy are selected or not.

Visualisations/ Metrics on Dashboard

Surplus/Deficit

This number shows whether the selected Administrative entity is financially surplus or not. It also compares with previous year using the “trend” visualisation in Metabase. 

Pending Collections

For selected Administrative boundary what is the pending collections through water charges is represented in this card. If the pending amount is null. Then this card should display zero. 

Outstanding Electricity Bills

Since electricity bills create a major component of the expenditure for all projects, it is important to show how much electricity bills are pending at each administrative entity. Total amount of pending bills filtered by electricity under COA gives us pending electricity bills

GPWSCs at Risk

Risky GPWSCs are divided into 3 types

• High risk : Demand is less than Bill.

• Medium Risk : Demand is more than bill but pending collections is less than pending bills.

• Low Risk : Demand is more than bill and also pending collections is more than pending bills.

It is important to identify the risky GPWSCs and keep the offficials of DWSS informed, for them to take right actions before it’s too late.

Collections & Expenditure time series graphs

These charts represents the Demand, Net Collections, Bills and Net Payments across time(month-on-month) so that officials get a fair idea on how the amount that is getting collected is being spent. 

Any abnormalities in the graphs (Low collections or excessive spending) is something that needs to be paid attention to. 

Expenditure by Chart of Accounts

Expenditure is currently divided into 4 broad categories - Electricity Bills, Salaries, Operations and Maintenance and Miscellaneous. How these 4 categories accumulate to total expenditure for the selected entity over time is presented on the chart. Usually 75% of the expenditure should be of type electricity

Department hierarchy table

Here, we represent Total Demand, Receipt, Bills and Payments by all levels of hierarchy so that officials at any point, instead of just viewing the charts, trends from the visualisations can also see the tables and  compare best performing entities.