The invention relates to the technical field of
electric power industry, and discloses a BI data technology-based
power grid cost review auxiliary method,
system, device and medium, and the method comprises the steps: integrating multi-source
engineering data, and carrying out cleaning and
standardization processing to construct a multi-dimensional data cube; calculating a
list item reference unit price based on historical data and predicting a project cost, and comparing the project cost with a submitted value to realize quantitative analysis of a project level and
list level deviation; constructing a risk comprehensive scoring model in combination with the historical abnormal rate and the current deviation characteristics, dividing early warning levels, and screening key review
list items; and realizing risk visual display based on a BI platform, and automatically generating an auxiliary report containing review key points and suggestions. According to the method, full-process digital review from
data integration, intelligent analysis, risk early warning to decision support is realized, and the review efficiency, the anomaly recognition accuracy and the
resource allocation rationality are effectively improved.