BUSINESS INTELLIGENCE SELF SERVICE – HYBRID DATA WAREHOUSE
BUSINESS OBJECTIVES
The Supply chain analytics team requires key information from the engineering systems to complete their KPI’s. Supply chain will also be looking to bring in key data for the S&OP tool set under the SIOP initiative. The data management team will be collaborating with them to ensure that they have access to the data required as part of the Data Architecture global initiatives.
SOLUTION
Infometry built the solution to create a new operational data store (ODS) to provide the Supply Chain Analytics team with the required information from the multiple systems like Engineering, solution development, operational planning, ordering, quoting for this global initiative. Informatica cloud services helped to synchronize data for real time reporting and represent the point in time based on a daily record.
SUCCESS CRITERIA & BUSINESS VALUE
This key dataset is to improve Supply Chain efficiency and to ensure that we can provide accurate capacity plans for the plants while ensuring that KPI’s can be collected on the purchasing process. Automating this process will save 1000 hours annual in additional reporting work and that value will increase as S&OP is rolled out globally.