Excel can be said to be the most commonly used statistical analysis tool nowadays. It is easy to use and has powerful functions. However, Excel is difficult to meet some high-end data analysis requirements, and the main problems are reflected in data sharing, data permissions, data volume and other aspects.
So if there was a tool that didn’t take you extra time to learn, but was as easy to use as Excel, would you use it?
Smartbi big data analysis platform is an intelligent Excel software, it combines the advantages of Excel, solve the problems of Excel, let you easily handle intelligent Excel form production, even if it is more than one hundred thousand lines of data, that is not a thing!
Let’s take a look at the features.
1. Intelligent Excel table making — Bid farewell to derivative work and prepare data by yourself
IT personnel: connect data sources; Configure permissions;
Business users: data preparation based on business topics or large and wide tables;
Business users: Drag and drop fields in Excel directly to refresh data.
Import data sets to Excel through Smartbi data service +Excel plug-in;
Combine online and offline data using a formula, such as vLookup.
Template and data separation;
Reuse templates, dynamically update data;
Secure sharing through Web links.
Data preparation: preliminary summary of data through perspective analysis + SmartbiMPP, 100 million lines a300 thousand lines;
Report calculation: support in personal Excel terminal calculation, also support in the server (cluster) calculation;
Scheduled report: The back end automatically generates reports and exports them to Excel files without formulas.
Fine-grained permission control, precise control of each user’s data permission;
Hierarchical administrators can authorize organization users twice.
Data desensitization rules, sensitive information is not leaked.
