All cases

Azure-based PaaS solution for an FMCG company

Client
A multinational consumer goods corporation
Industry
Fast-moving consumer goods (FMCG)
Services
Cloud architecture redesign, data warehouse migration, BI modernization, AI integration, data analytics
Tech stack
Azure Data Lake Storage, Azure SQL Data Warehouse, Azure Data Factory, Azure Databricks, Azure Analysis Services, Azure App Service, Azure SQL Database, Azure AI Services, Power BI

Challenge

The client, a multinational consumer goods company, used a centralized business intelligence (BI) solution to process and analyze electronic point-of-sale (ePOS) data from several dozen different sources. Each week, the system processed over 40,000 reporting workflows. However, as the volume of ePOS data grew, the underlying infrastructure-as-a-service (IaaS) architecture struggled to handle it at scale. The FMCG company experienced data ingestion delays, inconsistent validation processes, and lagging report generation, which hampered decision-making across all business units. Furthermore, the system's lack of AI capabilities prevented the client from identifying trends and predictive insights from their data. To address these limitations, the company sought to transition its analytics ecosystem to a more scalable, AI-enabled platform built on Microsoft Azure. That's when they approached ITRex.

Solution

The ITRex team dug deep into the customer's business needs and assessed its existing technology infrastructure and AI readiness. Based on our findings, we proposed redesigning the client's data and analytics infrastructure and migrating their data warehouse and business intelligence tools to a Microsoft Azure cloud platform. This approach would ensure long-term scalability, reduce processing bottlenecks, and allow for advanced and self-service data analytics as well as integrated AI services. After the client approved the technical vision, the solution was implemented as a platform as a service (PaaS). ITRex’s key activities included:
Data storage modernization. ITRex replaced on-premises databases with Azure Data Lake Storage and Azure SQL Data Warehouse, enabling scalable data ingestion, storage, and high-performance querying.
ETL pipeline overhaul. We used Azure Data Factory to manage ingestion pipelines and Azure Databricks to transform raw data into clean, standardized, and actionable datasets.
BI and reporting enhancement. Our data analytics specialists migrated the existing workloads to Azure Analysis Services, allowing for fast, real-time insights delivered via Power BI dashboards.
Application modernization. The ITRex team ported the client's custom application for BI maintenance to Azure App Service and implemented Azure SQL Database for data storage.
AI-powered insights. We integrated the PaaS solution with Azure AI Services to enhance the customers’ data analysis capabilities with predictive machine learning models while democratizing access to insights for non-technical employees.
With the new system, the FMCG company increased productivity, improved software maintainability, and laid the groundwork for future AI and automation initiatives.
PaaS solution for an FMCG company
PaaS solution for an FMCG

Impact

Scaling data workflows and user loads without compromising performance
Reduced operational expenses through efficient resource utilization and appropriately sized services on the platform
Streamlined business decisions due to significant reduction in data ingestion and transformation times (from hours to minutes)
Strengthened analytics capabilities thanks to real-time reporting supported by Power BI
More proactive and data-driven decisions with predictive insights and recommendations
Increased compliance and data protection powered by Azure-native security features and governance policies

Latest projects