-

Digitalization Transformation Architecture

财务"数字化"生态架构图


后台

中台 （全量全要素）

前台


数据获取

数据整合 (信息）

数据分析（经验）

应用场景

System
Developer

实时在线

IT / BI
Developer

把数据集中在一个点上 （ 去 IT 化）

Analysts/Finance
Business Partner

把知识经验集中在一个点上 （ 自助 ）

Operation
Manager

随需定制


Data
Source


Data Integration
Azure Data Warehouse


Power BI Service
Azure Data Analysis


Report
Writing


End User
Presentation


Flat Files


HRM


Roster


Finance

ERP

Sales Force / CRM

Data input



Uploader



Editable
Table



Write Back



Data
ETL

Data Factory


SSIS

Structured Data
ELT Tools


Data Factory

T-SQL

Stored
Procedure

Integration
Transition Layer
数据存储


Data Mart
Physical Layer
数据资产目录



Staging
Tables



lnput
Table


T-SQL

Business
Process

Dim Table

Fact Table


Planning
Configuration

T-SQL


Finance
Data Mart


Sales
Data Mart


Inventory
Data Mart


Sales
Planning


Production
Planning


HR
Data Mart



Power Query

T-SQL

Business
Rules


Turbo
Integrator

T-SQL

SSAS, Excel Power Pivot
　Power BI Desktop & Service
数据服务

Analytical Reporting


Calculation ( ACRG )


Aggregation


Context


Relation


Granularity


Planning Analytics


Business
Logic

DAX Function


MDX Rules



Excel
OLAP
Cube

Power BI
Report


Excel
OLAP
Cube


Planning
Analytics


Planning
Apps







Collaboration
Storytelling
　 数据可视化

SSRS


Power bi
Dashboard


Power bi
Paginated reports

Share Point

Mobile



3rd Party
BI


Planning
Dashboard


Embeded
Power bi
Dashboard