Shanghai Xianfeng Network believes that whether it is data analysis, statistical analysis, data mining, or business intelligence, you need to master various analysis methods and skills when learning, especially analysis software tools!

When learning data analysis, you usually start by learning the software first, then apply it, and then learn the theory and principles!

If there is no software method, don’t learn it, because you can’t do it even if you learn it, unless you can program it yourself.

The idea is to look at the X and Y axes: First dimension: Data storage layer -> Data report layer -> Data analysis layer -> Data presentation layer Second dimension: User level -> Department level -> Enterprise level -

BI level first. Storage layer: 1. Access2003, Access07, etc.: the most basic personal database; 2. MySQL database; 3. SQL Server 2005 or higher; 4. DB2, Oracle; 5. BI level (actually this is not

The database is built on the basis of the previous database. This is mainly the enterprise application level of the database. Generally, the databases at this time are called data warehouses. Data Warehouse. Data storage built on the DW level is basically business intelligence.

The platform may integrate various data analysis, reports, analysis and display! ) Second: The report layer recommends Shitou’s favorite two.

1. Crystal Report Crystal Report Bill Report 2. Tableau software Third: Data analysis layer 1. Excel software (it is better to learn statistical software than to use Excel as a statistical tool); 2. SPSS software: start by paying attention to medicine, chemistry, etc.

There is an increasing emphasis on business analytics, which has now become predictive analytics software.

3. Clementine software.