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

This article is to share with you about how to use the Excel big data analysis tool Smartbi Excel, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Why Excel Analysis is needed

Self-help BI makes BI no longer the patent of senior executives, promotes the citizenization of BI, and is the development trend of BI. However, the choice of self-help BI tools is not simple, many manufacturers have launched their own self-help analysis tools, but in the process of use by enterprises, the actual results are not satisfactory. Why?

Because most business users in the enterprise are more accustomed to using Excel, they are reluctant to learn new analysis tools for the following reasons:

1.Excel provides very powerful and flexible capabilities for data processing, data analysis and data visualization.

two。 Users have a large number of Excel-based report templates, these templates have accumulated a lot of business wisdom, replaced with other analysis tools, Excel business templates can not be reused.

3. Analysis tools on the market not only provide users with analysis capabilities, but also limit users' imagination, which is far less flexible than Excel in terms of functional flexibility, and can not meet the analysis needs of business users.

However, Excel also has some problems that have plagued front-line business users for a long time:

1. The first is performance. For large amounts of data, Excel is very slow to process, even more than 1 million rows, it is not supported at all.

two。 The process of data acquisition is troublesome. In particular, for periodic data acquisition, you have to ask IT personnel for help every time, and then paste it into excel.

3. The security and convenience of sharing. Most users share Excel files via email or instant messaging software. First of all, files are flying everywhere and difficult to manage; second, permissions are difficult to control, so it is impossible to share only analysis results, but not detailed data; finally, the data can not be different from each other, and the data can be dynamically updated according to user permissions.

Smartbi Excel analysis is a data analysis tool for Excel users, which combines the advantages of Excel, solves the problem of Excel, truly empowers enterprise front-line business users, makes everyone a self-help analyst, and promotes the digital operation of the enterprise.

Functional highlights of Smartbi Excel analysis

1. Support Excel to connect directly to the database, and prepare the data on your own.

two。 Support the joint analysis of online and offline data using Excel calculation formula

3. Support the use of Excel graphics and PivotTables to analyze and present data

4. Support template and data separation, reuse analysis template, update data dynamically

5. Support the secondary processing of the data in Excel and bid farewell to the dilemma of relying on IT personnel to deal with

6. Support for large amount of data processing, operation on the personal Excel side, and operation on the server (cluster)

7. Support comprehensive permission control, provide fine-grained access control, and accurately control the data permissions of each user.

Figure: data preparation through PivotTable

Figure: combine online and offline data together through formulas

The main processes of data analysts using Excel analysis are:

1. Install the Excel plug-in. After the installation is complete, the smartbi tab will appear in the Excel/Wps toolbar.

two。 Do data pre-processing through perspective analysis, including data summary, setting filtering conditions, etc., as the data source of data analysis.

3. Perform data analysis in the Excel report design interface, such as adding data columns, calculation formulas, graphics, PivotTable, etc.

4. Publish the completed report to the server and browse it on the web side.

The above is how to use the Excel big data analysis tool Smartbi Excel. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please 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.