How to write a data analysis report

1. Overview

How to complete a data analysis project and write a data analysis report?

2. Operation steps

2.1 Determine analysis goals

Before performing the analysis, determine the purpose of the report analysis. If there is no clear problem at the beginning, start the analysis, which can easily lead to the analysis for a long time but the goal is getting farther and farther away. Therefore, defining the problem to be studied is the first step in data analysis.

2.2 Problems found in dismantling indicators

What if you already know your analysis goals, but have no ideas?

You need to disassemble your analysis goals. For details, please refer to: Data Analysis Index Split.

2.3 Draw conclusions

The same conclusions we give need to be closely linked to the purpose of the analysis, such as:

• The purpose is to understand the current situation of the business, the conclusion can be: the business has x key indicators, and the value of each indicator is xxx, what are the abnormalities;

• The purpose is to understand what data is considered good, the conclusion can be: a certain indicator can be judged by xxx, the reason is...;

• The purpose is to find out the cause of the business abnormality, the conclusion can be: After analysis, there are x reasons, of which the key reason is...;

It should be noted that if it is to judge the status of the business, a judgment standard needs to be judged: conclusion = data + judgment standard.

In the process of disassembling and analyzing the data, we can already detect some data anomalies. But whether these abnormalities are good or bad, we need to pass a standard to determine.

For example, if the sales data fell in October, we can increase the comparison with last year's data. If it also declined last year, it means a normal monthly decline. If there was no decline last year, then the decline this year is an abnormal phenomenon and needs to be re-examined.

2.4 Combining business, give suggestions and plans

If data cannot drive business growth, it is useless.

After drawing a conclusion, combined with the understanding of the business, you can make suggestions on the analysis results, and even give solutions:

• The suggestion is: the direction of action that can solve the business problem is a number of potentially feasible categories.

• The plan is: a specific action plan, the plan must meet 5w2h, there must be specific executors, completion time and other elements.

2.5 Write analysis reports

After the above preparations are completed, how to write an analysis report to increase its readability?

• The structure is clear: refer to the classic pyramid structure, the conclusion first, the above is the same, the first is important and then the second. The above order is also in line with the order of dismantling indicators in the data analysis process, and it is easier to help readers understand your analysis ideas;

• Graphical report: Replacing a large number of stacked figures with charts will help people see the problems and conclusions more vividly and intuitively, making it easier to be justified;

• Standardization: the chart style and nouns of the entire document are unified.