As an entry-level tool, Excel is the most basic and main data analysis tool. Can process all kinds of data, make statistical analysis and assist decision-making. PivotChart is the most important tool in Excel. If performance and data volume are not considered, it can handle most analysis work. The so-called primary school chart, middle school function pivot table, advanced learning VBA. The powerful function of EXCEL is only known to those who have really studied it.
2、SQL
It is no exaggeration to say that SQL is a necessary skill for all positions in data direction, and it is relatively easy to get started. In a nutshell, it is to add, delete and change queries. The knowledge points that SQL needs to master mainly include data definition language, data operation language and data control language. In the data manipulation language, understand the execution order and syntax order of SQL, master the important functions in SQL skillfully, and understand the similarities and differences of various join in SQL. In a word, SQL is a necessary skill for data analysis.
3. Smartphones
Smartbi is a professional bi tool, which realizes auxiliary functions such as data collection, query, report, self-help analysis, multi-dimensional analysis, mobile analysis, dashboard and data mining based on a unified architecture, and has the characteristics of report analysis and voice analysis combined with AI. With a history of more than ten years, it is the most comprehensive, mature and stable product in domestic BI software. Widely used in finance, government, telecommunications, enterprises and institutions and other fields. Perfect online documents and teaching videos are easy to use.
4, the picture
Tableau is similar to the data perspective of Excel. You can directly select row and column labels with the mouse to generate various graphs and charts. But the design, color and operation interface of Tableau give people a simple and fresh feeling, and the drawings made are more beautiful than excel.
5、SPSS
The operation of SPSS interface is relatively simple. As long as you know the basic interface and functions of the software and prepare data input for analysis, the software will automatically calculate the analysis results for you. However, if you want to read through the analysis results given by SPSS, you need solid statistical knowledge. Focusing on statistical analysis models can solve most statistical problems.