Teach you how to visualize data with Finebi.

Some days ago the company introduced a soft business intelligence Finebi, after receiving a simple training, found that this business intelligence software used as a visual analysis of only one word, that is, "Light and smart"! The interface is simple, the operation is smooth, several steps can create the analysis, obtains the desired effect. This study also let me into the data visualization of the door, today I am here to share my experience in data visualization.

First of all, dashboard, business intelligence dashboard, is the focus of visual analysis. It can combine several different tables, chart controls, all indicators and dimensions with one key generation. Many BI tools create a global analysis in which the components are created separately and then stitched together, where finebi creatively combine the analysis container with the dashboard, all in dashboard.

Filter components and button components are all for global analysis, to filter the indicators and query reset, you can customize set query conditions, ad hoc analysis.

Here is a finebi cool visualization.

To build a sales analysis for example, teach you the 4 steps of visual analysis:

Step one: Create a new theme analysis, drag and drop the Chart Component

Open new analysis, create a new analysis, drag a table component to the Instant Analysis page, click Detailed settings in the upper-right corner of the component, or the details in the drop-down options to go to the Stats Component Properties configuration page, such as:

Once created, all subsequent actions are automatically saved, dragging the desired Chart component to the Analysis page. Adaptive layout refers to the Finebi background of all the components of the location of the adjustment, no manual operation, free layout refers to the component location by the manual control of the layout, the components want to put in where the placement. We choose the free layout.

Step Two: Drag to add Categories and series fields, add calculation indicators

Click the drop-down button after the component to select detailed settings, bind the data to the component

You will then jump to the component data binding interface and click on the chart type above to toggle the component type. Drag the corresponding field from the pre-set packet. For example, drag the month into the table header, the total contract price dragged into the indicator, in the corresponding table below will be reflected. In this way, the data in the database is simply dragged out to easily achieve data visualization, is not very convenient!

When making a table, sometimes we need to adjust the representation of the data, display it as a percentage or increase the sign of rising or falling, sometimes our data is not the source data in the database, it needs a little calculation to be reflected in the table. At this point we need to click on the Indicator drop-down menu option, select style settings and set calculation metrics.

At this point, the setup of a component has been completed, generally a dashboard will have multiple components, created in the same way. A linkage drill can be set up between components for dynamic analysis of the display, which is not explained in detail here.

Step three: Drag and drop to add controls, customize query settings

Both the filter control and the Button Control Act on the entire dashboard. The filter controls are used to conditionally select the results of the analysis, including text class controls, data value class controls, drop-down tree controls, time controls, and universal query controls, and the buttons include the query control and the reset button, which are also dragged from the left. After setting the conditions, click on the query will filter the display results, click Reset will be restored. , I filtered the signing date to June 2014, and all the tables only showed June data.

Fourth step: Release view, ad hoc analysis

Finebi Instant Analytics When you're done, click the one I created to see a new instant analysis in the list, and click to see the results of the analysis you just created.

In fact, it seems that data visualization is not so far away, the key choice of tools.

Teach you how to visualize data with Finebi.