The foresight of big data analysis makes many companies as well as enterprises have started to use big data analysis to help the company's decision-making, and big data analysis is to analyze the massive amount of data, so it will have to take the help of some tools to analyze big data,. Generally speaking, there are many levels of data analysis work, these levels are data storage layer, data reporting layer, data analysis layer, data presentation layer. For different levels there are different tools for the work. The following editor will give you a good introduction to big data analysis tools.

First of all, we speak from the data storage data analysis tools. When we analyze data, we first need to store the data, data storage is a very important thing, if you know the database technology, and can operate the database technology, which can improve the efficiency of data analysis. And the tools for data storage are mainly the following tools.

1, MySQL database, this is necessary for departmental or Internet database applications, this time the key to master the database library structure and SQL language data query capabilities.

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 itself in addition to data storage, but also includes data reporting and data analysis, and even data mining tools are in it.

3, DB2, Oracle database are large databases, mainly enterprise-class, especially large enterprises or large-scale data storage needs is a must, the general large database companies provide very good data integration application platform;

Then the data reporting layer. Generally speaking, when the enterprise stored data, the first thing to do is to solve the problem of reporting. Solve the problem of reporting before you can properly analyze the database. The data analysis tools used about data reporting are the following tools.

1, Crystal Report Crystal Report, Bill reports, which are the world's most popular reporting tools, very standardized reporting design ideas, early business intelligence in fact, most people understand is the reporting system, without the help of IT technicians can get all kinds of information about the enterprise - reports.

2

2, Tableau software, this software is a great software in recent years, of course, it is no longer simply data reporting software, but more visual data analysis software, because many people often use it to report from the database and visual analysis.

The third said is the data analysis layer. This layer in fact, there are many analytical tools, of course, we most commonly used is Excel, I often use statistical analysis and data mining tools;

1, Excel software, first of all, the higher the version of the better to use this is certainly; of course, in terms of Excel many people just mastered 5% Excel function, Excel is very powerful, and even can complete all the statistical analysis work! But I also often say that the ability to play Excel as a statistical tool is not as good as specializing in statistical software;

2, SPSS software: the current version is 18, the name has been changed to PASW Statistics; I started from 3.0 Dos environment programmed to analyze the current version of the change can also be seen in the SPSS social sciences statistical software packages from the emphasis on medicine, chemistry, etc. began to pay more and more attention to business analysis, has now become a predictive analytics software.

Finally, the performance layer of the software. Generally the software for the presentation layer are very useful tools. The performance layer software is what is mentioned below.

1, PowerPoint software: most people use PPT to write reports.

2, Visio, SmartDraw software: these are very good to use flowcharts, marketing charts, maps, etc., and from here you can get a lot of parts;

3, Swiff Chart software: the software to create charts, generated Flash