Case studies

Choose case studies area:
analytical-system-and-corporate-data-warehouse-development

Analytical system and corporate data warehouse development

  • Create the corporate data warehouse to optimize the data receipt time and to reduce the load on the productive environment of the 1C system implemented at the enterprise;
  • Create an analytical reporting system with a single entry point from around the world;
  • Improve the quality of management decisions through providing tools for interactive analysis and visualization of the company's performance indexes;
  • Visualization of key performance indicators in reports that provide quick answers to business questions to make the necessary management decision;
  • Reduce the cost for reports preparation through automation of the data collection process;
  • Provide users with the ability to generate reports by themselves.
Details

MS SQL, SAP Business Objects, SAP Design Studio, SAP Explorer, SAP BI Mobile, SAP BO Web Intelligence, 1C

6 months
1 Project Manager, 1 Methodologist, 2 DBMS Developers, 2 SAP BO Consultants

As a result of the analytical reporting system implementation were unified the requirements and indicators for three brands owned by the company.  It enabled the unified data interpretation and reduced the errors number by analyzing the company`s activity as a whole. The automation of data collection allowed reducing the amount of manual calculations, which significantly increased the quality of the initial data.

For now our experts have implemented 32 reports that include both operational data (for example, sales reporting for the past day) and strategic (such as analyze of the size range demand, analyze of specific collection sales and predicting future sales proceeded from the historic data).

The availability of mobile reporting functionality provided management with a tool that allows obtaining operational data about the company's activities from around the world, using only a mobile device.

A unified approach to the structure and formation of reporting, as well as an easily understandable semantic layer, enabled users to prepare necessary reports independently, without involving technical specialists

As for today, about 50 users work in the system on the regular basis. Moreover, the system prepares about 800 documents each day and sends documents to 600 stores throughout Russia.

  • Within the project was developed the corporate data warehouse by means of MS SQL, ETL-processes and integration with the corporate 1C system were set, and the analytical reporting system on the SAP Business Objects platform was implemented.
  • The implementation project started in June 2015 and went into productive operation in January 2016.
  • The works on the project implementation included the following phases:
  • Methodological research, collection of requirements, drawing specifications for reports and their interrelationships;
  • Development of the architecture of corporate data warehouse and configuration of the integration with 1C;
  • Drawing of database views, development of ETL-processes and filling the data warehouse;
  • Development of the analytical reporting by means of SAP Business Objects. The reporting is available in both browser and mobile devices;
  • Productive operation, further development and maintenance of the system;
  • Within the project works, our experts provided the smooth process of data collection into the developed corporate data warehouse from more than 600 stores throughout Russia. The omission of the reports preparation in the 1C system allowed reducing the load on the server, which resulted in the optimization of the main company`s business processes. In addition, a single data warehouse enabled business analysts to generate reports in 24/7 mode, regardless of the 1C system down time, maintenance works, and short-term breakdowns;
  • Due to the optimized architecture and competent data indexing, the average time for report generation has decreased thrice. For the time being the data volume in the corporate data warehouse reached 1TB, the maximum data refining allows you to analyze sales volume up to a single article in a few minutes, beginning from 2010.

Project description

Within the project was developed the corporate data warehouse by means of MS SQL, ETL-processes and integration with the corporate 1C system were set, and the analytical reporting system on the SAP Business Objects platform was implemented.

analytical-bi-system-sap-bw

Development and implementation of analytical BI system

As a part of a large implementation project and transition to SAP it was necessary to plan, develop and implement a Business Intelligence analytical system, to adjust the necessary integration with other systems and customer software. It enables data collection and consolidation data in a single analytical system.

Details

SAP BW, SAP Bex Analyzer

3 months
1 Project Manager, 1 SAP BW Architect , 4 SAP BW Consultants

