The hidden value of data not only determines the fate of the enterprise itself, but also carries the future direction of the whole industry. Under the background of big data era, whether the development of the company or government management, building a data warehouse to themselves is particularly important. Based on the Zhongguancun data fusion center platform, the paper expounds the key technology points of building the Pentaho management system which mainly includes the design of the data warehouse, ETL design of data collection process, OLAP design of data analysis process and report design in the data display process.