Skip to main content

Developing of corporate reporting in regard to KPI`s analysis

Published by admin
07 February 2018

Project description 

Within the project has been created a set of reports that provide an evaluation opportunity for the efficiency of the main production processes – load of production lines, efficient use of operating hours, production downtime and scrap rate. In addition, the developed reports provide a status of the entire works done within the whole company as a well as give an opportunity for detailed reports on each employee and on the production order numbers. Client: International manufacturer and vendor of insulations.

Goals and tasks 

  • Integration MS SQL and SAP BW;
  • Data analysis, development of the key performance indicators;
  • Development of the data model and data flows in SAP BW;
  • Development of BEx-query reporting;
  • Development of Web-reporting and its publishing at the corporate portal.

Project scope 

  • Within the project was performed integration between MS SQL, monitoring of the production lines, and SAP BW as an enterprise data warehouse;
  • Data collection is carried out in real time with the opportunity to monitor the loading status.


As a result of the project have been implemented 6 reports, that were put into production operation in November 2016. Today more than 170 persons use these reports in 17 countries worldwide.

Advantages of JET BI 

  • Unique technical expertise and experience in Business Intelligence tools;
  • High quality thanks to the efficient QA processes and the transparent handling of bugs enhancement applications;
  • Bureaucracy minimum;
  • Adjustment to the client`s internal processes, challenges implementation with regard of the specific of the business processes;
  • High level of employees’ motivation.
Start your project now
  • 1 Lead SAP BW Consultant
  • SAP BW
  • 9 months
Question to the expert

We have available resources to start working on your project within 5 business days

1 UX Designer


1 Admin


2 QA engineers


1 Consultant