Sign up to receive our monthly newsletter, and get the latest insights, tips, advice, and all the resources you need to transform your business with data.
Count on us to be a resource for you. Our webinars equip you with data and analytics best practices and expert insights about the industry. You can also find us guest speaking at industry conferences and user group meetings.
To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.
+1 312 878 6600 Mon-Fri 8:30am-5:30pm CT
Thanks for your inquiry! Someone will be in touch shortly.
Power BI, SQL Server
This CPG company provides food, electronics, clothing, and other goods to its customers. Being able to run analysis on all its suppliers is critical for supply purchasing decisions and the lack of understanding the nuances among its suppliers led to inefficient inventory planning.
The company was basing its supply-purchasing decisions on internal historical models that failed to account for contemporary supply chain issues. They were using Excel, where spreadsheets with historical data were the driving force behind purchasing decisions. The data, however, was extremely siloed, so information such as lead time was separated out from specific supplier data. Historical charts were nonexistent, and much of the decision-making was done based on business intuition rather than on data visualizations that allowed for all the information to be presented collectively. This led to inaccurate planning, as well as supply chain issues further down the chain. The company was:
The company brought Analytics8 in to solve three primary business needs, including warehouse fulfillment accuracy, optimized inventory levels, and root cause analysis so that it can better manage its suppliers and better serve its customers.
Working directly with the VP of Purchasing, as well as the Supplier Relationship Management and Purchasing teams, Analytics8 developed a supplier scorecard application that enabled the company to better understand its suppliers and measure key metrics that would derive the most value.
We leveraged a vast array of data sources—from SSAS Cubes, to directly pinging SQL Server Databases, and from Power BI Dataflows. We stitched together supplier information, daily sales and distribution data, inventory data, sales team data, and other related information that was not previously integrated. We then implemented three foundational KPIs—On Time, In Full, and Perfect Order—that would be the driving force behind decision-making for the company. Next, we visualized these KPIs against different dimensions such as Supplier, Products, Year-Month-Week, etc. and developed several visualizations that compared all three KPIs in a supplier scorecard application.
All the KPIs can be visualized across three years of historical data, while ranking supplier performance on scatter plots against each other, as well as displaying supplier performance against their total order count. All of this is possible by filtering on things such as Order Status, Item Description, Supplier Name, and obvious time dimensions that enhance the company’s analysis. We also provided detailed line-by-line delivery information so that the company can pinpoint the exact deliveries in which things went awry, in an export detail page. The data is usually analyzed over months of time, but this granular information allows for the company to specify instances of items not being delivered On Time or In Full.
The application exists within Power BI and procures real-time data which refreshes daily.
With the supplier scorecard, the company can now profile suppliers based on relevant information such as product lead time and historical performance against COGS, On Time, In Full, and Perfect Order. This drives for a more equitable supplier scorecard which compares providers of goods on a more even playing field while creating more accurate planning for the thousands of items that go in and out of the company’s Distribution Centers. As a result, the company is better able to:
Rather than spending time trying to manually compile supplier profile information on disparate Excel sheets, all relevant supplier and product information is presented collectively. This leads to not only quicker analysis on purchasing decisions, but also more robust understanding of which suppliers’ Promise Time Windows need to be adjusted. The company also can now leverage price negotiations with real-time data when showing how often suppliers under or oversupply, and the inherent costs associated with those supply chain inefficiencies.
As a result of the implementation of the supplier scorecard solution, the company has realized substantial ROI including:
This CPG company provides food, electronics, clothing, and other goods to its customers.
Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.