Data analysts need to learn statistics, programming skills, databases, data analysis methods, data analysis tools, etc. , but also skilled in using Excel, familiar with and proficient in at least one data mining tool and language, have the ability to write reports, and have a solid SQL foundation.

1, mathematical knowledge

Mathematical knowledge is the basic knowledge of data analysts. For junior data analysts, it is enough to know some basic contents related to descriptive statistics and have certain formula calculation ability, and it is better to know commonly used statistical model algorithms.

2. Analytical tools

For junior data analysts, you need to be able to play Excel and skillfully use pivot tables and formulas, VBA is better. In addition, you must learn a statistical analysis tool, and SPSS is better as an introduction.

For senior data analysts, using analytical tools is the core competence, VBA is the basic necessity, SPSS/SAS/R should be proficient in using at least one of them, and other analytical tools (such as Matlab) depend on the situation.

3. Programming language

For junior data analysts, you can write SQL queries, Hadoop and Hive queries if necessary, basically. For senior data analysts, besides SQL, they also need to learn Python, which is used to acquire and process data, and get twice the result with half the effort. Of course, other programming languages are also possible.

Data analyst can be engaged in: IT system analyst, data scientist, operation analyst and data engineer.

See: /catlist-3.html/ for more vocational education and training? utm_campaign=baiduhehuoren