Data Submission and Analysis Solution

Data Submission and Analysis Solution

Project Info

The customer is a power sector regulator in Sri Lanka who engages in regulating electricity, petroleum and water. The client, being a regulator, receives annual, quarterly and monthly data from the market players in electricity industry and from the petroleum industry. The data relates to many activities in the market.

The data received from market players are in excel formats. They need to be consolidated to generate the annual reports and to analyze market player activities. Further, as the data is large, the market players prefer to send the data in excel format rather than keying them into a system.

Cyber Concepts’ solution was to create a portal with access to the market players in the different industries to submit the data. The submitted data are as per a standard format which needs to be uploaded to the system in form of csv files. The data so submitted are validated against the formats and their accuracy and the system directs them to be accepted or rejected by the respective administrator in the regulator’s office

Incidentally, the system automatically monitors the submissions and sends reminders to the market player on incomplete submissions.

The data is used to generate the graphs and the analysis for reporting purposes.

  • Time spent on consolidating data is reduced
  • The regulator receives data on time
  • Accuracy of the data is ensured
  • Generating management information is faster

  • Technologies : mysql, angular, jquery, php