Analytical system and corporate data warehouse development | JET BI

Case studies

Analytical system and corporate data warehouse development

SAP
Retail
Published
6 Feb, 2018
JET BI TEAM 
  • 1 Project Manager,
  • 1 Methodologist,
  • 2 DBMS Developers,
  • 2 SAP BO Consultants
TECHNOLOGIES 
  • MS SQL,
  • SAP Business Objects,
  • SAP Design Studio,
  • SAP Explorer,
  • SAP BI Mobile,
  • SAP BO Web Intelligence,
  • 1C
PROJECT TIMELINE 

6 months

 
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.

 
Goals and tasks 
  • 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.
Project scope 
  • 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 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
Result 
  • 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 historical 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.
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