Data analysis learning

The best way to practice is to follow the company's business, and learning is also the fastest, because there is demand, pressure and motivation to accomplish a thing, through 2 weeks of study.

As an entry-level business analyst, it is very important to show a visual business. To achieve such an effect, you need to have:

1. Database

In practice, there are such databases, such as MySQL,PG,MongoDB,Infobright, which have absolute advantages as DBA, and business SQL optimization is not available to general analysts.

2. Professional skills

1. Master the five-step method of data warehouse design

2. Understand the concept of ETL, ETL tools, etc.

3. Master basic definitions, such as fact table, dimension table, etc.

4. Master some development languages as a means of database cleaning, such as python

5. Use POWER BI visual interface or EXCEL tools

6. understand the theory of statistics, such as comparison, etc. (you can not use it in the early stage)

3. Business design

1. Business design

2. report design by using professional tools.

4. Learning ability

1. From A to B, you need a stage, and the best one is for the purpose of actual business requirements. According to the design model of the whole project, understand the information of the data, the positive and negative of the data can be established, and the accuracy of the data display.

2. Official material learning, https://msdn.microsoft.com/zh-cn/library/ff452213.aspx based on WINDOWS can be used as the basis for entry.

3. Reinforcement learning

5. Visual display

Data visualization is the visual representation of creating and studying data. Through the combination of different dimensions of data, data analysis and results are made into pattern reports.