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

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

Industry
Manufacturing

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

Need help with a similar project?

Drop us a line, and our rep will contact you within 30 minutes to arrange an initial discussion.

More Case Studies

Big Data Implementation for Advertising Channel Analysis in 10+ Countries</a> </p> <p class="cs-description">Migration to a new analytical system that ScienceSoft implemented helped one of the top market research companies secure an innovative big data solution based on Apache Hadoop, Apache Hive and Apache Spark frameworks. The new system was 100 times faster compared to the old one and could process 1,000 different data formats.</p> <a href=https://www.scnsoft.com/case-studies/"https://www.scnsoft.com/case-studies/big-data-implementation-for-advertising-channel-analysis" class="btn btn-link-arrow btn-link-arrow--right cs-learn-more-btn"> LEARN MORE </a> </div> </div> <div class="cs-item-wrapper"> <div class="cs-image-container"> <a href=https://www.scnsoft.com/case-studies/"https://www.scnsoft.com/case-studies/sciencesoft-empowers-tv-apps-industry-leader" class="cs-image-wrapper"> <img class="lazy cs-image" width="200" height="200" src=https://www.scnsoft.com/case-studies/"data:image/svg+xml;base64,CiAgICAgICAgICAgIDxzdmcgeG1sbnM9J2h0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnJyB2aWV3Qm94PScwIDAgMjAwIDIwMCc+CiAgICAgICAgICAgICAgICA8cmVjdCB3aWR0aD0nMjAwJyBoZWlnaHQ9JzIwMCcgZmlsbD0nI2YyZjJmMicvPgogICAgICAgICAgICA8L3N2Zz4KICAgICAgICA=" data-src="/boss/images/eaeaa2b3-73be-4810-ae16-8225e27b1ca3iptv_leader_small.jpg" alt="Development of IPTV &amp; SVOD Apps and a Web-based Management System for a TV Industry Leader"> </a> </div> <div class="cs-content"> <p class="cs-title accented-text"> <a href=https://www.scnsoft.com/case-studies/"https://www.scnsoft.com/case-studies/sciencesoft-empowers-tv-apps-industry-leader">Development of IPTV &amp; SVOD Apps and a Web-based Management System for a TV Industry Leader</a> </p> <p class="cs-description">A success story of a long-term partnership (over 5.5 years) which has brought the Customer to become one of the leading TV apps providers in the world. Created with ScienceSoft&#039;s help, the company&#039;s star product – hybrid mobile apps – now power T-Mobile, Orange and other telecom industry leaders.</p> <a href=https://www.scnsoft.com/case-studies/"https://www.scnsoft.com/case-studies/sciencesoft-empowers-tv-apps-industry-leader" class="btn btn-link-arrow btn-link-arrow--right cs-learn-more-btn"> LEARN MORE </a> </div> </div> ">