The purpose of this page is to list specific examples on how the data lake drives value and how it goes "beyond Transparency".
Knowing how & why the Data Lake creates value should help guide the squad in making the right decision choices & priorities on how to build the Data Lake.
| Area | Description | Amibition or Delivered? |
|---|---|---|
| General | Data in the Data Lake is more easily accessible to other applications. | Delivered |
| General | Data in the Data Lake is easier to access direct from the source compared to e.g. logging into BW. | Delivered |
| General | The Data Lake should be "more Transparent than Transparency", i.e. show how the data is derived & manipulated to allow people to investigate at the level they want | Ambition |
| FX Rates | The Data Lake offers a simplified and pre-enriched set of FX rates to simplify ingestion for Transparency and on-the-fly pivoting between EUR and USD. | Ambition |
| Sales History | There are inconsistencies in segmentation attributes. The Data Lake should improve data quality and consistency. | Ambition |
| Sales History | Transparency keeps only 3 years of data for performance reasons. The Data Lake should hold data back to 2018. | Delivered |
| Sales Forecast | There are data gaps on segmentation attributes for the Sales Forecast. The Data Lake should do a better job at enriching the data compared to what Transparency does today. | Ambition |
| Sales Forecast | Transparency only keeps the latest forecast run and it is not possible to see prior runs or check the evolution of the forecast. The Data Lake keeps the full forecast history. | Delivered |
| Account Managers | Transparency is facing inconsistencies on Account Manager allocation to different accounts, e.g. Salesforce / Dynasis / BW are giving different results. The Data Lake should offer a single version of the truth. | Ambition |
| Contract status | The Data Lake should make it easy to see which CPC is contracted | Ambition |
| Centralized CPC master data | The Data Lake should offer a central CPC Master Data source for data enrichment | Ambition |
| Easier SPOT integration | The Data Lake should make it easier to pull the relevant data into SPOT (no manual extract & re-import) | Ambition |
| FL ICM at Order line level | The Data Lake should offer profitability view down to orderline level | Ambition |
| Historicized Forecast Data | Only Melissa knows what she means by this | Ambition |
| Data quality on manual sources | Improve data quality on manual sources: budget file, manual corrections file | Ambition |
| Cost Forecast | Fill the gaps on 0 cost forecast by adding more intelligent "backstop" rules (e.g. default values, extrapolations, aggregations, etc) | Ambition |
| Integrate Opp & Realized Sales | Integrate Realized Sales reporting and Opportunity PIpeline reporting to stop the manual copy / paste into Salesforce | Ambition |