Introduction to data analysis needs to master:

1, SQL (database): get data from the database, get the specific data you want, etc. Are the primary consideration, and these problems are solved by SQL, so SQL is the most basic skill of data analysis.

2.excel: Analysts mostly analyze data. When analyzing data, they need to put the data into a file, and this file is excel. Proficient in excel common formulas, learn to make pivot tables, and draw charts for any data.

3. The foundation of 3.Python or R: required option, plus points, is a required option in the direction of data mining, and language is more flexible and practical than tools.

4. Learn a visualization tool: If you want to develop to a higher level, the above things only account for 20% at most, and the remaining 80% is the ability to understand business, decompose goals, and learn more new skills according to data requirements.

Extended data:

Perhaps the most important thing in data analysis is not your familiar programming tools, analysis software, or statistical knowledge, but to know the principles, assumptions and limitations behind the statistical knowledge you use (statistics, metrology, time series, nonparametric, etc.). ), know what various data analysis tools (such as data mining) can and can't bring, see the results of a set of statistical tests, and see what you can and can't say.

Behind all this, you need a complete "scientific" logical framework, so that you can understand the nature of the tools in your hand, and you can correctly find effective information from the data, instead of randomly piling up the analysis results with a lot of tools you don't know, which is not only useless, but also harmful.

Baidu Encyclopedia-Data Analyst