Recently I plan to learn some data analysis content. Although there are a lot of advertisements in the picture below, many skills do not matter to me. They all say that programmers should have a little product thinking and be sensitive to data.

I have read the introduction of some training institutions, which involves a lot of knowledge, including tools, thinking, practical operation and the final report. You can’t eat a fat man in one mouthful, so learn it slowly.

Excel and SQL should be the most basic, which was introduced in the previous 30+ program veteran transition path — tools (WPS+PostgreSQL)

Tableau is a popular visualization software, but you need to download and install it. In today’s SaaS era, there are some more convenient alternatives.

Sugar is an agile BI and data visualization platform launched by Baidu Intelligent Cloud. It can build a data visualization page in 5 minutes by dragging and dropping chart components. It has rich components and can be used out of the box without SQL or any coding. With visual charts and powerful interactive analysis capabilities, organizations can use Sugar to effectively facilitate their business decisions.

Let’s try out Sugar

Prepare the data source

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

We need to prepare a cloud database that can provide the IP of the public network to be used as the data source for Sugar. Here I used a free cloud database called MemfireDB

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

Preview the data in dbeaver and the import is successful

Configure the large Suager visual screen

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

In model management, create a model, here we want to show a CPU history curve, select “timestamp” as the dimension, select user utilization as the metric value

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 choose API or cloud database. Here, you can select the cloud database data source you just configured

The configuration is complete and we can preview the line chart to see what it looks like

After the configuration is completed, click Save. In the list of large-screen management, you can choose to share the newly created large-screen data with other users


App (user) can directly write data into 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 service, isn’t it nice?!! The charts we share will change as the data in the cloud database changes, truly dynamic visualization