background

Recently, I plan to learn some content about data analysis. Although there are a lot of advertising elements in the picture below, I don’t think much about it. It is said that programmers should have a little product thinking and be sensitive to data.

I read the introduction of some training institutions. There are a lot of knowledge points involved, including tools, thinking, practical operation and the final report. Sure enough, you can’t eat fat in one bite. Learn slowly.

Data analysis framework

Here is a complete data analysis solution, which is divided into five steps: problem identification, data capture, data cleansing, data analysis and report presentation.

Data Board

Today we are going to use the Finereport tool to index data kanban

Downloading and Installing software

Download address www.finereport.com/product/dow… Because we will be using the Postgres database, Sail software does not have this JDBC driver by default, and after sail software is installed, put the JDBC driver in the following directory

Preparing the database

Here we use a free cloud database MemFireDB to facilitate our testing, it provides public IP, no installation required. Log in to the console to obtain database connection information

Defining a data connection

Click Server and choose Define Data Connection from the drop-down list to configure the iP address, database name, user name, and password of the database service, which are obtained from the previous connection information

Defining data sources

After the data connection is defined, we need to filter the data content from the database to be displayed as the visual data source. Click “Server” and select “Server Data Set” from the down menu.

Server datasets can be filtered from tables in the database using SQL statements

Here we filter the most recent 10 lines to take a look

After clicking OK, you can see the corresponding fields in the table in the Server Dataset on the left

The design of the report

The details see help.fanruan.com/finereport/ here…

The design binding allows you to select the fields to be displayed

The final result