CAREER
    CONTACT US
    Avatar_Color
    Back to achievements

    Implementation of a specialized business cloud data warehouse

    • Practice
    Tool Selection Finance Transformation Change Management
    • Team

    1 project manager / architect, 1 consultant​

    • Technical environment
    Efficient & automatic
    monthly or annual extraction
    High-performance
    database
    Data collection
    and transformation processes
    CHALLENGES
    • The absence of a database and the management and integration of numerous flat files in Power BI
      ​
    • Maintenance of numerous transformations within the reporting tool
      ​
    • Manual, time-consuming process and degraded performance (ingestion and transformation processing, restitution)​
    SOLUTION
    • Optimization and automation of Essbase extraction reports
      ​
    • Deployment of Oracle Autonomous Datawarehouse and activation of automatic indexing
      ​
    • Deployment of OCI Data Integration cloud ELT
      ​
    • Use of OCI Object Storage to help organize reference and financial data, and secure and archive them​
    BENEFITS
    • More efficient and automatic monthly or annual extraction of data from Essbase
      ​
    • A high-performance database consolidating all reference and financial data
      ​
    • Data collection and transformation processes carried out in a specialized, high-performance solution
      ​
    • Implementation of processing workflows tailored to specific needs: integration as and when required, or reprocessing of exhaustive historical data for improved performance.​