Groupe Amiel
Retail, B2B Distribution
Migration of the analytics environment to the cloud, with the goal of replacing an infrastructure built on aging technologies while preserving access to data and strategic reporting that support the organization’s operations.
Context
1
The initial environment was based on SQL Server Reporting Services (SSRS), which did not allow interactive data access and resulted in additional delays in processing user information requests.
2
The ETL architecture built on SQL Server Integration Services (SSIS) was difficult to maintain and support. The BI team experienced challenges, particularly when attempting to partially rerun failed load processes.
3
The growing number of reports and data extracts across business teams made it difficult to maintain consistency and alignment in analytics.
Challenges
Modern, Future-Ready Technologies
Migrate the entire analytics environment to a modern cloud platform capable of supporting the company’s recent and anticipated growth.
ETL Process
Implement a modular and flexible ETL architecture that allows new data sources to be easily added and processes to be resumed based on user needs.
Reporting and Analysis
Provide a comprehensive, centralized solution to meet users’ analytical needs.
Version Control
Implement a simple and effective mechanism for managing versions of the internal analytics solution, as well as production deployments and updates.
Objectives
1
Migrate to a modern cloud architecture on Microsoft Fabric.
2
Migrate SSRS reports to Power BI while preserving existing business functionality.
3
Strengthen the ETL architecture to more easily extend it in line with anticipated future business needs.
4
Establish a DevOps practice within the analytics environment managed by the internal BI team.
Solution Proposed by Neos
Migration and Reorganization of the ETL Environment
Architecture Review
In-depth needs analysis to design an optimized infrastructure on Microsoft Fabric
Migration to Microsoft Fabric
Data migration to a Medallion architecture (bronze, silver, gold) on Microsoft Fabric centralized data sources, simplifying the management and analysis of both structured and unstructured data.
Migration and Modernization of Reports
Development of Dynamic Power BI Reports
Creation of interactive dashboards in Power BI as part of targeted internal improvement initiatives.
Migration des rapports SSRS vers Power BI Paginated Reports
Migration of existing reports to Power BI, reproducing key features from the previous environment (scheduled subscriptions, user-based data pre-filtering).
Strengthening the ETL Architecture for Future Growth
Data Pipeline Parameterization
Use of configuration-driven data to build a data-driven ETL process within Microsoft Fabric. Load times were reduced by optimizing and excluding non-required components (unused source data in the silver and gold layers).
Establishing a DevOps Practice
Use of Azure DevOps for Version Control
Creation of an internal best-practices guide for the BI development team and for managing analytics environment deployments. Development of validation and deployment pipelines within Azure DevOps and Fabric.
Resultats Achieved
Predictable ETL Processes
Implementation of a robust ETL architecture delivering consistent and reliable results over time.
Structured Feature Deployment Management
With Azure DevOps, Git, and Fabric Deployment Pipelines, the Groupe Amiel BI team can now better structure the rollout of new features, test changes confidently before production release, and ensure controlled deployments.
100% Cloud-Based Environment
The migration to Microsoft Fabric established a fully cloud-based analytics environment at Groupe Amiel—future-focused and aligned with new data sources that will be integrated in the coming years.
Conclusion
Groupe Neos transformed Groupe Amiel’s analytics infrastructure into a modern, centralized, and scalable ecosystem. By leveraging advanced tools such as Microsoft Fabric, the organization now benefits from a robust and predictable data ingestion process, along with structured version management and enhancement workflows.
These improvements have enabled Groupe Amiel’s internal BI team to ensure continuity of analytics services across the organization while enhancing internal governance and implementing more accessible development practices in preparation for future team expansion.