last-generation-data-warehouse

LAST GENERATION DATA WAREHOUSE

CHALLENGE

One of the services with direct administration from the Central Government needed to implement an evolution of it’s current application form to respond to the needs of an internal platform, both in terms of area of business processes as well as an update in terms of software and computer hardware.

SOLUTION

Syone designed a plan that combined the creation of a data warehouse and a SOA platform. The data warehouse intended to store historical and current information from the platform, as well as provide indicators that allow the client a quick and direct dynamic reporting.

RESULTS

The project resulted on the installation of a technological infrastructure to support the data warehouse platform and on the implementation of a data model defined during the analysis phase. Syone algo worked on the implementation of ETL mechanisms for loading the data warehouse data model.