CAREERS
    CONTACT US
    Avatar_Color
    Back to achievements

    Data Reorganization

    • Practice
    Data Architecture Data Visualization Change Management Data Management
    • Team

    1 Architect, 1 Scrum Master, 3 Developers/Analysts

    • Technical environment
    +100
    stores
    6
    business lines
    1 vision
    clear and collaborative
    CHALLENGES

    When our client was founded, it inherited a BI infrastructure, including an on-premise BI stack and an ERP system. However, in 2021, a strategic shift was made to migrate the entire ecosystem to a modern cloud architecture to:

    • Achieve complete independence from the previous headquarter infrastructure.
    • Modernize data management to better support strategic operations.
    • Improve reporting and analytics capabilities for business decision-making.
    • Enhance agility and governance across departments.
    SOLUTION
    • Collaborative workshops to identify key KPIs and business needs.
    • Development of a roadmap for technology migration and governance improvements.

    • Migration of data to Snowflake and automation of ETL flows with Matillion.
    • Creation of a centralized data warehouse with daily refreshes via Power Automate.

    • Design and delivery of interactive dashboards aligned with business needs.
    • Training of internal teams to enhance autonomy and maximize tool adoption.
    BENEFITS
    • BI as a strategic lever: A clear and collaborative vision that maximizes business impact.

    • Data Mesh approach: A balance between centralization and team autonomy, promoting effective governance and fast adoption.

    • Agility and co-construction: Iterative deliveries and collaborative workshops ensuring the successful adoption of BI tools.

    • Rigorous documentation: Comprehensive documentation that guarantees the sustainability and quality of key indicators (formulas, sources, frequency).