Crisis Analysis
Managers usually analyze data from different perspectives to obtain different information. For example, table 1 is the most common sales analysis.
It should be said that this table is doing a good job. It gives the comprehensive operation of each branch in a certain period of time. However, if you want to use this table to reflect the business benefits of a certain period of time
The details of the business can only be combined to view the daily business situation. In this way, we will say that we are too tired. As a result, a time-based analysis table is generated (see the sales score ).
Analysis table 2 ).
Although the date is clearly expressed in this table, the store information is not comprehensive, and the elders are not satisfied, so the next table is generated (see sales analysis table 3 ).
This table is based on the date. Apart from a little longer, the boss is quite satisfied. Can we take the branch as the clue? IT experts said, of course. Good, and new sales
Table 4.
"This is good," IT experts said. "I have met various requirements of the boss !" The boss found a fatal defect in the table, and the sales analysis table did not have any category score.
Analysis. How can this be done! As a result, IT experts developed a classification sales table. After the classified sales table was created, the boss thought it was too long and hoped that only the analysis of the category would be available. So it experts designed the category
Sales table, medium sales table, small sales table, etc. Finally, the boss wants to add the branch and date respectively. In addition, the boss also asked to join the year-on-year comparison and period-over-period comparison. IT expert or it Integration
In the end, the vendors will feel that the analysis reports requested by the boss or managers are endless. Even if they finish the analysis as required, the managers still feel bad, because they do not think about the analysis.
It is continuous and has no fun.
This is the analysis crisis of the retail industry. CEOs are increasingly fond of analysis, but the IT Department is increasingly unable to perform analysis!
The preceding example only selects different viewing angles. In Bi, we call them "dimensions", that is, the date dimension, the earth dimension, and the category dimension, which are classified. For example
The date can be divided into years, months, weeks, and days, and the place can be divided into the company, Branch, Department, and cabinet group. The category can also be divided into categories, middle categories, sub-categories, sub-categories, and series.
Business Intelligence
Bi is a new technology that uses data warehouse, online analysis, and data mining technologies to process and analyze data.
The working principle of Bi is to generate a variety of display data that can be dialysis by extracting, cleaning, clustering, mining, and prediction data. The data can be intuitively displayed.
A certain business attribute or market rule that the analyst wants to inquire about.
A good Bi tool can drill up and down for different "dimensions", drag left and right, and rotate vertically and vertically. It presents various data through a continuous three-dimensional dynamic table, and clusters and arranges the data.
Processing such as sequencing brings a new sense of handy analysis to managers.
In addition to dynamically displaying data, Bi can also be displayed through a variety of images. It can also be used to stretch, block, rotate, pivot, and other operations on the image for a more intuitive and
See the method to show the rule. At the same time, you can also make various marks on the data, such as good sales data in green, especially poor sales in red, etc. It can also track the data
Analysis.
Win the future
What do we rely on to win the future? It is the experience and lessons learned from the analysis of historical business operations, and the use of data to prove the success of business means to predict future development trends and quickly
Accurately grasp the changing market pulse. Bi is a powerful weapon to accomplish this mission. In foreign countries, Bi has been well applied in the retail industry, and relevant index system theories have been generated.
In China, although Bi is still in its infancy, its flexibility and powerful functions make it a rapid rise in the retail industry.