Many students are confused: What exactly is a data analysis method? Because some of the descriptions of data analysis methods on the Internet are plagiarized from marketing books, such as 4Ps and PEST; some are plagiarized from statistics books, such as correlation analysis and regression analysis. But when it comes to doing the analysis, they are dumbfounded: Should we use P or regression to solve the problem at hand? If you want to truly understand and master data analysis methods, you can't just " find nails with a hammer ". Data analysis at work must be closely integrated with business and serve business needs. Therefore, only by understanding business needs and finding answers around problems can you understand the uses of various data analysis methods and how to use them. 1. Six typical business requirementsA complete business activity is divided into six steps: understand the current situation → set goals → make plans → monitor trends → diagnose problems → review results . At each stage, the information the business has and the problems it wants to solve are different, so the demand for data will be different (as shown in the figure below). If data analysts are involved in the work starting from the formulation of the annual business plan, they will go through all six steps. However, many students join the job midway through their career. The most common ones are:
At this point, it is very likely that the data analyst is not familiar with the business and is rushing to do something without any ideas. At this point, at least the first step, understanding the current state of the business, must be completed before taking appropriate measures. 2. Methods for understanding the current situationIn the stage of understanding the current situation, data indicators are presented systematically to let the business see the situation clearly. The data indicator system itself has three structures: parallel, process, and total score . Some common analysis methods correspond to these three forms. For example:
It should be noted that simply displaying indicators does not lead to any analytical conclusions. At least the indicators should be displayed + comparisons between different individuals . For example:
Therefore, when understanding the current situation, don’t just think about listing a bunch of indicators, but think about: who should be selected for comparison to better discover the differences between businesses and inspire the business department to think. 3. Methods of setting goalsDuring the goal setting phase, it is likely that the business will want to know:
This is where the problem of prediction comes in. To predict natural development trends, time series methods are generally used. Depending on the data trend, there are smoothing methods, autoregression, seasonal regression, regression with seasonal trends, and other methods available. If you consider changing resource inputs, you can consider regression with causality. Because there is generally a functional relationship between input and output, the input-output curve can be fitted through data to simulate the adjustment results. If you want to change your business practices, you must first check whether the business has taken similar measures. If there are similar practices, you can refer to the input-output situation of similar practices for calculation. If you have never done it, you must do a test first, otherwise you will just make a guess without data. It should be noted that when setting goals, it is often necessary to reflect the ideas of the leaders, and the data itself is only a reference. Therefore, it is very likely that after the natural situation forecast is completed, the business department will start to make decisions based on their own ideas. At this time, complex analysis methods may not be needed, but the data indicator system can be used to disassemble the KPI indicators, and then the relevant indicators can be increased or decreased according to the requirements of the leaders to simulate possible results. 4. Methods of making plansDuring the planning stage, the business may want to break down a big goal into specific execution tasks. At this time, the OGSM method can be used, which is a standard method for implementing qualitative goals into quantitative goals, breaking down quantitative goals into execution steps, and then monitoring execution (as shown below). It is also possible that the business does not want to dismantle it by itself first, but wants to see what the theoretical optimal solution is under the current input-output level. At this time, you can build an input-cost function and use cost-volume-profit analysis/linear programming methods to calculate the theoretical optimal solution for business reference (as shown below). Just like setting goals, when making plans, it is very likely that the business will rely entirely on experience, guess a number and start working. A plan that is too rough will lead to: unreasonable execution arrangements, temporary adjustments, and lack of backup plans, all of which will lead to problems in the execution process. If data analysts can understand the situation in advance, it will be much easier for them to monitor the trend in the next step. 5. Methods of monitoring trendsIn the trend monitoring stage, the core task is to observe whether the business is developing within expectations and whether there are abnormal fluctuations. Therefore, data analysis methods are needed to determine whether the business is normal. At this time, there are five methods available: cyclical analysis, input-output analysis, structural analysis, hierarchical analysis, and matrix analysis.
When monitoring trends, these conventional methods can be combined with monitoring indicators to form the same monitoring data dashboard. After observing abnormalities in the main indicators, you can directly view the data from the overall to the specific to see which part has a problem, thereby greatly improving the efficiency of discovering problems. 6. Problem Diagnosis MethodsIn the process of diagnosing a problem, whether there is a business hypothesis is the most critical.
Although when it comes to problem diagnosis, people will instinctively think of: building a logic tree. However, building a complete logic tree is too time-consuming and laborious, and many assumptions need to collect external data for verification. In real work, there is not always such sufficient data supply. Therefore, when diagnosing a problem, try to find business assumptions first and output conclusions quickly. When validating business hypotheses, whether or not to conduct experiments is the most critical difference:
7. Methods for reviewing resultsIf the first five steps are done well, it will be very easy to review the results:
Such a comprehensive review of the results is very comprehensive, including both the statement of results and the summary of experience. Many students find it very troublesome to review the process because they are not involved in the whole process and are only assigned the task of reviewing after the activity is over. At this time, they do not understand the goal and the process, so they have to review the process from beginning to end to get the result. If the business does not set clear goals and does not monitor the process data, they will be in the dark. Author: Down-to-earth Teacher Chen; Source Public Account: Down-to-earth Teacher Chen (ID: 773891) |
<<: Are social media ads really useful? We found these 17 key indicators
The author wants to use this article on the KOC op...
In the cross-border e-commerce industry, the indep...
As the Amazon platform continues to grow, more and...
The corporate strategy house is a basic requiremen...
Bilibili announced that it will use the number of ...
This article mainly introduces a marketing strateg...
After we open a store on Shopee, we need to upload...
Many human behaviors are controlled by the subcons...
Everyone has various needs, and when the needs are...
Every year after Thanksgiving, the United States w...
In the new trend of live streaming sales, "ab...
Foreign trade merchants need to prepare a collecti...
This year's job market has clearly kept salari...
In our country, the mainstream shopping websites a...
Shopee platform, like other platforms, actually ha...