CPDA | first learn data analysis tools or data analysis thinking?

CPDA| First learn data analysis tools or data analysis thinking ？

For those who are just getting started with data analysis , I don't know if it's a tool to learn data analysis first , It is still necessary to master the thinking and methods of data analysis , Even tangled , Is it important to learn data analysis tools or data thinking ？

First , Need to recognize an idea , Data analysis is an ability , Not a position .

then , Let's take a look at the daily workflow of data analysts ：
For example, the company has a APP, At ordinary times “ Diurnal activity ” Stable at 9W-10W Between , however 10 month 26 The sun suddenly fell 8.8W, To 10 month 27 The sun fell 8.5W, At this time, the person in charge of the product is in a hurry , Data analysts are needed to investigate the reasons for the decline in the next day .

On receiving this task , Data analysts began to have a rudiment of an analysis framework ：“ Diurnal activity ” How much has the index fallen ？ It's a fall in the normal range ？ Or a sudden decline ？（What） It's the overall decline in users , Or some users ？（Who） When did the decline start ？（When） What causes the decline ？ It is the expiration of the promotion of a certain channel ？ Or is the product update causing login problems ？（Why）

Next , Will extract recent data from the database , Data extraction involves SQL.
Data cleaning and analysis use Excel.

After data extraction , Will do specific analysis , When it comes to analysis, statistical knowledge and data analysis methodology will be used .
such as ： How much has it fallen this week compared with last week ？ Here comes the concept of month on month in Statistics , There are also comparative analysis methods .
After finding out the reason , Will propose solutions , Promote the implementation of product departments . In the process of communication and presentation , May use PPT.

According to the above working scenario , We can come to a conclusion ： Both data analysis tools and data analysis thinking need to be learned at the same time , But the thinking and method of data analysis is more important .
If you only learn tools , But it will not be applied or there is no analysis idea in the actual working scenario , It can be deadly .
It's like buying a pile of ingredients , But I can't do . If you learn analytical methods , But I don't know how to extract and analyze data , It's like having a recipe in your hand , But the food can't be taken out in the refrigerator .

The work of data analysts will not be separated from the business in the end , Every step of execution and thinking requires the use of tools and the application of data analysis methodology , You can't have one without the other .