en flag +1 214 306 68 37
Data Analysis for a German Metal Parts Manufacturer with $800M Revenue

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



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


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.


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.


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

Have a question to our team or need help with your project?

Our team is ready to provide client references, estimate your project, or answer any other question related to your IT initiative.

Upload file

Drag and drop or to upload your file(s)


Max file size 10MB, up to 5 files and 20MB total

Supported formats:

doc, docx, xls, xlsx, ppt, pptx, pps, ppsx, odp, jpeg, jpg, png, psd, webp, svg, mp3, mp4, webm, odt, ods, pdf, rtf, txt, csv, log

More Case Studies