1. Business is the core, data is the king

- Understand the structure of the entire industrial chain

- Formulate a good business development plan

- Understand the core indicators of measurement

With data must be combined with the business in order to be effective.

You need to understand the overall overview of the business, map out the entire structure of the industry chain where you are located, and have a general understanding of the industry's upstream and downstream operations. Then according to the current needs of the business, specify the development plan, so as to categorize the data that need to be organized. The last step lists the data core indicators (KPIs) in detail, and carries out a more detailed dismantling of several core indicators, of course, specifically combined with your business attributes to deal with, to find out those impact factors that have a greater magnitude of impact on the indicators. It's critical to have a thorough understanding of the current state of your business and the information you're collecting up front.

2. Think about the current status of the indicators and discover multi-dimensional patterns

- Familiarize yourself with the product framework and comprehensively define the operational status of each indicator

- Compare the indicators with those of the same industry and dig out the hidden room for improvement

- Dismantle the key indicators and reasonably set up operational methods to observe the effects

- Compete with the core users and individually carry out the product research and demand excavation

- Conduct the product research and demand excavation

- Conquer the core users and individually carry out the product research and demand excavation. Mining

Business analysis is mostly qualitative and requires the development of a sense of objectivity. Qualitative analysis requires the use of technology, tools, and machines. And the cultivation of feeling, because everyone's thinking and perception are different, can only control the general direction, many of the relationships between data elements still need to be achieved through data visualization technology.

3. Validation of the law, experience

After the discovery of the law can not be immediately online, you need to verify the model on the test machine.

Skills

1. Excel is fine drill?

In addition to commonly used Excel functions (sum, average, if, countifs, sumifs, offset, match, index, etc.), Excel charts (pie charts, line charts, bar charts, radar charts, etc.) and simple analytical skills are also often used to help you quickly analyze the business trends and abnormalities; In addition, Excel inside the function combined with the pivot table and VBA function is to improve the report development tool, so that you can easily get the report with one click.

2. You need to know more about the database

Commonly used databases such as MySQL, Sql Server, Oracle, DB2, MongoDB, etc.; in addition to the proficiency of the use of SQL statements, for the database of the storage and reading process to be mastered. In the processing of large amounts of data, how to find ways to speed up the operation of the program, reduce network traffic, improve the security of the database is very necessary.

3. Master data organization, visualization and report production

Data organization, is to convert raw data into a convenient and practical format, practical tools such as Excel, R, Python and other tools. Data visualization, is to create and study the visual representation of the data, to facilitate the business side to quickly analyze the data and locate specific problems, practical tools are Tableau, FineBI, Qlikview.

If the commonly used excel, then you need to use PPT to show, this skill also needs to be mulled over. If you use tableau, FineBI and other tools to do data visualization, FineBI has a push to view the function, that is, in the enterprise up and down the establishment of a system, through the distribution of rights to allow different people to see the report within the scope of the rights.

4. Learn a few more skills

Most according to analysts are from the computer, math, statistics and these professions, which means that mathematical knowledge is an important foundation. Statistics, in particular, is the basic skills of data analysts, from data collection, sampling to the specific analysis of the validation of the exploration and prediction should be used statistics.

Social psychology is now also gradually included in the data analyst's ability to system, especially engaged in the Internet product operation students, need to understand the user's behavioral trends, analysis of the motivation behind. After grasping the overall direction, the process of data analysis is easier.