Data Analysis for a German Metal Parts Manufacturer

Summary

A German metal parts manufacturer struggling with demand fluctuations wanted to prioritize its product categories and needed a highly qualified BI team to perform comprehensive data analysis — quickly and with a minimal technology stack. INNERLUXES's BI team delivered analytical reports and charts using only Microsoft Excel and PowerPivot, helping the Client choose focus categories and streamline the business.

About the Client

The Client is a German metal parts manufacturer.

The Challenge

Struggling with demand fluctuations, the Client wanted to prioritize its product categories. With this challenge in mind, the Client needed a highly qualified BI team to perform a comprehensive data analysis. Additionally, the project had to be implemented quickly and with a minimal technology stack.

The Solution

INNERLUXES's BI team analyzed the Client's Excel and flat files covering two years of data, created a pivot table, and loaded the data into it. The team then cleaned the data and created analytical reports and charts broken down according to the Client's needs.

The reports and charts demonstrated:

• Revenue.
• Monthly revenue per product group.
• Income by customer group (permanent vs. one-time customers).
• Total quantity of metal parts produced per month.

Since the Client wanted to involve a minimal technology stack, INNERLUXES suggested using only Microsoft Excel and Microsoft Excel PowerPivot.

The Results

• Thanks to the delivered data analysis, the Client was able to decide on focus categories and streamline the business.
• The Client's other requirements were also met: the project was delivered quickly and using only Microsoft Excel and Microsoft Excel PowerPivot.

Technologies and Tools

Microsoft Excel, Microsoft Excel PowerPivot.