Shulou(Shulou.com)06/01 Report--

In this issue, Xiaobian will bring you information about how FineBI tools can quickly analyze data. The article is rich in content and analyzes and narrates from a professional perspective. After reading this article, I hope you can gain something.

As long as IT prepares the data for the business, the business personnel can complete the analysis according to the business requirements themselves. The operation difficulty is like the pivot table in Excel. This is the tool I want to recommend to you today-FineBI.

What is FineBI?

First of all, FineBI is the domestic self-service BI with the highest market share at present. It is a complete data solution that effectively integrates enterprise data, and can simply and quickly generate various cool visual data reports and do purposeful data analysis.

More simply, it is a more advanced Excel Pivot Table. Select the data fields you want to present and you can immediately present the visualization.

You can think of it as a visualization tool because it comes with dozens of commonly used charts and dynamic effects;

You can also use it as a reporting tool, because it can access a variety of OA, ERP, CRM and other system data, do not write code, do not write SQL can batch reports.

You can also think of it as a data analysis tool, with built-in common data analysis models, as well as various charts, you can use FineBI to do some exploratory analysis.

With this tool, IT departments only need to classify and prepare data according to business modules, and business departments can click and drag the mouse at the front end of the browser to get the data analysis results they want. It is simple to use, rich in visual libraries, and can serve as a portal for data reports or a platform for business analysis.

FineBI Main Features

1. Data integration, opening up data sources

FineBI can grab data from various data sources for analysis. In addition to supporting Oracle, SQL Server, MySQL and other commonly used databases, it also supports SAP BW, HANA, Essbase and other multidimensional databases.

Big data front-end analysis, FineBI can interface with Hadoop, Kylin, Derby, Gbase, ADS, Hbase, Mongodb and other big data platforms. In terms of docking, it has its own distributed connection scheme.

FineBI also supports importing Excel data and importing data from R scripts. Therefore, it can basically connect all kinds of data sources, get through and integrate.

Data processing is ten times easier than Excel.

Data analysis, data processing is the most annoying, often occupy 50% to 70% of the time.

In one case, data was requested from the IT department to analyze the company's product sales breakdown data, analyze the characteristics of buyers, and adjust the sales strategy accordingly. At this time, some corresponding analysis indicators need to be calculated based on the sales list data, such as the frequency of consumption per person, the maximum amount of single consumption, and the time interval between the last consumption (i.e. RFM model). For example, I also got some industry competition data, but also need to do correlation analysis and horizontal comparison analysis according to the same type of products. I can't put this data into the data source, so I have to create another data source and merge the tables.

ETL processing capability is one of the indicators to consider whether a BI tool is good or bad. FineBI's self-service dataset provides functions such as adding columns, grouping statistics, filtering, sorting, merging up and down, merging left and right, and visual operations.

3. Data visualization

When Excel is used to make reports, due to its horizontal/vertical expansion characteristics based on cells, the reports usually made will be like the following figure. The dense text and indicators make people unable to grasp the key points and it is difficult to obtain effective information from them:

But for presentations, we need to make charts and visualizations, using data to create compelling, informative, persuasive stories. In addition to providing unlimited chart analysis, FineBI can also do visual dashboards, layout, analysis, beautification of charts, similar to an infographic, and easily construct a report.

Therefore, the story dashboard made by FineBI is like the figure below. Any OLAP analysis operation such as linkage, drilling and jumping can be performed between data.

How to use FineBI?

For business people or data analysts, FineBI has four basic modules: data sets, visualizations, dashboards, and applications. A typical workflow is as follows:

1. Processing data

Datasets are data containers, underlying datasets are imported by administrators or obtained by connecting to databases, and as a general business person, you do not interact directly with underlying datasets, but you still need to understand them. The basic dataset includes database tables, SQL datasets and Excel datasets, where database tables and SQL datasets need to be obtained by connecting databases, and Excel datasets can be obtained by uploading directly.

After the administrator assigns you permission to the underlying data, you can view it in Data Preparation under Business Intelligence Systems, as follows:

If the salesman/data analyst is dissatisfied with the basic data or needs to be reprocessed, he/she does not need to communicate with the administrator and independently creates a self-service dataset or adds an Excel dataset.

One dataset can be used repeatedly by business people to create dashboards; can be used to create many different self-service datasets; and components from one dataset can be displayed on many different dashboards.

2. Create visual components

Visualization is the process of turning data into graphs, and insights can be understood more easily with visualization effects because the brain understands pictures faster than spreadsheets full of numbers.

A visualization can appear multiple times in the same dashboard; it can also appear in many different dashboards.

3. Design instrument panel

A dashboard represents a custom view that consists of several visual components that allow you to compare and view multiple data at once to present a fact or present a problem. A dashboard is a canvas containing tables, graphics, text, and so on.

Dashboard can be used for:

Display visualizations from many different datasets

Quick view of all the information you need to make a decision

Monitor the most important business-related information

Monitor the health of your business, product, business unit, or marketing campaign

4. Share results with others

After the design of FineBI dashboard is completed, it can be shared with individuals, groups, the whole organization or the public. It can be shared without permission by creating public links, hanging out to the system directory for users to view, sharing directly to designated users, etc. In addition, it also supports Finemobile APP or mobile browser viewing.

The above is how to quickly analyze the data with the FineBI tool shared by Xiaobian. If you happen to have similar doubts, you may wish to refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.