What is a data analysis workflow?

Literally, it is to obtain data. Data acquisition seems simple, but it needs to grasp the business's understanding of the problem and turn it into a data problem to solve it. To put it bluntly, what data is needed, from which angles to analyze, and then collect data after clarifying the problem. This link requires data analysts to have structured logical thinking.

2. Data processing

Data processing needs to master efficient tools, such as Excel and SQL. Excel and high-end skills: basic operation, function formula, pivot table, VBA program development.

Step 3 analyze the data

Analysis of data often requires various statistical analysis models, such as association rules, clustering, classification, prediction models and so on. Therefore, it is inevitable to master some statistical analysis tools skillfully. We can learn SPSS, which is easy to learn without programming. Very suitable for beginners, and the classic mining software needs programming. R language open source software, which is new and popular, needs programming to deal with unstructured data more effectively.

4. Data visualization

At present, many data analysis tools have covered the data visualization part, and only need to effectively present and report the data results. Show your leader a series of jobs you have done before.