Norbit SAP BI4Retail

NORBIT SAP BI4Retail is the preconfigured storage for your business

Often the retail companies face difficulties with receiving qualitative analytics. As a rule, it is connected with the fact that data are stored in a type, not convenient for the analysis, at the same time the volume of the saved-up data over the years constantly grows. Besides, in the company several different accounting systems between which integration is often poorly developed can be used at the same time. If the company uses ERP- and/or the CRM system, then their functionality does not allow to cover fully all needs of business users for information analysis as they are focused, first of all, on transaction data and are poorly adapted for the multidimensional analysis. For high-quality business management and decision making of it insufficiently. It is obvious that these tasks require use of the information data warehouse in which all information is available "on clicking of the button".

The set-up packaged solution of NORBIT SAP BI4Retail (BI N4R) is developed especially for the companies of retail and retail chain stores (FMCG). During creation of a system successful project experience of automation different by the size, the range, marketing positioning and geographic location of trade enterprises was used. The solution is developed on the basis of the SAP product Business Objects BI.

Information storage NORBIT SAP BI4Retail provides a full range of the objects and reports necessary for successful and dynamic functioning of the retail company. A system is intended for the following categories of users:

• Heads of divisions
• Chief financial officers
• Logistics directors and to purchases
• Marketing directors
• Heads of analytical otel
• Commercial directors
• Directors of business development

At this NORBIT SAP BI4Retail it can be implemented as a separate system or as a part of the complete solution SAP ERP for the retail companies proposed by NORBIT company. Solution NORBIT SAP BI4Retail

NORBIT SAP BI4Retail represents the powerful and flexible instrument of data analysis and support of the made decisions.

The main difference of the solution of analogs consists that in addition to the reports, general for the industry, the packet of NORBIT SAP BI4Retail includes implementation of a number of unique mechanisms and techniques:

• On-line mechanism of loading of POS data
• The mechanism of determination of implementation and a remaining balance of goods on suppliers by FIFO method (in the absence of lot-based accounting)
• Mechanism of identification of the stale goods and its step markdown
• Mechanism of calculation of motivation of sellers
• The mechanism of calculation of a discount for discount cards
• Mechanisms of ABC, XYZ of the analysis
• Mechanisms of accounting of changes backdating
• Mechanisms of quality control of the loaded data

Also using storage it is possible to create the reports, general for the industry.

Logistic reporting:

• Sales reports
• Reports on profit
• Reports on deliveries and margins
• Reports on existence of SKU
• Reports on the purchase, retail, sredneskolzyashchy prices
• Reports on different coefficients
• Sales reports on discount cards
• Reports on checks
• Reports of Outofstock
• Reports for efficiency analysis of advertizing campaigns
• Reports for the analysis of a goods turnover, the plan / fakt-analiz
• Reports for comparison of rating of efficiency of shops
• Reports on turnover of trade inventories
• Reports for accomplishment of ABC and XYZ of the analysis
• Reports on a negative balance, analysis of regrading

Financial statements:

• Reports on revenue, comparison with historical data
• Reports on performance indicators of shops on the accounting and management reporting
• Reports of BS, PL
• Reports managerial BS and PL
• Sales reports
• Reports on comparison of performance indicators
• Reports on the plan / fakt-analizu

the preconfigured information storage NORBIT SAP BI4Retail is the ready, approved solution which is used successfully in the retail companies and retail chain stores.

When implementing similar projects the fastest system deployment allows to conduct the accumulated experiment (up to 2-3 months), to execute filling of information objects data from the accounting systems of the customer. And as a result of the project - the customer receives the expected result in combination with transparency of the project budget, accurate forecasting of terms and risks.

NORBIT SAP BI4Retail storage it:

• the configured information cubes;
• ready objects and reference books of the data warehouse;
• the configured loading procedures and transformations of data;
• the configured requests and ready report forms;
• the configured mechanisms for accomplishment of calculations;
• the prepared chains of processes for automatic execution of ETL and calculations.

One of elements of a data warehousing framework recommended for implementation within the project is the interface integration layer (IL – IntegrationLayer). It allows to separate processes of automatic data acquisition from storage system by removal them on a separate resource. At the expense of it it is possible to reach bigger flexibility of storage and relative independence of load of system resources at the runtime problems of data collection from the initial systems of the customer. The integration layer can be constructed based on a specialized software of SAP (SAP PI, SAP Business Objects BI) or using third-party software.

Advantages of NORBIT SAP BI4Retail:

• Representation of the different "cuts" of information necessary for the heads working in different divisions
• A possibility of formation of broad set of analytical reports, for any time frame, with the deep level of detailing
• Comprehensive information analysis in real time from different data sources
• Report generation and data analysis without programming

Benefits for business:

• Fall forward and correctness of the made decisions
• Reduction of costs for reporting
• Increase in "transparency" of business management

The clients using NORBIT SAP BI4Retail:

Beringov is the trading company on sale and service maintenance of home and professional appliances and electronics, consists from more than 30 shops.

Uyuterra is retail network of goods for the house in the cities the Moscow, Kaluga, Tula, Tambov, Lipetsk, Voronezh, Kursk, Belgorod, Ryazan, Bryansk, Saratov, Samara and Oryol regions, the network consists more than of 80 shops

The trade Yard of "ANIKS" – the largest network of retail stores of Biysk numbering more than 140 shops.

To Bakhetla - the trade production company which is the leading regional supermarket chain in Tatarstan and integrating under uniform brand 14 of product supermarkets.