What is the data analysis method on the tall?

What is the data analysis method on the tall?

Huang Chengming Source: Public Number _ Data management (SJHGLWX)

Often received some two or three years of graduation friends letter, this is a confused period. They study in the university is a variety of high data analysis methods, but the actual work is to do some only need to subtract and subtract the statistical work. They have the ideal, want to drive out their own business, want to dig out another "beer and urine not wet" (Note: This is a classic data mining case, do not know the degree Niang).

I have received a private message today:

Some friends may think my answer is too water, not a bit of technical content. Perhaps, the vision is different, the understanding nature is different. Beer and urine are not wet, and the statistical methods of the minus and minus are often used to see how you use them.

I repeat this sentence every time I give training to trainees:

The next sentence of this sentence is not deliberately to find the tall on the analysis method, and to deliberately go to the common analysis method to play the feeling of the tall.

Next I use the leaderboard analysis method to illustrate:

The leaderboard analysis is a kind of analytic method that I often talk about, a lot of people will think the leaderboard is what analytic method? In fact, it has been said that data analysis is based on practical principles. Whether it's a complex approach or a simple approach, it's a good way to help your business-level approach! The leaderboard is the simplest and most popular analysis method, in the Baidu News "28 law" has 37,600 articles, and Baidu "leaderboard" unexpectedly can find 39.2 million articles! The popularity of the leaderboard is visible.

Leaderboards exist in various types of analysis, various media reports, such as commodity rankings, sales rankings, Forbes rankings, Chinese universities rankings, Baidu Index rankings and so on. Forbes is famous for its various economic and commercial rankings.

This is one of my analysis template "Monthly Sales Analysis template" Inside a leaderboard, can be ranked by time-Object-indicator three dimensions, each dimension has a lot of granularity to subdivide, eventually found the problem. Isn't it a little tall on? A picture can cover the main analysis path.

This is a template made using Excel control technology.

Leaderboard analysis can also continue to deepen, let it more business, this is my monthly analysis template inside a picture (each value represents the store in 100 stores in the rankings). A picture can understand the short board and advantages of this shop, at a glance, simple and practical. No one can deny that this is not a leaderboard analysis method.

Look at the last picture, the unit price of the heat, it is a variation of the leaderboard. Look at this kind of picture will have a kind of fight jiangchang the scene feeling, forcing lattice is very high.

These three charts are the leaderboard analysis method, all pure Excel, plus the control technology can achieve high interactivity, let a picture of the whole picture.

Therefore, the data analysis is not to look for the analysis method on the tall, but to the common analysis method of business!

What is the data analysis method on the tall?