Data Analysis for a German Metal Parts Manufacturer with $800 mln Revenue

Customer

The Customer is a German metal parts manufacturer with $800 mln revenue.

Challenge

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

Solution

ScienceSoft’s BI team analyzed the Customer’s Excel and flat files embracing the data for 2 years, created a pivot table and loaded the data into it. After that, the team cleaned the data and created analytical reports and charts with the data broken down according to the Customer’s needs.

The reports and charts demonstrated the following:

• 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 Customer wanted to involve the minimal technology stack, ScienceSoft suggested using Microsoft Excel and Microsoft Excel PowerPivot only.

Results

Thanks to the delivered data analysis, the Customer was able to decide on focus categories, and consequently streamline the business. The other Customer’s requirements were also met: the project was delivered quickly and with the use of Microsoft Excel and Microsoft Excel PowerPivot only.

Technologies and Tools

Microsoft Excel, Microsoft Excel PowerPivot