Empowering Government Unit
With Analytics

A business intelligence / data mining & analytics COE was needed to generate customized statistical reports for various departments of the government for policy-making and regulatory purposes. The main priority of this project was to demonstrate the potential of data mining, visualization, and interactive reporting.

Business Problem

A ministry under the central government of India adopted an e-governance project. The project automated the administration of the Companies Act. Companies were mandated to file all documents relating to incorporation, compliance, approvals, and annual statutory returns electronically in this system. The process of filings had resulted in the mass-accumulation of information, and the system turned into an exhaustive electronic repository of the Indian corporate sector.


However, the utilization of the electronic information available in the repository was minimal. Only a few government organizations could access customized corporate sector data in response to their specific ad-hoc requests from time to time. Hence, this wealth of information was woefully underutilized and unavailable across agencies.

The main reason behind this was the complex structure of the company filings.
Further, adding to the delay in the serving of data requests, the information provided by the system would often be inaccurate and inconsistent. Analytics supplied from the existing system was not helpful for economic analysis or policy-making due to companies providing different numbers in different forms when they would do the yearly filing.

OTSI Approach

OTSI found that the Government unit was facing many issues common to technology, similar to many public sector organizations. Although the existing system would provide the data related to the filing of various companies, when the government units required any analysis of the data, the request for data would take from days to weeks.
OTSI’s Technology Consulting Team evaluated the requirements of the Government unit and adopted a broad consultative process across stakeholders. Conditions related to data sharing formats were collected from all stakeholders and agencies. Considering the growth in the data volume, file structures, and the future vision of integrating other government agencies’ data, the OTSI team suggested implementing SAP Business Analytics on a private cloud.
Drawing on its experience in SAP Analytics Solution implementations, OTSI enabled the SAP data warehousing system using various SAP modules and SAP intelligence solutions. The implementation enabled the departments to analyze existing data (in XBRL/PDF files) and enabled on-the-fly reporting for the regulatory teams.

OTSI Value

OTSI Approach

OTSI found that the Government unit was facing many issues common to technology, similar to many public sector organizations. Although the existing system would provide the data related to the filing of various companies, when the government units required any analysis of the data, the request for data would take from days to weeks.
OTSI’s Technology Consulting Team evaluated the requirements of the Government unit and adopted a broad consultative process across stakeholders. Conditions related to data sharing formats were collected from all stakeholders and agencies. Considering the growth in the data volume, file structures, and the future vision of integrating other government agencies’ data, the OTSI team suggested implementing SAP Business Analytics on a private cloud.
Drawing on its experience in SAP Analytics Solution implementations, OTSI enabled the SAP data warehousing system using various SAP modules and SAP intelligence solutions. The implementation enabled the departments to analyze existing data (in XBRL/PDF files) and enabled on-the-fly reporting for the regulatory teams.

OTSI Solution

Join OTSI On Your
Technology Journey