What do bi data analysts need to learn?

You need to learn to use SQL and R languages.

If you want to learn data analysis, don’t rush to learn programming technology first. Learn excel first. Really learn excel. Once you are proficient in the operation, you can do commonly used function formulas, pivot tables, filtering, and sorting. , chart drawing, then learn SQL, and finally learn R/python. As the saying goes, "Before you learn to walk, you want to learn to run."

First of all, Excel is our most commonly used data analysis and processing tool. When we start to learn from Excel, we must first learn to walk. Excel is very rich in functions and can basically cover what we will later use in other software (SQL, R , those functions to learn in Python). Some people may ask, since Excel is so powerful, why do you need to learn other tools?

This is because Excel operates through menus, and it is difficult to realize automation and function reuse. Of course, you can also do it through VBA. Using VBA is programming, but because VBA After learning this language, you can basically only use it in office software. The input cost of learning is not proportional to the output benefits. Learning is not recommended. This is one of the objective reasons;

In addition, Excel is not suitable for processing relatively large tasks. Data set performance is poor and crashes frequently. (Although Excel 2013 and above claims to be able to accommodate 1 million records, tens of thousands of data begin to lag).

Of course, Excel is not enough. SQL is the basis of data analysis.

The objective reason is that most data analysis position recruitment requires SQL skills. The reason for this phenomenon is that in order to ensure the security of data and the convenience of management, the data is stored uniformly in the database. In, extracting and querying data from the database requires the use of SQL language, and some companies use SQL language for data analysis.

Another reason is that even if you learn other tools first, such as R, Python, or even big data frameworks such as Spark, you will find that you still have to learn SQL in the end. If you learn SQL first, you can figure out many concepts before learning more complex tools such as R, Python, Spark, etc. It will be helpful for future study. This is like building a house. You lay the foundation first and then build it layer by layer. Of course, there are also masters who build the house from top to bottom. That kind of house is not an ordinary house, and it has nothing to do with us ordinary people.

Of course, if you feel that learning programming is too complicated and you want to learn it quickly and create beautiful visualizations without writing a programming language, then try Smartbi. It is free to use and the operation is very simple and user-friendly. change.