Rethink visualisation to make smarter, more timely decisions
Challenge
Gul Ahmed is one of the leading giants of the textile world in Pakistan today, and with its massive operations both internally as well as for exports, it has multiple data points coming in from all over the globe every minute of every day. Gul Ahmed had Azure cloud-based ERP in Microsoft dynamics for sales and inventory of more than 250 retail outlets, warehouses, franchises, and fabric stores. They also have a global presence via e-commerce around the world which has a source system in Magento. LFD's task was to integrate all their source systems including Google Analytics, Facebook analytics, Support system, HR sales representative, Magento, and dynamics all together in a flawless data model, one that would simplify their business and provide insights and results in a timely and efficient manner.
Solution
We developed the dashboard using Power BI, with the aim to consolidate all their data into one single platform which could be used for any and every business problem they had. While previous daily business reports used to take 3 days to compile with external help from IT/specialists, our self-service BI dashboard provides access to the required information and to the pre-compiled KPI/measures to business owners across the organization, helping them perform analysis as and when they require.
Result
The dashboard is extremely comprehensive in that it gives a bird's eye view to the management across all their business categories, whether it is for strategic information such as overall sales performance and inventory management, down to the minutest detail such as brand-wise or SKU-wise performance and region-wise average cart size for online sales. They can now have live data at their fingertips, with the format and level of detail they require, and make business decisions more accurately and efficiently.