As a result of works done were developed more than 50 complex reports for all spheres of the company's activity, the following tasks solved:

  • Designed and developed the architecture of the corporate data warehouse for the analytical system on the SAP BW platform;
  • SAP BW integration configured for data uploading from the following modules of SAP ERP system: LO, MM, SD, LE, FI-GL, FI-AR, FI-AP, FI-FM, CO-OM, CO-PA, FI- TR;
  • SAP BW integration configured for data uploading from the original SAP CRM system;
  • Bi-directional data exchange between SAP BW <-> CRM systems configured, pre-calculation of loyalty program and customer segmentation based on retail sales data in the context of checks adjusted, further results transfer into SAP CRM system set up;
  • SAP BW integration for downloading data from the initial POSDM system (cash desks) adjusted, including breakdown of check and goods item it contains;
  • Integration with Oracle Hyperion system via SAP PI  configured;
  • Regular uploading of financial data to the company's budgeting system configured;
  • Forms for manual input of plan data and indicators through BI-IP forms implemented;
  • Training of users conducted.

The analytical reporting system on the SAP BW platform was designed and configured from scratch by the team of BI Consultants within a short period of time (4 months).

The development of the system has the following peculiarities:

  • The system development started before the productive launch of SAP ERP and SAP CRM;
  • Tight deadlines for launching the functionality of analytical reports;
  • All reports were accepted by the customer in two months after the productive launch of the main systems;
  • Large amount of implemented reports and their  complexity;
  • Developed reports covered all major areas of company activity;
  • Development of a separate reports block for analysis of the company's pawn business on the basis of SAP FI-TR;
  • Client is a large retail company. As a consequence of this there is a large amount of Corporate Data Storage.

Project description

Development of the corporate data warehouse and the analytical system on SAP BW platform, integration adjustment with SAP ERP, SAP CRM, Oracle Hyperion systems. Client: jewelry retail chain.

integratsia-sap-bw-s-edi

Integration project SAP BW with EDI system

  • Integrate into existing SAP BI analytics the distributors data, develop a new block of analytical reports, set up the consolidation process, modify existing reports, add to them new indicators.
  • Provide customer with a friendly analytical tool capable of displaying in the same reports both the primary (sale and shipment of own production) and secondary sales data (sales carried out by distributors and by end merchants).
Details

SAP BW, SAP Bex Analyzer, SAP BO Design Studio, CISLink, Sales Work, SAS

3 months
1 Project Manager, 1 SAP BW Architect, 1 SAP BW Consultant, 1 SAP BO Consultant

As a result of the project was designed the system for the analysis of the distribution network (more than 300 distributors) in more than 20 countries in different currencies. This system allows  analyzing and comparing the effectiveness of sales in various countries \ regions, comparing and tracking of the balance deficit of unsold goods at production warehouses as well as at  distributions warehouses. It provides an opportunity to detail up to the desired level the sales data and to upload them into the forecasting and production planning system based on the range of SAS solutions.

Within the project was designed the data model, described the methodological principles of their adjustment to a single master catalog, designed the conversion rules, set the rules of currency translation and measurement units, set loading from two different EDI systems: CISLink and Sales Work; developed a block of new reports, set up integration s SAS system.

Project description

Development and implementation of a functional block based on the existing solutions SAP BW to download and analyze data on sales and on the balance within a far-reaching international distribution network, configure integration with EDI systems.

Project Background

  • Split view of  commodity stocks in warehouses of distributors;

  • Non-optimized reservation of stocks and their distribution within the distributors network;

  • Lack of control and inventory management systems in warehouses of distributors;

  • Absence of a single point of entry and an analytical tool, the forced necessity to use different reporting systems and manual unloading of sales data and balances to tabulate the own production data and distributors data.

korporativnaya-otchetnost-sap

Developing of corporate reporting in regard to KPI`s analysis

  • Integration MS SQL and SAP BW;
  • Data analysis, development of the key performance indictors;
  • 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.
Details

SAP BW

9 months
1 Lead SAP BW Consultant

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.

  • 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 opportunity to monitor the loading status.

Project description

Within the project has been created a set of reports that provide an evaluation opportunity for 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.

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. We serve our clients in the USA, Europe, UK, and CIS countries.

Get in touch

JET BI

Belarus, Minsk

220002, Masherova avenue 19, 8th floor

Phone: +375 17 334 24 16

Projects: sales@jetbi.com

Join our team: jobs@jetbi.com

Connect With Us