Developing of corporate reporting in regard to KPI`s analysis | JET BI

Case studies

Developing of corporate reporting in regard to KPI`s analysis

SAP
Manufacturing
Published
7 Feb, 2018
JET BI TEAM 

1 Lead SAP BW Consultant

TECHNOLOGIES 

SAP BW

 
PROJECT TIMELINE 

9 months

 
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.
Result 

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.

About Us

We develop and implement business intelligence solutions based on SAP BO/BW platform. We also provide the full cycle of Salesforce consulting: Salesforce implementation and customization, support, and ISV solutions. Mobile Development Department focuses on business solutions for iOS and Android. 

Get in touch

Minsk, Belarus
220002, Masherova avenue 19, 8 floor
Phone: +375 17 334 24 16

Projects: sales@jetbi.com

Career: jobs@jetbi.com

Connect With Us