Design And Implement Of ETL Infrastructure And Data Market In Analysis Report System

Nowadays, ERP system as information platform becomes the corn business process transaction system in modern enterprises. Over this platform all kinds of applications are built. All these applications and platform have the same feature that they are based on the Transactions. These transaction data is enough for operators, but will be a big trouble for managers to analysis in a high level because they need the integrated and historical data. This will restrict their decision in the right way.This system is an analysis report system used in a large multinational company. It response to collect the data from all kinds of systems accurately and rapidly and show a presentation platform for users to do some analysis work such as drill down, slice, dice.These works cannot be finished in one simple project. We must build a platform including many systems to finish this work. Here is the main content of this platform:I. Build the platform of ETL(Extract-Transform-Load) to feed the data to the Data WarehouseII. Build the Data Mart which is well designed and can fulfill the requirement from customersIII. We use the analysis reports which can drill down, slice, dice based on the ETL and Data Mart.This project is not only finish the goal of building analysis reports but also build a good reliable platform of ETL and build the Data Warehouse in the enterprise, while can be a very strong base of developing the new analysis reports even build the BI system in the future. It can also be the reference to the other similar system.