The name of the base system (platform): | QlikView |
Developers: | BI Consult (Bee Ai Consult) |
Date of the premiere of the system: | 2015/01/01 |
Last Release Date: | 2015/06/01 |
Branches: | Logistics and distribution |
Technology: | BI |
BusinessQlik for Distribution company is a BI management system for sales, the analysis of indicators of sales, the analysis of sales volumes in distribution.
Advantages
- Structuring the range - selection of the most profitable groups, failure from unclaimed and unprofitable products;
- Increase in speed of turnover - improvement of work with suppliers and customers, the analysis of orders, planning of deliveries;
- Increase in efficiency of personnel - competent planning of activity, selection of the main directions, clients and suppliers;
- Decrease in the transportation costs and expenses connected with storage - improvement of logistics, optimization of warehouse stocks, increase in turnover;
- Reduction of risk of non-payments - increase in payment discipline, structuring the customer base;
- Increase in attractiveness of the company for clients - improvement of service, speed of reaction and delivery dates;
- Increase in efficiency of the company - cost reduction and losses, acceptance of operational reasoned decisions, increase in speed of work of employees.
Functionality
- use all completeness of information for sales management
- analyze sales in different cuts: clients, articles, brands, regions, suppliers, producers;
- analyze efficiency of sales and purchasing managers;
- analyze the customer base: determination of the importance of each client, level of the profit brought by the client, degree of dependence on this or that client;
- see geography of sales on the cities, regions with the maximum detailing;
- analyze the range: determination of the importance and marginality of these or those commodity groups, assessment of the got profit by the nomenclature and the analysis of expediency of development of the range or its output;
- make the plan-fact analysis of sales;
- predict demand by commodity groups, articles, regions, etc.;
- make monitoring of ratings on brands, commodity groups / subgroups, on clients;
- analyze payment discipline in dynamics: scope change of debt for date;
- manage stocks through the analysis of a warehouse, purchases and logistics
- manage stocks, see structure of a remaining balance, their turnover and plan a goods turnover taking into account forecast demand;
- control commodity balance (the movement of goods + a goods remaining balance on reporting dates);
- define efficiency of use of warehouse spaces and estimate overstocking of a warehouse, age and cost of storage of goods in a warehouse;
- define the optimal periods and the amount of deliveries and to manage excesses and deficit of trade inventories;
- make the combined analysis of a commodity remaining balance with sales level;
- analyze the history of work with the supplier in dynamics;
- implement reasonable marketing
- make segmentation and the analysis of target groups and the market;
- estimate and predict volumes and demand pattern and sales;
- determine the consumer value of goods;
- develop effective strategies of promotion and sale;
- estimate efficiency of marketing actions and sales channels;
- create complete idea of a financial status of the company
- it is easy to prepare and check standard financial statements;
- make and update the budget;
- analyze creditor and debit debts;
- in details to analyze a cost structure in places of emergence in different cuts.
- it is effective to manage employees and their motivation
- calculate KPI of divisions and employees;
- control accomplishment by employees of planned targets.