Business intelligence and big data analytics have become increasingly important in both academic and business communities over the past decades. Nuclear power projects involve various bulk materials and the quantities are huge. However, bulk material management in design, procurement and construction phases is disjointed to an extent thus often causes inaccurate purchase quantity of bulk materials, mismatching of upstream and downstream business schedules, poor coordination between different business segments and etc. As a result there are usually large quantities of bulk materials left at the end of the project causing huge waste. Therefore, we developed Bulk Material Management System based on the source data of Design Institute. By calculating quantities of materials as per engineering drawings we can not only provide procurement department with accurate purchase quantities for reference, but also provide construction department with amount of materials in certain installation areas. Then we do research on material balance and add time attribute to the demand materials on field and the received materials after purchasing so as to link the material items with the schedule, cost and other factors. On this basis we develop material balance report of demand quantity, received quantity and inventory quantity in order to make business intelligence analysis for procurement planning, inventory warning, etc. and thus lead to a better EPC coordination for cost and profit efficiency of the company.
[1]
N. B. Anuar,et al.
The rise of "big data" on cloud computing: Review and open research issues
,
2015,
Inf. Syst..
[2]
Zhao Xiao-bo.
Bulk material management mode of general contractors in nuclear power project
,
2011
.
[3]
Veda C. Storey,et al.
Business Intelligence and Analytics: From Big Data to Big Impact
,
2012,
MIS Q..
[4]
P. Mouncey.
Improving Data Warehouse and Business Information Quality
,
2001
.
[5]
Lida Xu,et al.
Business Intelligence for Enterprise Systems: A Survey
,
2012,
IEEE Transactions on Industrial Informatics.
[6]
Panos Vassiliadis,et al.
Conceptual modeling for ETL processes
,
2002,
DOLAP '02.
[7]
Saif Ur Rehman Malik,et al.
Intelligent Decision Making Based on Data Mining Using Differential Evolution Algorithms and Framework for ETL Workflow Management
,
2010,
2010 Second International Conference on Computer Engineering and Applications.