IBM > Case Studies > Gaining greater insight into P&L across the organization with centralized analytics

Gaining greater insight into P&L across the organization with centralized analytics

IBM Logo
Customer Company Size
Large Corporate
Region
  • America
Country
  • United States
Product
  • IBM Cognos Business Intelligence
Tech Stack
  • IBM Cognos Business Intelligence
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Cost Savings
Technology Category
  • Analytics & Modeling - Real Time Analytics
  • Analytics & Modeling - Big Data Analytics
Applicable Industries
  • Consumer Goods
Use Cases
  • Predictive Quality Analytics
  • Demand Planning & Forecasting
Services
  • Data Science Services
About The Customer
WD-40 Company is a global marketing organization headquartered in San Diego. The company is dedicated to creating positive lasting memories by developing and selling products that solve problems in workshops, factories, and homes in more than 176 countries around the world. As a supplier of leading industrial and consumer product brands to retailers across the globe, WD-40 Company has a complex internal financial landscape, with multiple international subsidiaries, and customer and SKU data stored at different levels of granularity.
The Challenge
WD-40 Company, a global marketing organization, faced a significant challenge in analyzing its profit and loss (P&L) due to data being held in different systems. This lack of a clear view of P&L by customer, region, or stock-keeping unit (SKU) was hindering decision-making. The complexity of the company's internal financial landscape, with multiple international subsidiaries, and customer and SKU data stored at different levels of granularity, made it extremely challenging to analyze P&L in different parts of the business. Gaining an overview of the profitability of a particular customer, region, or SKU was a laborious, manual process – and in most cases, it was simply too time-consuming to perform this kind of analysis on a regular basis.
The Solution
To solve the challenge, WD-40 Company engaged Aviana, an IBM Premier Business Partner, to help develop a solution. The Aviana team built a data mart that centralized the P&L data into a single source of truth, enabling rapid analysis and reporting using IBM Cognos Business Intelligence. This solution helped WD-40 Company’s finance teams understand business performance at a much deeper level than was previously possible – providing insight into profitability by SKU and customer, as well as by region and sales groups, and at different levels of aggregation. It also enabled users to analyze gross margin, contribution, and cost of goods sold (COGS).
Operational Impact
  • The solution automates regular reporting tasks, freeing up time for finance teams.
  • It reveals insights into performance by analyzing P&L in different business areas.
  • The solution provides insight into profitability by SKU and customer, as well as by region and sales groups, and at different levels of aggregation.
  • It enables users to analyze gross margin, contribution, and cost of goods sold (COGS).
Quantitative Benefit
  • 2 to 3 days per month saved on complex deductions analysis and reporting.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.