Smart cost analysis with BI by SKU

Category

Project

Área

Controlling

Industry

Engines and Automation

Company size

Large enterprise

Project duration

6 months

Challenge

The organization needed a macro view to identify and understand the impacts of price and quantity variations in the materials used. The absence of a centralized tool made it difficult to map costs by SKU (Stock Keeping Unit), limiting detailed analysis of the factors driving cost fluctuations.

Proposed solution

Dojo implemented a Data Engineering and Business Intelligence solution, centralizing information in the Business Data Driven platform. Data was processed and standardized to provide reliable and detailed insights.

01

Data centralization:

Structured data into a single platform, ensuring standardization and accessibility.

02

Analytical dashboard in QlikSense:

Developed an interactive dashboard to map and analyze cost variations in raw materials by SKU.

Results achieved

Enhanced control: Accurate identification of cost variation causes, with in-depth SKU-level analysis.

Strategic decision-making: Centralized data and intuitive visuals to support informed decision-making.

Operational efficiency: Reduced time spent on manual analyses and improved agility in cost control.