A transformative solution What we provided The solution was based on Fractal’s expertise from the integrated business planning practice, leveraging SAP and Azure data-bricks for data manipulation and processing. In addition to this, Power BI was used to create the final dashboards, reporting and visualization. The solution automated the data-to-decisions journey for the client. It required data from multiple sources, including SAP and manual excel files, which were then harmonized to create an enterprise-wide single source of truth.
AZURE
SAP
POWER BI
ADLS
Source Layer
Data landed from SAP & external sources and convert into Parquet format
•
Automated Validation
3
Latest year/period
ADF
Databricks
Supply Chain
OpenHub Country 1
Manual Validation
Automated Validation Automated Validation
Application Layer
4 5
OpenHub Country 2
Feeder data/source queries (per template query)
• Data transformation • Data integration • Filtration • KBI Calculations • Aggregations
Commercial
Composite/ Multi providers (view)
Template Queries (per multi providers)
8
Data Marts
Databricks
OpenHub Country n
Finance
Golden Layer
9
Automated Validation
External Sources
6
• Final star schema • Consumption-ready format
Email communication to users
X Functional
Databricks
Automated trigger of jobs Automated Validation
Automated trigger of ADF jobs by SAP
1
2
7
Automated trigger of PowerBI refresh
6
© 2022 Fractal Analytics Inc. All rights reserved
Made with FlippingBook - PDF hosting