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
| Duration | From 5/1/2019 to 12/27/2019 with about 8 months of full engagement | |
|---|---|---|
| Data and Tools | Market - Tourism Sources • Oracle • MS SSAS | |
| Integration | We integrate Excel and PowerBI to be supported by one Data Source as a Single Source of Truth (SSoT) | |
| AI Methods | Data 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 Approach | Project Management in AI Environment (Agile) | |
| Project Approach | Simply agile | |
| Project Type | Operations/ML Ops | |
| ML Integration and ML Operations | Operations Integration • SSAS/SSIS • Excel • Power-BI |