基于敏捷型BI的矿业集团生产信息分析模型  

BI-based analysis model of mining group production information

作　　者：修国林 黄雨笋[1] 李国清 胡乃联[1] 侯杰[1] 黄树巍[1] 

机构地区：[1]北京科技大学金属矿山高效开采与安全教育部重点实验室,北京100083 [2]山东黄金集团有限公司,山东济南250100

出　　处：《中国矿业》2017年第10期30-37,共8页China Mining Magazine

摘　　要：为了解决矿业集团底层生产运营数据难以交互分析、无法直接转换为战略层面上集成信息,易形成数据孤岛的问题,本文基于敏捷型BI实施方案,采用多种现代化信息技术快速构建了矿业集团生产信息多维数据模型,并完成了相关的数据分析。从集团管控模式的角度出发,在科学规划生产数据的基础之上,进行了可视化的数据ETL处理和主题域的确定,搭建了矿业集团生产信息数据仓库,构建了生产信息多维数据模型,利用OLAP技术对模型进行了多角度、深层次的分析与研究,最后采用敏捷型BI工具实现了生产信息可视化的多维分析操作与图形展示。通过敏捷型BI生产信息分析模型在国内某大型矿业集团的应用,实现了集团下属矿山企业生产运营数据的汇总、统计分析及异常预警,促进了矿业集团生产信息智能分析和科学决策能力的提升。In order to solve the problems that the data of the bottom production and operation of the mining group are difficult to be analysed,and can not be directly transformed into the information integration on the strategic level,it is easy to form the data island.Based on the agile BI implementation plan,this paper constructs the production information of the mining group by many kinds of modern information technology Multidimensional data model,and completed the relevant data analysis.From the point of view of group control mode,based on the scientific planning of production data,the ETL processing of data and the definition of subject area are made.The production information data warehouse of mining group is built,and the multi-dimensional data model of production information is constructed.Use OLAP technology to analyse and research the model from multi-angle and deep-level.Finally,the agile BI tool is used to realize the multidimensional analysis operation and graphical display of production information visualization.The agile BI production information analysis model is applied to a large mining group in China to realize the summary,statistical analysis and abnormal early warning of the production and operation data of the mining enterprises,and promote the intelligent analysis and scientific decision-making ability of the mining group.

关 键 词：矿业集团 生产信息 商业智能 敏捷型BI 多维数据模型 

分 类 号：F406.2[经济管理—产业经济]