Next, Liang Ning thought about the series of courses. This course is about the system capabilities of products. After the class, she left homework as follows: Pick a product you are most familiar with, and tell me what kind of certain satisfaction it should provide to users? Did this product do it? If not, what do you think the problem is? Continued gratification is dependence, and uncertainty is hurt. Can you tell me, are you sure when you were hurt? Before writing homework, let's learn about Liang Ning's terminology in this class: When you say you want to make a product, what you need is to build a set of system capabilities; Certainty is important. Life is so uncertain, so when you see something that is very certain, it makes people nostalgic and dependent. Continuing to provide certainty that users can rely on is the key; Today, we will focus on the work arranged by Liang Ning, and then we will discuss data visualization products (more precisely, "data visualization services") from the two aspects of "system capability" and "determinism". 1. How to perform data services? System Capabilities of Data Visualization Products In fact, in "How to realize data visualization.
In the article, the system of data products was introduced, which is mainly divided into: data storage layer , data calculation layer , and data display layer (as shown in the figure below). At that time, only the terms of each level of the system were explained, but how do the various levels of the system as a whole work to perform data services? As business personnel, the mobile number list most intuitive service of data visualization products for them is the graphical display of data. From a literal point of view, the entire system consists of two parts: data for business scenarios + the ability to graph data . 1. Data for business scenarios In the actual work scenario of an enterprise, data is scattered in different storages, such as log data, buried point data, and server-side data. However, if these data are not processed, it is almost impossible to meet the needs of the business, so the data warehouse is mentioned here .
In BI tools, the visualized data comes from a data set (you can understand it as a data table that meets the analysis needs of the business side and covers all its indicators and dimensions), and the data set is directly referenced or aggregated in the calculation data warehouse. data sheet. Let’s talk about the data tables in the data warehouse. Maybe you have heard the data warehouse hierarchical structure such as ods, dwd, dws, and adm. In fact, in addition to these technical contents, the data warehouse has one more thing to understand: it requires data warehouse engineers to follow the business Structure creation . In the actual work scenario of the enterprise, engineers rely on the data mapping table (also known as datamapping ) organized by data products to create a data warehouse . Table) is organized and modeled through the existing data in the system (the indicators in the data mapping table may need to be obtained through the fields of multiple tables and through complex mathematical calculations), and one or more data tables that meet the analysis needs are stored in the in the data warehouse.