30 + program veterans’ Transformation Road – tools (visual sugar)

Time:2021-7-17

Recently, I plan to learn something about data analysis. In the figure below, although there are a lot of advertising elements, there are many techniques. It is said that programmers should have a little product thinking and be sensitive to data.

30 + program veterans' Transformation Road - tools (visual sugar)
After reading the introduction of some training institutions, there are many knowledge points involved, including tools, thinking, practice and final report. Sure enough, you can’t be a fat man. Take your time.

30 + program veterans' Transformation Road - tools (visual sugar)

Excel and SQL should be the most basic30 + program veterans’ Transformation Path — tools (WPS + PostgreSQL)It is introduced in this paper

This time, let’s learn about data visualization. Tableau is a popular visualization software, but it needs to be downloaded and installed. In today’s SaaS fire, there are some more convenient alternatives.

Sugar is the agile BI and data visualization platform launched by Baidu intelligent cloud. By dragging and mapping the components, it can achieve 5 minutes to build data visualization pages, which are rich in components, open box, without SQL and any encoding. Through visual charts and powerful interactive analysis capabilities, enterprises can use sugar to effectively help their business decisions.

Now let’s try sugar

Prepare data source

We have prepared more than 300 CPU monitoring data. This is the exported CSV file

30 + program veterans' Transformation Road - tools (visual sugar)

We need to prepare a cloud database, which can provide the IP of the public network as the data source of sugar. Here I use a free cloud databaseMemFireDB

30 + program veterans' Transformation Road - tools (visual sugar)

Using dbeaver to import the CSV data into the cloud database, you can also insert and modify the data dynamically in the cloud database console or in the application

30 + program veterans' Transformation Road - tools (visual sugar)

Preview the data in dbeaver, and the import is successful

30 + program veterans' Transformation Road - tools (visual sugar)

Configure suager visualization screen

In data source management, create a data source, and fill in the cloud data service address, database name, and user name in the previous step

30 + program veterans' Transformation Road - tools (visual sugar)

In model management, create a model. Here we want to show a CPU history curve, select “timestamp” as the dimension, and select user utilization as the measure

30 + program veterans' Transformation Road - tools (visual sugar)

In the large screen management, configure the large screen, select the large screen template, click the line chart, and then you can select the configuration data. Here, you can select API for the data, or you can select the cloud database. Here, we select the data source of the cloud database that we just configured

30 + program veterans' Transformation Road - tools (visual sugar)

After configuration, we can preview the effect of line chart

30 + program veterans' Transformation Road - tools (visual sugar)

After the configuration is completed, click save. In the list of large screen management, you can choose to share the newly created data large screen to other netizens

30 + program veterans' Transformation Road - tools (visual sugar)

summary

Enjoy it again. App (user) writes data directly to the cloud database. Sugar can load data from the cloud database in real time for large screen display. We don’t need to install any local software or services. Isn’t it delicious!!! The charts we share will change with the data in the cloud database, and truly achieve dynamic visualization

30 + program veterans' Transformation Road - tools (visual sugar)