The construction of the full-service data center of State Grid Offshore Power fully supports the application of enterprise-level big data analysis

Recently, the State Grid Offshore Power All-Service Data Center completed the construction
of 16 application scenarios, including incremental power sales full-link monitoring and analysis, comprehensive inquiry and tracking of project budgets, analysis of user power consumption behavior, and analysis of distribution and heavy overload risks.
This is an effective presentation of the analysis domain construction achievements of State Grid Offshore Company, marking that the construction of the analysis domain of the full-service data center of Shanghai Company has the initial ability
to support enterprise-level big data analysis applications with "data-centric management".

The full-service unified data center is a comprehensive upgrade of the existing data center of State Grid Offshore Power, and is a collection center for full-service scope, all-data type and full-time dimension data, which can ensure clean and transparent data, unified model specifications, flexible and intelligent analysis, provide unified storage, cleaning, management and analysis services, and realize a new situation
of information application of full-service data integration at the source end and back-end big data analysis 。 The construction of a full-service unified data center is a comprehensive mining of the value of business data, which can effectively promote cross-business and cross-department business integration and data sharing, and provide strong support
for truly using data to manage enterprises and information-driven business.

In terms of data access, the full-service unified data center has completed a total of 18,961 tables and 20TB of full data for 18 sets of secondary deployment systems such as marketing business applications, basically covering all business data
of the company.

In terms of data cleaning and transformation, according to the data model and master data standard design results uniformly released by the State Grid Corporation, combined with the actual business situation and analysis scenario construction requirements of the company, the information and communication company, the source system manufacturer, and the whole business project team were organized to complete the differentiated analysis and model mapping of the data warehouse model, including physical tables, fields and field types, etc.
, and completed the creation of 5428 model tables and the access of 2103 model data
.

In terms of application scenario construction, Shanghai Electric Power adheres to the idea of "promoting construction with use", organizes cross-professional exchanges and communication between multiple departments such as operation supervision, marketing, materials, operation inspection, and finance, and has completed the construction of 16 analysis scenarios such as customer service association analysis and response monitoring, incremental power sales full-link collaborative monitoring, and project plan implementation and whole-process collaborative operation monitoring and analysis to support the changing business needs and data analysis needs of various business departments.
At the same time
, a set of big data analysis construction methodology was summarized.

By using the analysis domain of the whole business unified data center, the State Grid Offshore Company reduces the difficulty of cross-professional data application, initially realizes cross-departmental collaborative management within the company, basically realizes the internal sharing of various professional data, and reduces the overall cost of
information construction.

In the next stage, State Grid Offshore Power will continue to carry out the deepening application construction of all service application scenarios, promote comprehensive data sharing, promote deep business integration, support the horizontal collaborative business and innovative application of big data of State Grid Offshore Power, truly realize the use of data to manage enterprises and information-driven business, and lay the foundation
for promoting the company's business innovation, management mode transformation, management efficiency and effectiveness improvement.