DataposIT was invited by Blowplast Limited to design and create a data warehouse based on MsSQL RDBMS for its branches in Kenya, Uganda and Madagascar. We developed a custom Extraction, Transform and Load (ETL) tool to collate the data from heterogeneous data sources such as SAP Business One (Uganda), Ebiz (Kenya) and excel templates and load into the data warehouse.
The MicroStrategy BI tool was then deployed to provide intelligence of the various data sets and visualization using reports, dashboards, and dossiers. Before this, Blowplast took a lot of time to generate the datasets and compile the reports. Through MicroStrategy reports are automatically generated and can be visualized in almost real-time.
The project also involved training of the users and user Support.