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


Steps following request submission



After receiving your request, we analyze it and we offer free online meeting slots (via email) so that we can discuss your needs in as much detail as possible


We begin gathering all necessary requirements to create comprehensive estimates, including timelines, resource allocations, risk assessments, and underlying assumptions.


Once all preparations are in place, we will initiate the project and move forward with the planned tasks