The bosses of the above small companies have given us a deep understanding of the essence of the data indicator system from a very professional perspective. Next, I will talk about some of my immature ideas about why we need to establish a data indicator system~ 1. Business perspective For our product managers, the process of establishing a data indicator system can be said to be a process of enhancing product value! Because we can sort out and understand the business more comprehensively and systematically from another angle, and then rethink and enhance the value of the product! For our product users, such as sales or operations, data indicators are the basis for guiding the business direction, and the system ensures that the entire.
Business can be viewed from a mobile number list multi-dimensional and all-round God's perspective, and various problems have been discovered. , can be traced back to the source! There are not a few students who are crushed by data. If there is no system, various reports will gradually increase with product iteration, and then it will become more and more difficult for business students to find data when analyzing specific problems. Spend a lot of time in the quagmire of constantly looking for data and checking indicators. 2. Technical point of view When the product was first used, all the required indicator data were queried from various basic tables through SQL statements, developed and written SQL, and then the system ran SQL every day and it was done.
But with the passage of time, there are more and more various data indicators, and SQL can no longer run. However, you will find that similar indicators are actually used in many places, which may have different dimensions or may be exactly the same. At this time, it is necessary to sublimate the plan and refine the SQL statement to the calculation of indicators, which leads to another concept: data warehouse . From a business point of view, it is a data indicator system, and from a technical point of view, it is a data warehouse! 4. How should the data indicator system be built? In the specific part of doing things, I am usually goal-oriented. The goal of the data indicator system in the workflow is to build a data warehouse! In order to achieve this goal, we have to do a few things.