This client is an industry leading, multinational manufacturer, supplying corrugated products for infrastructure to agricultural, commercial, and industrial markets. Since 1996, this company has been operating a global network of approximately 60 manufacturing plants and over 30 distribution centers. They continually seek to enhance their products, services, and research, and their focus on innovation is a promise their customers have come to count on.
Like all building material suppliers, the COVID-19 pandemic and economic activity boom since mid-2020 has vastly increased this company's demand from customers, while putting new pressure on the supply chain and manufacturing operations.
In particular, the company needed to combine and analyze data from an integrated set of business applications called Oracle E-Business Suite (EBS) and from third-party logistics tools. Existing Business Intelligence (BI) processes and tools could not capture and synthesize in a timely fashion and the legacy BI systems, relying on purpose-built Oracle reports and flattened SQL tables, presented multiple bottlenecks in terms of need definition, development, validation, and deployment. The business and IT teams were also hampered by operating within the small scope of their own legacy tools, without access to cross-divisional data that could provide executives with an integrated picture of business operations and aid in making crucial decisions.
This company entered into a consulting partnership with BlueGranite in order to streamline their supply chain analytics and provide valuable insights around customer demand trends. BlueGranite proposed a Modern Analytics overhaul of the entire Business Intelligence approach the company currently used, with rapid time to value produced due to the agility brought by BlueGranite’s Catalyst framework.
The final solution spanned multiple areas in parallel, each using the BlueGranite Catalyst QuickStart Framework:
1. Analysis and Design
2. Azure Landing Zone
3. Swimming in the Lake
4. Training and Roadmap Creation
This project delivered immediate value for the company in each solution area:
By optimizing the Analysis and Design processes, reports were created and curated within weeks. This contrasted with the months-long process previously in place.
High priority areas of analysis were identified, including:
This has resulted in immediate business value across the board: improved cost savings, improved supplier performance, and increased procurement efficiency.
By setting up an Azure Data Lake Landing Zone and have the chance to Swim in the Lake, The BI team was able to quickly choose to use Azure Synapse as the preferred ELT tool. This removed the need for SMEs to spend time creating business logic for consumption by the BI team, and enabled the iterative enhancement of metric definitions within the BI report development process.
Self-service reporting availability allowed analysts to access and enhance existing assets the same day. Previously, this process would have required the involvement of IT to create reports through a ticketing system.
Through Training and Roadmap Creation, a Modern Analytics Program is underway. The roadmap includes:
BlueGranite’s work with this process manufacturer empowered the company to amplify their ability to provide the right products, from the right vendors, at the right cost, in the right place, at the right time. These efforts allowed the company to realize immediate positive impact to their bottom-line spending, enhance vendor relationships, and ultimately improve customer satisfaction and profitability.
Interested in learning more about how BlueGranite can help accelerate your modern analytics solution? Contact us today!