Data warehouse dimensional modeling for customer service business

Abstract

The daily traffic volume of the State Grid 95598 Customer Service Center exceeds 800,000. In order to manage and store these massive data, we must carefully handle it. The call from electric customers implement the business philosophy of “Quality service is the lifeline of electric power enterprise”, and carry out related data aggregation, processing, statistics, conversion and analysis based on data warehouse, and fully explore and analyze these with big data analysis technology. The potential value in the data guides the optimization of business processes and improves the service quality and efficiency of the business center.

Keywords

• data warehouse
• dimensional modelling
• etl
• olap