The name of the base system (platform): | Microsoft Business Intelligence |
Developers: | Digia Digia |
Date of the premiere of the system: | 01.11.2011 |
Technology: | BI |
The software solution Digia Retail Analytics is a concept of automation retail and wholesale, allowing to integrate data from all information systems of the company and to analyze them using the uniform tool. The Digia Retail Analytics system, using the developed means and tools of the business analysis and data integration, it is designed to increase profitability of your business. The product differs in the affordable price for small and medium business, a small implementation time, flexibility and adaptivity to business needs.
Main opportunities of Digia Retail Analytics
1. Consolidation of data.
- Data collection from different sources. Use of ready connectors for integration with any accounting systems.
2. Analytical reporting
2.1. Analysis of the range and goods turnover
- Analysis of dynamics of sales, average check, number of purchases. Efficiency evaluation of sales on commodity groups.
- Analysis of plano-grams of floor spaces
- Analysis of a consumer basket (Sross-selling)
- Analysis of an assortment structure (AVS, RFM analysis)
- Analysis of stability of sales (XYZ analysis)
- Analysis of structure of the check, average check.
- Analysis of elasticity of a goods turnover. Determination and assessment of seasonal goods, "sensitive" goods to external changes, shares of a contribution to decrease/increase in a goods turnover.
- Analysis of a trade margin
- Demand forecasting
2.2. Analysis of customer relations
- Segmentation of the customer base
- Analysis of profitability and customer loyalty
- Analysis of preferences of clients
- Analysis of promotion actions: discount cards, bonuses and so forth.
- Direct marketing (target mailing)
2.3. Financial analysis
- Plan fact analysis P&L
- Analysis and control creditor / receivables
- Cash flow analysis
- Analysis and control of a cost structure
- Analysis and control of wage fund
2.4. Analysis of purchases and warehouse
- Analysis of purchase prices of suppliers
- Analysis of dynamics and turnover of trade inventories.
2.5. Analysis of daily transactions
- Analysis of loading of cash points, cashiers
- Analysis of cancellings and returns of payments
- The analysis of suspicious situations (for example, use more than 3 times in day of one discount card, rolling 1 - cards from different terminals within 1 hour and so forth)
Platform of a product
Basis of Digia Retail Analytics is Microsoft SQL Server 2008 R2 comprising powerful tools of the business analysis. SQL Server is the most popular platform for data warehousing, OLAP and the reporting. Using the means of MS BI entering the MS SQL Server 2008 R2, the company had an opportunity to analyze huge data arrays (saved up decades of work and constantly increasing) with a flash-like speed, using at the same time a convenient and usual interface of the application of Microsoft Office and powerful functionality of setup of various filters.
A system is used for creation of various reports depending on a current demand and adoption of joint solutions on the basis of the intellectual analysis and forecasting of performance indicators of future periods on keyword parameters.