Client looking at significant expansion in its QSR outlets across airports and highways resulting in high growth in retail transactions and complex financial reporting
Multiple POS and ERP systems, high volume of daily transactions, multiple files extraction with manual interventions
Absence of a centralized data warehouse or BI data pipelines to provide a unified view
Approach
Gap assessment to define implementation, BI infrastructure and reports roadmap
Integration with source data coming from Navision, Dynamics 365 Business central, CSV files from POS systems, automating manual data capture in spreadsheets
ETL, data pipeline creations. Data modelling and data aggregation scripts for unified view
Leveraged Azure data factory, azure automation, Azure SQL, Power Automate and Power BI to establish the BI solution
Achievements
Availability of daily consolidated view for the business which eliminated monthly financial reconciliation efforts
90% automation of manual data tasks resulted in 30% improvement in team productivity
5 years of historical data upload allowed trend insights on item sales analysis, purchase analysis, stock analysis and business finance control parameters positively impacting the bottom line
Streamlined business reporting eliminated silos of information across finance, sales, supply chain and business control departments
