The challenge
The client needed to extend its analytical environment with new information sets and indicators. Data was scattered and measures were not standardised, making recurring analyses and reports harder to produce.
Retail
Analytics
Analytical Cube Expansion for Business Area Reporting
Built new analytical cubes with row-level security to give business areas consistent indicators and easier access to data for recurring analysis.
Ref: ADPAS101971
Video story · 1:01
The approach
Kumulus gathered requirements, mapped sources and modelled and implemented four analytical cubes with semantic relationships and processing pipelines. The work included row-level security, value validation and documentation of the objects created.
The outcome
Retail teams gained a more consistent and governed basis for recurring analysis, with four business-area cubes each designed for up to 60 tables and 20 measures. Semantic relationships, processing pipelines, row-level security and value validation underpin the expanded environment.
Built on Microsoft
Powered by
Could this work for your organisation?
The AI Audit shows where data and AI will deliver measurable value for you first.