Drugstore of the hormonal medicines QlikView

Project Tasks: Have an opportunity to carry out the fast, flexible and complex analysis on arrays of operational data, allowing the company it is better to manage activity of network and to provide possibilities of its further development.

Project Steps: Development of the basic application "Analysis of Sales".

The training of specialists of IT department of "Drugstore of hormonal medicines" allowing them to develop further analytical applications for QlikView independently.

Start of a system in an ekuspluatation.

Project Effect: The Analysis of Sales application allows to analyze sales in different aspects: the periods, divisions, sellers, customer groups, discount groups, sales through the cash hall, the Internet, home delivery. The analysis of sales is made in natural and monetary value, the analysis of a margin, the analysis of the average check, etc. can be made. In the application comparison of sales of a current period with previous is also implemented; the choice of the periods is set by the user, it can be day, week, month, quarter, half-year, year. The developed Analysis of Sales application allows managers to trace quickly the most different performance indicators of activity of the company in the field of sales, making changes and adjusting a situation "on the fly". Analysts can conduct in-depth studies of data and calculations on all volume of the range numbering more than 7 thousand positions for all points of network at the same time and in a period of time of three years. Data source for a business intelligence is the accounting system 1C 7.7, however thanks to the innovation architecture of QlikView, tasks of the business analysis do not create load of an information system of the company and are not noticeable in work of operational employees.