• AI Projects with practical Experience

Homogenize reporting domains in Data Operations

Homogenize reporting domains in Data Operations

Project Profile

Consolidation in Data Operations. The change from Oracle DWH to MS SSAS as a change in the market/data area requires sensitivity. The accesses and usual queries change. The data cube with dimensions/facts is rebuilt and the errors of the previous are weeded out. Time dimensions are created usable for use in PowerBI. This clears the way for PowerBI to use and integrate a new SSAS cube.

From now on the way to the cloud and Azure Synapse is also possible to increase the flexibility of PowerBI for different sources (import, direct query and live).

At a glance - essential project data

DurationFrom 5/1/2019 to 12/27/2019 with about 8 months of full engagement
Data and ToolsMarket - Tourism
Sources
 • Oracle
 • MS SSAS
IntegrationWe integrate Excel and PowerBI to be supported by one Data Source as a Single Source of Truth (SSoT)
AI MethodsData Consulting

Engagement Use-Case

Project management for conversion of an existing multidimensional cube to SSAS (MS)

Client motivation / Solution aims

  • Operational change to a homogeneous infrastructure with best possible MS Office/MS teams/communication integration

AI Approach

AI key technology used in our solution ## Least possible change for existing processes when replacing a tool (SSAS) to achieve more data benefits.
Solution ApproachProject Management in AI Environment (Agile)
Project ApproachSimply agile
Project TypeOperations/ML Ops
ML Integration and ML OperationsOperations Integration
 • SSAS/SSIS
 • Excel
 • Power-BI