Zora Analytics

Utilities

With iSolutions You Could Analyze:

Track water sales/ consumption for the last 5 years
Obtain top 10 consumers by rate, region, premise & customer group
Produce water conservation by period reports for strategic planning
Perform analysis on delinquency, shutoff, misreads, payment types etc
Monitor new installations and activations
Monitor maintenance of assets
Track missed preventative maintenance(PM)
Track productivity measures like employee performance, average response time, job completion time, work order status etc
Track Inventory & stock updates
Track progress/cost/funding of Capital Improvement projects
Track employee movement and monitor overtime.

iSolution for Utilities is an out of the box data warehouse tool kit that is specifically designed to cater the analytical reporting requirements of Utility organizations.

iSolutions for Utilities provides a pre-built enterprise data warehouse architecture integrating data from various business areas such as: Consumption & Billing, Asset Maintenance, Water Conservation, Inventory, New Installations, Finance, Capital Improvement Projects & Personnel, enabling utilities to perform separate or combined analytic reporting for those specific utility subject areas.

Additionally, the user interface works with the pre-built reporting layer to show configurable KPIs through various graphical metaphors or tabular reports.

The isolution comes with a set of dashboards and variety of pre-built reports.

iSolution for Utilities Modules

ASSET MAINTENANCE

This module keeps track of the asset maintenance performed by the operations division. PM's performed/ missed, schedules, worked performed, work order status, response time, job completion time, footage cleaned, footage televised etc is captured for water and sewer facilities.

CONSUMPTION & BILLING

This module captures the consumption & billing data for every tenant for each bill period. This helps the end users to perform analysis like yearly trends based on Premise, rate, facility, tenant, location etc. The revenues flowing from water sales & new installation is also captured.

FINANCE

Revenues & expenditures of the department sliced and diced across various dimension like, time, accounts, funds, projects etc.

CONSERVATION

This module captures the consumption data for every tenant for each bill period. This helps the water conservation group to perform analysis like yearly trends based on Premise, rate, facility, tenant, location etc. Top 10 consumers, yearly trends, variances etc are the key performance metrics in this module

PERSONNEL

The following information is captured in this module:
Actual employees on payroll compared to budgeted employees.
Breakup of salary by various accounts such as OCA, overtime, vacation, sick leave etc.

iSolution for Utilities Dashboard Samples