esProc is more ease-of-use and capable script for statistical computing. It bridges the gap between business and IT with more powerful computing capability than SQL, delivering more convenience and flexibility to your complex business analytics.
esProc is a brand new script to simplify the complex database computation with step-by-step mode. It can deal with tentative and occasional problems without data-modeling beforehand, releasing you from heavy data process work. esProc can also integrate complex and various datasource as a database, keeping you away from tedious and complex SQL and stored procedure.
esProc runs as a desktop application, it can be utilized easily by business professionals without highly skilled technology background or extra training, which could greatly improve your productivity by minimizing the purchase and learning costs.
esProc is easy-to-use business computing script specialized in solving complex computing objects. It optimizes business data and has lower technical requirements.
esProc is cell style scripts, allowing complex business computing objects to be divided into small objects in the grids for solving final objects.
esProc is designed for business professionals, as its syntax is easy to use and understand with lower
...
esProc is more powerful on structured data computing, particular for complex computation in database as a script language.
esProc improves SQL computing ability with step by step computing, sequence computing, set-lization and object reference.
esProc can solve complex database problems by dividing into several simple computing steps. Each step result can be referenced directly for further
...
esProc allows report designers to combine esProc's excellent computation and analysis capability with the strong presentation function of reporting tools. It can organize the disorderly source data and directly delivery clear data to reporting tools through the JDBC interface.
Besides, esProc can also complete complex data analysis and give the analytical results ...
With esProc, users can complete a series of computing indepently, especially the more complex analytic goals. So it is a real desktop BI tool, which is reflected in the following aspects. First, it does not require pre-data-modeling for your analysis goal relying on powerful computing capability and lower technical requirements. It allows users to freely conduct bound-free data analysis., therefore to agilely meet the fast changing demands with lowest cost
...
esProc provides a grid user interface similar to excel which enables users
to perform codes in a grid from left to right, top to bottom. Each cell has
unique and naturally named coordinates with column and row number, so users
can reference the calculation results of other cells conveniently through
the coordinates for further processing...
esProc realizes complete set-lizing, which differs from the simple and rough SQL sets. esProc sets are ubiquitous, and the members can be of any data type or another set. Complete set-lizing transforms the cumbersome and difficult lower-level calculations into high-level set operations, for example, the intersection...
esProc is more intuitive and easier than SQL to solve complex calculations with multi-table join. With "." for generic object reference in esProc, this expression is more straightforward and easy to understand, allowing users to easily organize the relationship between data from business perspective. esProc reference function tranforms...
When coming to serial number relational computations, esProc greatly simplifies the calculation difficulty and makes users without high technical capacity easily carry out the seemingly complex calculations. There are a large number of computational problems related to serial number actually, such as over the...
esProc grouping completely covers a variety of situations, which is more agile and easier to use than SQL to solve the grouping related problems. In esProc, grouping and summary can be divided into two steps. The grouping results can be reused or for secondary processing, such as sorting, query, and re-grouping...
Since data computing is widely needed in various industry. Our product esProc is designed for structured data computing, include data analysis and query, report data source preparation, data management & ETL. For example, to find out top n clients achieving half of the total sales; stocks keeping rising for three consecutive days in a single month; demonstrate the top 10 states with highest turnover...
esProc is born for the following purposes.
Business Computing Script
esProc is a desktop program, you can just run it once installed. It has an easy-to-use grid style and syntax, good at complex computing but with lower technical requirements, which are more suitable for business professionals. esProc can simultaneously access multiple databases, Excel and Txt files in the enterprise environment, and specifically optimize...
Normally, the current solutions for data computing are SQL and other high-level programming languages. On one hand, these solutions have advantages indeed, on the other hand, their disadvantages can really be a big deal which add more difficulties for data computing.SQL (or MDX)
Advantage: have enough computational ability to handle the structured data Disadvantage: Hard to edit codes and difficult to...
Data Analyzer
An operational data analyst who is capable to compose some simple scripts in most cases is preparing some materials for the incoming meeting. However, some operations are rather difficult. In order to complete these calculating target, more capable computing tools is necessary to supplement the lack of SQL.Database Administer
Data is distributed in multiple business systems, unordered and...
Here are some screen shots for you to have a deeper insight on our product, include Cellset-style Script , SQL Execution and Data Structure Display, Program Debugging ,Computation Presentation etc...
.jpg)
From the closing prices of several stocks this month, you are to find the stocks that have been rising for 10 consecutive days. Let's see how esProc manage it...
.jpg)
Based on the automobile sales data, calculate the average interval between buying the Jetta first and then the Magotan. Please note that a customer may buy the same model car for several times, and thus there may be several intervals. In this case, we will take the shortest in...
To make the payroll table of this month based on the basic information of employees, absenteeism and performance data. The basic algorithm is: Actual Pay = Base Pay*( 1-Absenteeism Factor+Performance Factor). Please note that, the basic information is based on all employees...
esCalc features abundant computing capability with quite low technical requirements. esCalc leads to the computing capacity revolution for spreadsheets. It can easily solve problems which are difficult for traditional spreadsheets, such as: automatic formula copy in related cell, formula automatic migration between multi-layers tables, associated join between multiple tables.
esCalc realizes real visualization of data computation. Computations such as query, grouping, sorting, ranking, delete, table joins, filter for duplicates, which can only be completed previously by abstract scripts like SQL statements, R language, esProc scripts, can now be achieved by buttons/menus as long as concrete data is given.
With esCalc, business users can independently conduct a range of business intelligence computation on desktop, analyze data agilely in rapidly changing business opportunities and make quick decisions. esCalc is self-service professional reporting tool, more intelligent spreadsheet, data calculator for business users and secondary processing tool for reports.
esCalc realizes real visualization of data computation. Computations such as query, grouping, sorting, ranking, delete, table joins, filter for duplicates, which can only be completed previously by abstract scripts like SQL statements, R language, esProc scripts, can now be achieved by buttons/menus as long as concrete data is given.
With esCalc, business users can independently conduct a range of business intelligence computation on desktop, analyze data agilely in rapidly changing business opportunities and make quick decisions. esCalc is self-service professional reporting tool, more intelligent spreadsheet, data calculator for business users and secondary processing tool for reports.
esCalc keeps the basic functions and using style of spreadsheet, but is completely beyond traditional spreadsheet on complex tabular data calculation. Traditional spreadsheet lacks the capacity of integral calculation on business data, for example, when pasting a formula, other spreadsheets only permit adjustment of relative position, resulting in a business rule violation, while adjustment with esCalc can be finished automatically and intelligently focusing...
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. First, users' operation objects are not abstract data structure but the specific business data; then users can select the operational actions from the menu, such as, query, group, sort, filter, rank, join, union, etc., corresponding...
The traditional reporting tools usually need higher technical requirements, such as retrieving script, complex report expressions, and abstract logic. While with esCalc, users can complete the entire report independently without technical background.First, esCalc provides retrieving data UI to guide static data extraction from the database, Excel or text files. Second, its ease-of-use and traditional Excel-style user interface allows business users...
Business users can use esCalc to conduct a serial of business intelligence computing on their desktop.
esCalc is professional reporting tool with capability of creating various tables and graphs. This more powerful spreadsheet has a more intelligent table calculation engine. With visible operation, esCalc can realize the corresponding functions of SQL without writing scripts since it is visualized data computing tool. esCalc can be used as the calculator of...
esCalc is professional reporting tool with capability of creating various tables and graphs. This more powerful spreadsheet has a more intelligent table calculation engine. With visible operation, esCalc can realize the corresponding functions of SQL without writing scripts since it is visualized data computing tool. esCalc can be used as the calculator of...
Capable to reference the data from database or external files such as txt and Excel. Capable to perform the copy, paste, and other operations to edit the cellset data. Intuitive interface for report preparation. Capable to be saved as various formats like txt, xls, and gex to facilitate the use and edit...
Through the level settings, rows are associated to each other. The multi-level structure can describe the data in the real business more completely. Free and convenient grouping operation with outstanding performance and the usage is quite simple. It is the real grouping that you can sort, filter, and perform other operations on each group and the data ...
The data with the same business priority will be set in the homorow. The appearance property of homocell in the homorow will be processed concurrently. Through the formula migration of homocell, calculations of the same business logic will be completed all at once. Given the below table of the technical data of pitchers of some baseball teams ...
Utilize the settings of homorow and level, recognize the true objective of computation smartly. The formula in homocell will be auto-migrated, no need to copy and paste. In the below table, given the statistics of the most frequently used surnames in some countries, calculate the proportion taken by the total population of people with this surname in each region ...
Full support for sets, and capable to handle the sum, subtraction, intersection, union, and other operations on sets directly. The sets exist in the form of object, making the summarization more intuitive and easy to read and write. Given the score statistics for the last three games of a certain basketball team, make statistics on players whose scores are among ...
Stepwise operation to solve the complicated problem progressively. Instant presenting the result, intuitive, and easy-to-use. Given the payroll of a company below, select out the male employees of which the wage are higher than that of any female employee in their department. ...
Handle the multi-level join automatically according to the level and master cell settings. Operation style is similar to the copy & paste, convenient and intuitive. In the below table, there is the population data of some states and the abbreviations are set as the master cell ...
esCalc keeps the basic functions and using style of spreadsheet, but is completely beyond traditional spreadsheet on complex tabular data calculation. Traditional spreadsheet lacks the capacity of integral calculation on business data, for example, when pasting a formula, other spreadsheets only permit adjustment of relative position ...
Evanescent business chance, various and complicated requirements are the characteristics of modern business computing. As the main part of business computing, business users with lower technical capability need to manage business data and complete the computation within the shortest time. While current spreadsheets, data computing scripts ...
Microsoft Excel,LibreOffice Calc,OpenOffice Calc are all the commonest spreadsheet preparation tools. They are easy to use and support the commonest data computation of almost all kinds. However, they lack the ability to handle the complex computations ...
In esCalc, the calculator-style reporting calculation mode is adopted. The stepwise mode makes the objective for each step ever clearer, and users can no longer face abstract data structure. The result is presented in details, intuitive and easy-to-understand, not requiring any abstract ability from users. Through such operation mode ...
Here are some screen shots for you to have a deeper insight on our product, include Cellset-style Script , SQL Execution and Data Structure Display, Program Debugging ,Computation Presentation etc...
Compute the top 3 clients by order value according to the detailed order data. The basic train of thought is to group the orders by clients firstly, secondly sum up...
Given a book of 3 Excel sheets in which there is the basic salary, attendance record, and performance data, we now need to compute the actual salary of employee. When computing, use the below formula: Payable weekly salary = standard weekly salary *(1+Performance...
On the basis of a database of the sales data of a pharmaceutical company in the recent 2 years, make statistics on the year-on-year monthly and the link relative ratio comparisons for each product. In which, the link relative ration comparison refers to the monthly...