Jun 21, 2022
In Welcome to the Forum
Secondly, please let me Whatsapp Database describe how I use Excel for exploratory analysis based on the above steps? The first 4 steps of this issue are mainly (clarification of problems, understanding data, data cleaning and data analysis, the rest please pay attention Whatsapp Database to the follow-up push). Practical report for this issue: transaction details and user information table of users who purchased babies on Taobao and Tmall; Data source: https://tianchi.aliyun.com/dataset/dataDetail?dataId=45 1. Clarify the problem After getting Whatsapp Database the data at hand, don't rush to do cleaning and analysis, but first brainstorm based on the information you have. Through this data, I/we can roughly determine what problems are, which can Whatsapp Database be listed in the brain map (such as Xmind). After many conjectures, they are sorted according to their importance. Why should we do it? The old saying goes: sharpening a knife is not a mistake for chopping wood, first understand the problem clearly, Which is conducive to later analysis, rather than rushing to get started, spending a lot of effort, and in the end it is sad to find that the conclusion drawn is in the opposite direction of the direction to be analyzed. Based on the existing information, the Whatsapp Database following problems to be verified can be assumed: Teach you to use Excel to do e-commerce data analysis 2. Understand the data The short video in Monkey Talk Data Whatsapp Database Analysis made a deep impression on me. She likened "understanding data" to "scallions, garlic, ginger" and other condiments prepared before cooking. For the big meal of data analysis, in the table For different fields, the meaning behind it must be clearly understood, otherwise the food will not taste right.