面向商务智能的人力资源数据仓库设计与实现

Design and implementation of HR-data warehouse based on BI

针对现代企业海量数据管理的目标和任务,从日益增长的用户需求出发划分人力资源数据仓库主题,搭建数据获取、数据管理和数据使用三个递进层次的商务智能平台架构。结合某大型国有物流企业SAP-BI实施项目案例,全面阐述了数据仓库建设中基于扩展星形结构信息立方体的数据抽取、清洗、转换和加载的完整过程,指出了系统建设中增量数据传输和性能优化手段等关键技术点。实践表明,该商务智能平台能够协助企业人力资源战略决策,有效提升管理水平。

To deal with the object and assignment for massive data management of modem enterprise, HR data warehouse themes have been partitioned according to increasing demand of customers. BI platform architecture is constructed from three progressive stages including data acquisition, data management and data usage. Combing with a SAP-BI case of one large state-owned logistics company, the procedure of extracting, washing, transferring and loading in data warehouse based on InfoCnhe is illustrated completely. The key technology including increment transmission and performance optimization etc in system implementation is pointed out. The practice results show that the BI platform can assist HR strategic decisions and enhance the management level effectively.