BI@Report数据分析展示平台北京亿信华辰软件有限责任公司2024年11月目录目录............................................................................................................................1第一章项目概述..........................................................................................................11.项目背景............................................................................................................12.业务现状............................................................................................................23.项目目标............................................................................................................24.项目范围............................................................................................................3第二章需求分析..........................................................................................................41.数据采集与上报................................................................................................41.1业务基础信息..........................................................................................41.2业务数据及报表......................................................................................42.数据整合............................................................................................................52.1数据源分析..............................................................................................52.2数据整合内容..........................................................................................63.报表展现与分析................................................................................................7第三章解决方案..........................................................................................................81.维度建模............................................................................................................81.1主题维度交叉表......................................................................................81.2维表..........................................................................................................81.3主题表......................................................................................................92.ETL....................................................................................................................92.1ETL总体说明..........................................................................................92.2ETL过程..................................................................................................93.运行环境..........................................................................................................104.数据采集与上报..............................................................................................105.报表展现..........................................................................................................105.1SQL数据源...........................................................................................105.2固定行列................................................................................................115.3钻取........................................................................................................115.4即时分析..........................................................