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

In this issue, the editor will bring you about how to quickly solve the problem of Excel integration. 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.

At the end of the year, all kinds of reports arrived as scheduled, and everyone was busy sprinting at the end of the year, checking, finding, analyzing and making reports. Both business staff and technicians are busy with their feet on the ground. This is not, as soon as it was launched today, it was @:

Well, another report is abused, in fact, this should be a very common demand and problem for Excel users! Friends who have read our official account before know that we can use Excel fusion analysis to realize self-help analysis in Excel, solve the problem of Excel while retaining the advantages of Excel. The following wheat summary lists several common problem scenarios to illustrate how to solve them:

Scene one

1. There are dozens of Excel report templates, and if you want to reuse these templates, you need to fetch the numbers periodically and replace the detail data.

two。 Need the help of technicians to regularly take the number and update the detailed data. In particular, periodic and repetitive data acquisition must also be generated separately, data preparation is completely dependent on IT, and the response is not timely.

Solution:

The above problems can be solved by operating on the Excel interface through Excel fusion analysis and combining the characteristics of template data separation with self-help data fetching.

In the product, IT only needs to help business users make data catalogs and wide tables, and business users automatically fetch data through datasets, perspective analysis and other automatic processing, and then drag the result fields directly to the Excel after processing. As soon as they are refreshed, the data will come out. For periodic and repetitive fetch requirements, we can solve them through parameter condition filtering and permission setting.

In the data table, the blue column data is the customer original data, and the yellow data is the analytical data derived from the evolution of the blue raw data. We only need to replace the original data of the blue part, and the yellow part of the data is calculated automatically.

The other analysis template data comes from the yellow part of the data, so the original data changes, the template data can be changed, so as to achieve template reuse.

Take the number first...

Business personnel can fetch data by themselves through perspective analysis and select it to generate it, which is very simple.

Then drag and replace...

In the Excel fusion analysis, drag and drop the perspective analysis field to replace the blue part of the original data, you can achieve the entire template data change and Excel template reuse.

Then, we publish the exploration results, and then load them with full data when they are finally displayed on the Web side, so that we can finally view the exploration results of full data.

We can also continue to optimize performance through Sheet page paging settings and Web-side display optimization settings.

The problem "the calculation formula in the Excel table is complex, and the Excel opens slowly, which may take dozens of minutes" can be solved by opening it on the Web side and exporting a static file without a formula.

Scene 3

Proposed by: business Manager

The report made by Excel is not convenient for sharing and privilege grading. It is hoped that the report can be easily shared with different people and can be controlled by data permissions. Examples of permission requirements:

1.Admin administrator users can view all areas, detail sheet pages, and discount column data.

two。 Users under the North China and East China user groups can only see the data in their own region. For example, users under the North China user group can only see the data from North China.

3. Business managers in each region can see the data of the detail sheet page and the data of all columns in the report.

4. Ordinary business staff in each region are not allowed to see the data of the detail sheet page or the data of the "discount" column in the report.

The administrator user opens the report to view:

The business manager of North China opens the report:

East China Business Manager opens the report:

Ordinary users in North China open the report:

Solution:

1. Through data row permissions, different users under different user groups view different data.

two。 The permission configuration of the detail sheet page and the discount column in the report is realized through the permission setting in the report.

3. By publishing to the web for sharing, we can also share the published reports through Web links.

The above is the editor for you to share how to quickly solve the problem of Excel integration, if you happen to have 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.