1. Data analysis step map
Questions → data preparation → data cleaning → model building → data visualization
2. Necessary skills of data analyst
Basic knowledge of data analysis + analysis tools + analysis methods
3. Data analyst capability system
Quick learning ability;
Communication and coordination skills;
Business understanding ability;
Analysis tool use ability, etc.
4. Data analysis business flow chart
Requirements layer: Identify goals
Data layer: get, clean and organize data
Analysis layer: Analyze data
Output layer: data visualization and data report writing
5. Core topics of data analysis
User portrait, preferences, activity level;
Product performance and characteristics;
Advertising search, traffic channels.
6. Sorting out common data analysis indicators
7. Regression analysis method
8. Statistical knowledge system
9. Common Excel formulas
Mysql learning path
Follow these 10 knowledge brain maps to get you started on data analysis, but to really learn more, you need to read professional books and data analysis examples, which I’ve shared in previous posts.
This article is hard dry goods, hurry to collect, in case of need!