Data Intelligence, Business Analytics
The spreadsheet can implement the visualized calculation to some extent, and the nontechnical people can perform some rather complex calculations without having to learn the SQL. However, as the core of SQL, the relational query is unable to be implemented through spreadsheet, which adds complexity to the apparently simple problems of multi-table join.
For example, the Finance department needs to calculate the salary, and the…
Added by Jessica Qiu on April 9, 2013 at 12:09am — No Comments
Added by Jessica Qiu on March 19, 2013 at 9:24pm — No Comments
A standalone alternative for Excel on complex data computing, esCalc, will be offered for free to participants who write reviews or share their application cases (The application cases could be the usage of esCalc in a task or a function introduction of esCalc.), according to the announcement of Raqsoft. This campaign starts from March 6, 2013 and will end at May 6, 2013.
Participants will get various licenses of esCalc through different forms of participation, showing as…
Getting train tickets is always very difficult during holiday, especially in Spring Festival, the most important Chinese holiday for family reunions. The transport peak spans from Jan. 26, 2013 to March 6. During this period, buying tickets at railway station or from the official website of MOR (China’s Ministry of Railways) or through phones seem to become an extravagant expectation. What are the reasons? How to take effective measures?…
Added by Jessica Qiu on January 22, 2013 at 8:04pm — No Comments
Added by Jessica Qiu on December 25, 2012 at 9:38pm — No Comments
People like to predict what will happen in future especially in 2012. Nostradamus brought about massive destruction and mayhem thought there was comet in 2012. Even Mayans stopped their calendar on December 21st, 2012. If it’s true, human only has less than a week to live. But do you really convinced by this dire prediction? Is this prediction based on correct analysis? Some people who believe that because they are depressed at some bad phenomenon such war, natural disaster, resource…Continue
Enterprises always have various data sources, for instance, CRM system may use SQL Server, sales reports adopt Excel, ERP applies Oracle database. When it comes to actual business analysis, enterprises usually need to conduct interactive computation, including filter, group, etc among various data environments. But data Interaction between multiple data sources are not easy to realize with some traditional statistical computing tools. In order to solve such kind of problems, esProc which…Continue
Added by Jessica Qiu on November 7, 2012 at 11:21pm — No Comments
In the actual business, data analysis and statistical computation as well as report preparation are required no matter for the management of inventory and human resources, or calculation of customer information and sales data. In this case, a tool which can handle different datasource like text, spreadsheet, database, etc. is needed in urgent. However, most of statistical computation software needs modeling before computation and analysis which reduces flexibility to meet analysts'…Continue
Excel® is the most widely-used spreadsheet tool. The nontechnical persons like to use it for computation and analysis. But they usually find the formulas and functions available in Excel® are rather poor and the VBA® is just double Dutch to them for further analysis. Thus, a huge volume of data with valuable information has been wasted in vain.
Hereby introduce a better solution to realize the utmost value of Excel® by taking the esProc advantages of powerful computation ability,…Continue
Added by Ben Hinchliffe on June 18, 2009 at 2:55pm — No Comments