Design And Implementation Of BI Data Warehouse Modeling Platform Based On SCD

With the rapid development of computer technology and Internet technology,enterprise data accumulated by explosive growth,but data resources implied in the knowledge they did not get fully excavated and utilized.Enterprises urgently need new technologies and methods to extract valuable information and knowledge from ocean data.Data warehousing and business intelligence based on them are one of the technologies.Data warehouse is a large number of data for data organization and management of the technology,specifically for supporting the analysis of data query and multi-dimensional analysis.At the same time,in the real world,the attributes of the dimension are not static,and it will change slowly with the loss of time.Such as departmental dimensions,may change the company's department over time.In order to solve this problem in the current business intelligence project implementation,project implementers usually need to create different data models for different time versions of the data for data analysis,but still can not data warehouse in the historical data for unified access and effective Of the trend analysis,assist the relevant personnel to make decision support.In order to meet the needs of users to slowly change the data information,while reducing the difficulty of project implementation,reduce the implementation of the workload and ease the project to the internal bPro_Studio business intelligence modeling platform for the actual project as the background,through the relevant industry data warehouse users and management The research and implementation of the BI data warehouse modeling platform based on the slow change dimension are completed in combination with the company's accumulation in the data warehouse industry.Through support slowly changing dimensions of the data warehouse,you can build enterprise data model,which for the production and sales,cost control and revenue distribution enterprises of great significance,a great saving costs,improve economic efficiency,at the same time with the data warehouse can analyze the relationship between corporate human resources and infrastructure between the data can be used to return analysis to ensure maximum utilization of human resources,also can assess the performance of human resources,so that the enterprise management more scientific and reasonable.The enterprise data warehouse data organized in a specific manner,thereby creating new business knowledge,and bring new perspectives to the operation of enterprises.