Based on actual work cases, the author of this article introduces the processes and tools that data product managers need to pay attention to in the bulk sms service process of building a data platform, and share them with you. The construction of the 2B/2G data platform is consistent with the general software development process, but the particularity is reflected in users and data. Taking a data monitoring platform made before as an example, taking the data as the center, we will introduce the tools used by Data PM in the development of the entire data platform and the data processing process that needs to be focused on. 1. Common data analysis tools 1. Data Analysis Tools Orange: Visual data bulk sms service mining tool, no coding required; SPSS: data statistics software, requires strong data analysis ability; Excel: data statistics software, requires entry-level data analysis ability;
Data Source Tool Baidu Index: data sharing platform, only for PM reference, no open API; Octopus: Crawler tool, only for PM reference, only supports bulk sms service windows platform; 3. Data Display Tool : data visualization plug-in, with its own code, which can be shared with technicians; Tableau: Data visualization analysis, display, pre-designed dynamic data interface; Easy word cloud: word cloud generator, word cloud style is rich. 2. Key data processing process 1. Process overview Key data extraction data collection Data evaluation and operation and maintenance Data Display 2. Specific implementation (1) Key data extraction We extract key data in order to form data indicators. Based on the suggestions of other senior data products and our own development experience, here is a relatively comprehensive and practical construction method of data indicators: Data indicator = indicator name + business bulk sms service category + dimension + summary method + measurement + associated dimension + time In the
Process of extracting key data, that is, establishing data indicators, the product needs to further sort out the business logic of product mapping bulk sms service and design the underlying data analysis strategy of the product. At the same time, based on this, it can also assist technical developers to open up data table creation ideas for background database construction (including data warehouse construction). To establish data indicators, it is necessary to focus on grasping business categories and dimensions—— Business categories, on the one hand, can be sorted out directly bulk sms service according to the actual business logic of B/G clients, and on the other hand, it comes from the content of demand analysis in the early stage of product development—other needs other than business needs,