First, let's talk about data analysis tools from data storage. When analyzing data, we need to store data first, and data storage is a very important thing. If we understand database technology and operate it well, we can improve the efficiency of data analysis. There are mainly the following tools for data storage.
1, MySQL database, which is necessary for database applications at department level or on the Internet. At this time, the key is to master the database structure and the data query ability of SQL language.
2, the latest version of SQL Server, for small and medium-sized enterprises, some large enterprises can also use SQL Server database. In fact, this time besides data storage, it also includes data reports and data analysis, and even data mining tools are included.
3. Both 3.DB2 and Oracle databases are large databases, mainly enterprise-level, especially suitable for large enterprises or large-scale data storage. Generally, large database companies provide very good data integration application platforms;
Let's talk about the data report layer first. Generally speaking, when enterprises store data, they must first solve the problem of reports. Only by solving the problem of the report can we correctly analyze the database. Data analysis tools used in data reporting include the following tools.
1, crystal report crystal report, bill report, these are the most popular report tools in the world, and they are very standardized report design ideas. In fact, most people understand the early business intelligence as a report system, and they can get all kinds of information of enterprises-reports without the help of IT technicians.
2. Tableau software, which is a great software in recent years. Of course, it is not a simple data report software, but a more visual data analysis software, because many people often use it to make reports and make visual analysis from the database.
The third is the data analysis layer. In fact, there are many analysis tools at this level. Of course, Excel is the most commonly used tool, and I often use statistical analysis and data mining tools.
1, Excel software, first of all, the higher the version, the better. Of course, for Excel, many people only master 5% of Excel functions, and Excel is very powerful, and can even complete all statistical analysis work! But I often say that learning statistical software is better than playing Excel as a statistical tool.
2.SPSS software: the current version is 18, and the name has also been changed to PASW statistics; I started programming and analyzing in Dos environment from 3.0, and the changes of the current version can also be seen in the changes of SPSS social science statistics software package. Starting from paying attention to medicine and chemistry, I have paid more and more attention to business analysis, and now it has become a predictive analysis software.
Finally, the presentation layer software. Generally speaking, the software of presentation layer is a very practical tool. The software of presentation layer is mentioned below.
1, PowerPoint software: Most people use PPT to write reports.
2, Visio, SmartDraw software: These are very useful flowcharts, marketing charts, maps, etc. And you can get many parts from here;
3.Swiff chart software: software for making charts and generating Flash.