目录1背景....................................................................................................................................-1-2需求概述............................................................................................................................-2-2.1电量分析................................................................................................................-2-2.1.1基本指标....................................................................................................-2-2.1.2深度分析....................................................................................................-2-2.2供电可靠性分析....................................................................................................-3-2.3电压合格率分析....................................................................................................-4-2.4线损分析................................................................................................................-5-2.4.1基本指标....................................................................................................-5-2.4.2深度分析....................................................................................................-6-2.4.3图形展示....................................................................................................-6-2.5装备水平分析........................................................................................................-6-2.6人力资源分析........................................................................................................-7-3解决方案............................................................................................................................-8-3.1创建仓库模型........................................................................................................-8-3.1.1主题1售电量............................................................................................-8-3.1.2主题2用电量............................................................................................-9-3.2数据抽取规则....................................................................................................-10-3.2.1分析业务系统库，对数据字典进行分类............................................-10-3.2.2找出各业务系统内及其与目标数据库之间存在的数据不一致。...-11-3.2.3设计出合适的转换规则........................................................................-12-3.2.4设计数据抽取流程................................................................................-12-3.2.5设计数据抽取的流程的抽取方式，并开始数据的抽取....................-13-3.2.6对抽取到数据仓库中的数据，进行验证............................................-14-3.2.7完成数据的抽取....................................................................................-14-3.3OLAP多维分析................................................................................................-14-3.3.1多角度分析............................................................................................-14-3.3.2图形展示................................................................................................-16-3.4数据挖掘............................................................................................................-17-3.4.1关联分析...................................
