EIM Solutions

A robust data warehouse and Business Intelligence implemented at Kiambu

EIM Solutions created a robust data warehouse using SAP Data Services , business analytics and dashboards using SAP Business Objects.

Kiambu County is a former administrative district in the old Central Province of Kenya, comprising 12 constituencies and 60 county assembly wards.

Business Challenge

Kiambu county’s reporting systems had various limitations which restricted the modern reporting needs.

Challenges

  • Central reporting environment was not available to report across all sub-counties.
  • Users, executives, chief officers relied on the physical system or PC to access reports.
  • Access to the reports were restricted based on the county and not available outside the county premises.
  • Huge manual work was involved in consolidating the reports from all sub-counties to provide a summarized financial report.
  • Automated reporting functionalities were not available; such as automated email distribution.

Implementation

Highlights

  • Business Objects
  • Business Objects – Data
  • Services
  • SAP Sybase IQ
  • Issue resolutions
  • Enhancements of BI reports
  • Adaptation of change in the Kenya financial acts
  • Proactive monitoring of the system, Source data extraction
  • Interaction with supplier for 3rd party application interfaces issues
  • User training

Requirement Benefit

Kiambu county had a robust and flexible reporting system to track all the counties revenue flow.

The installation of an automated revenue receipting system provided convenient payment channels for citizens and increased efficiency and effectiveness of the revenue collection processes