SQL Visualization in the Spreadsheet
SQL is a database query and programming language for retrieving, updating, and…
Seven Drawbacks of Traditional OLAP
In 1993, E.F. Codd, the acknowledged founder of relational databases, introduced the…
OLAP Cask Principle Reveals the Future for OLAP Tools Manufacturer
This post is originally posted on http://it.toolbox.com/blogs/data-analytics/olap-cask-principle-reveals-the-future-for-olap-tools-manufacturer-54044. This post is originally posted…
Simple Inter-row Computation: esProc Keeps It Simple!
The interrow computation is quite common, such as the aggregate, comparison with…
Vector Computing, Who Is More Powerful, R Language or esProc?
Do you find Vector Computing tiresome while using statistical computing tools? Here…
Interactive Analysis Tools Comparison: R Language, Matlab, esProc, SAS, SPSS, Excel, and SQL
The interactive analysis is a circular analytics procedure comprising assumption, verification, and…
Interactive Analytics and OLAP – Part III
In the part II of interactive analytics and OLAP, we left a question: Can the narrowed OLAP be used to complete the computation process as follows (marketing and sales data analysis)? In the part II of interactive analytics and OLAP, we left a question: Can the narrowed OLAP be used to complete the computation process as follows (marketing and sales data analysis)?The first…
Interactive Analytics and OLAP – Part II
After the first stage of real application process of the OLAP in interactive analytics and OLAP - Part I, we will start OLAP application of stage 2. After the first stage of real application process of the OLAP in interactive analytics and OLAP - Part I, we will start OLAP application of stage 2. Those guesses in part I of interactive data analytics are just the basis for forecast. After operating for a period of time, a constructed business system can also accumulate large quantities of data (so called complex data calculation), and these guesses have most probably been evaluated by these accumulated data, when evaluated to be true, they can be used in forecast; when evaluated to be false they will be re-guessed. It needs to be noted that these guesses are made by users themselves instead of the computer system! Instant data analytics is started by human being in OLAP. What a computer should do is to help a user to evaluate according to the existing data, the guess to be true or false, namely, on-line data query (including certain aggregation computation). This is just the application process of OLAP. The reason why on-line analysis is needed is that many query computations are temporarily required after a user has seen a certain intermediate result. In the whole process, model in advance is impossible and unnecessary (Raqsoft esProc is born to deal with these issues).We call the above process evaluation process, whose purpose is to find from historical data some laws or evidences for conclusions, and the means adopted is to conduct interactive query computation on historical data. And this process can be a complex data calculation. The following are a few examples actually requiring computations (or queries): The first n customers whose purchases from the company account for half of the sales volume of the company of the current year; The stocks which go up to the limit for three consecutive days within one month; …
Interactive Analytics and OLAP – Part I
Many BI practitioners have heard about OLAP which is an important constituent…
Interactive Analysis and Related Tools – Part II
In my last article, I have talk about interactive analysis from the…