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

In this issue, the editor will bring you about the analysis of FineBI tools. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

VS Excel

As the most widely used data table tool, Excel has a huge module system, from simple table making, PivotTable, formula writing, and then to VBA language, there are numerous plug-ins to use. In terms of data computing power, Excel is omnipotent and takes the lead.

But business data analysis, in a complex business environment, Excel still has its inability:

1. The efficiency of Excel data cleaning and calculation is low, which requires a large number of repetitive and low value-added manual operations. So I used to spend two days a month on the monthly report, not to mention the weekly report. )

2. Although Excel introduces PivotTable to perform some simple drag-and-drop statistical operations, the performance bottleneck is so obvious that tens of thousands of pieces of data will jam computers with general performance. (I have a deep understanding of this. If you open Excel, you will crash.)

3. Excel is easy to start, but difficult to master, especially for professional data analysis and automatic screening. Linkage visualization is bound to write a large number of VBA. (this point directly pass most people)

So is there a tool that can automate and simply implement data processing-> cleaning-- > data modeling-- > data visualization-- > building storytelling data analysis reports? and then the data analysis report can see where the business problems lie? This is the FineBI that I would like to recommend to you today. Strictly speaking, it is version 5.0.

1. Excel: data processing for one person-- > FineBI: data analysis for a group of people

As mentioned earlier, Excel is more for personal use, although the owner has the largest number of users in the world, but because of the function and positioning of the product, it can only be used as an office data processing tool.

For enterprise-level business data analysis, usually the data comes from different business systems, which requires the data engineer to integrate into the data warehouse or intervene in the big data platform, and then clean and output the data to the front end of the data layer for data analysis. The whole process involves the business part-business database-data warehouse-data / BI department-business unit.

The advantage of BI tool over Excel here is that it can be used as a platform to integrate data, distribute data, do data analysis on it, distribute reports on it, and the leadership can view the results, and even the results can be automatically exported into reports.

Here, as a relatively mature business data analysis tool, FineBI gives full play to the ability of enterprise IT personnel and data analysts or business personnel with data analysis needs to perform their respective duties:

IT people do the data preparation work that they are good at, integrate the data with FineBI, unify the caliber, and distribute the data to different people according to their authority.

Data analysts or business colleagues use FineBI to do data cleaning, including "column renaming, missing value handling, data type conversion, abnormal value handling, new data fields, etc.", and then visually explore and analyze, go deep into data mining, establish analysis models, and form visual reports.

2. Excel: formula, VBA-- > FineBI: no code drag analysis

When we use excel to do data calculation, we often need users to do a large number of complex and tedious calculation of plane cell formulas. The operation interface is as follows:

When using FineBI for data analysis, we divide the whole interface into seven areas, which are dimension field area, index field area, chart type area, attribute style area, horizontal and vertical axis analysis area, chart preview area and data mining depth analysis area.

When you analyze a datasheet / database, it will automatically help you distinguish those dimensions and those are indicators when you import them. For example, the dimensions of region, time and country; sales, return amount, profit, weight and so on are indicators. The latter can be worth quantifying.

Then, start the analysis. How to analyze, there are two axes in the analysis area, the horizontal axis and the vertical axis. If you drag the indicators and dimensions to the two axes, you will automatically get a visualization chart, and the chart will be automatically recommended according to the analysis situation. (for example, the following figure)

FineBI is based on the famous graphic Grammar (The Grammar Of Graphics) design, with "shape" and the corresponding "color", "size", "prompt", "label" and other attributes (in addition to supporting free settings, but also supports dynamic display bound with fields) to replace the chart type.

3. Excel: tables, simple graphical reports-- > FineBI: visual reports with analytical significance (Dashboard)

When we use excel to do reports, we usually do tables, rows show what, vertical display what, it is difficult to directly show the law of data changes, but also more difficult to analyze which indicators are caused by data changes.

People who know a little bit about data analysis know that they have to do visual charts to see, yes, but the visual expressiveness of Excel is a little weak, and there are only a few charts. (what, install plug-ins, bank units can't afford to use Excel2003)

In addition to providing unlimited chart analysis, the dashboard also provides users with flexible data chart layout analysis, easily building your data chart thinking logic, so that you have unique insights into data, and then achieve effective communication or data reporting purposes.

Therefore, the story dashboard made by FineBI is shown in the following picture, and the data can be analyzed by OLAP, such as arbitrary linkage, drilling, jump and so on. The key point is prominent, the logic is clear, has the deep insight and the insight, the readability is extremely high!

If you are the data analyst Rebecca in the above report, after reporting to the leader, you must be on the verge of a promotion and a raise.

4. Excel: data trend fitting-- > FineBI: deep data mining

In some scenarios where data need to be analyzed and predicted in depth, excel only provides some simple data linear, polynomial, logarithmic and other fitting methods to do some simple data prediction. Professional data analysis and mining, such as classification, clustering, logical regression algorithms, also rely on professional tools, such as R and Python. But can not write code can not afford, there is no off-the-shelf data mining tools, FineBI has.

In version 5.0, FineBI adds five kinds of mining algorithms, namely time series, clustering, classification, regression and association rules. If you want to predict future sales, you want to intelligently classify user groups, or you want to know which users are more likely to get feedback, and you want to build a product-related sales model. If you use FineBI, all you have to do is click a button.

There is nothing wrong with the data mining algorithm, the key to the use of the algorithm can also give the corresponding visualization, people who do not understand can understand, it is very powerful. FineBI combines time series algorithm, clustering algorithm and chart analysis, that is, we can not only achieve prediction and clustering, but also simply drag and drop to see the prediction and clustering results immediately.

5. Excel: repeat copy report-- > FineBI: report automatically

In the past, when we used excel to do some data statistics, once the data needed to be updated, for example, we made financial statements for August, and in September, we had to copy a copy. At this time, I think, it would be nice to update automatically!

If FineBI is directly connected to the data source, the data in the database is updated, and the data report here can also be updated together. If the amount of data is relatively large, tens of millions of level, you can directly through the built-in Spider big data engine and data warehouse, big data platform docking, and provide real-time and extraction (improve big data performance) data for the two major modes for free choice, support for more than 30 database types, is not rich.

6. Mobile Excel-- > FineBI: mobile data report

The mobile version of Excel is very chicken, ah, it is very inconvenient to use, the editor's miraculous shortcut key skills can not be used at all. Nowadays, many data reports can be seen on the phone tablet or even on the LED electronic screen.

Before I put the data analysis report on the mobile phone display, the leader saw greatly appreciated.

7. FineBI: not only a personal data analysis tool, but also an enterprise data value mining platform

Finally, Excel mainly improves personal office efficiency in practical application, and the greatest contribution of FineBI should be to the enterprise as a whole, which can never be compared with Excel as an office tool.

Relying on FineBI data decision-making system, enterprises can build a data analysis system, facilitate dashboard management, user management, timing scheduling, rights management and system personalized settings, and then support a variety of business theme analysis.

The above is the editor for you to share the FineBI tool how to analyze, if there happen to be similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow 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.