esCalc 2012

esCalc is a brand-new spreadsheet software. Being a smart desktop BI tool, esCalc leads to the computing ability revolution of spreadsheets. esCalc keeps the basic functions and using style of spreadsheet, but beyond traditional spreadsheet on complex tabular data calculation. esCalc enables formula or filtering condition expressions to be copied to the related business cells automatically and realizes intelligent adjustment according to the business relationship. The unique overall table computation model in esCalc can realize advanced features such as join, merge and difference between multi-level groups of data. esCalc enables abstract and complicated data computing to be more concrete and visible.

The computing which needs script writing with SQL Statement, R language, esProc script, etc., now can be easily done through visual operation. The clear and visual step-by-step calculation in esCalc is more capable to solve complex problems compared with SQL nested query. esCalc helps SQL computing visualized and stepped, and reduces the computing difficulty and technical requirements, thus users can handle computing directly. esCalc makes business users without technical background complete the entire report independently. esCalc provides retrieving data UI to guide static data extraction from the database, Excel or text files. Its ease-of-use and traditional Excel-style user interface allows users to build the report more quickly.

esCalc combines with Excel but is beyond Excel on complex tabular data calculation. It adopts step by step computing to process the tabular data without pre-modeling. esCalc boasts the powerful data analysis and computation functionalities, as well as the unique multi-level table structure to describe the real world business perfectly. The computations of the same type can be concluded reasonably with just a simple formula to accomplish the batch calculating.

Business users who conduct self-service BI computing independently, such as, computing analysis, reports creation. Users with lower technical expertise who need complex computing. Users who don’t have SQL experience but need tools with SQL ability.