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; Commodities in the supermarket which are sold out at 5 P.M for three times within one month; Commodities whose sales volumes in this month have decreased by more than 20% over those of the preceding month; …Evidently, this type of computation demand is ubiquitous in business analysis process and all can be computed out from historical database.Then, can the narrowed OLAP be used to complete the above-mentioned data computation process?In the third part of Interactive Analytics and OLAP, i will answer the question above.Sponsored by http://www.raqsoft.comTo be continued... Related Articles:Interactive Analytics and OLAP - Part I
More on Forecasting Benchmarks
The Perils RevisitedA few posts ago I warned of the perils of forecasting benchmarks, and why they should not be…
Are Google’s Engagement Programs Losing Oxygen?
An article came out recently highlighting Google’s new “death benefits” offering where the spouse or domestic partner receives 50% of…
Interactive Analysis and Related Tools – Part II
In my last article, I have talk about interactive analysis from the definition and explains with an example, and today…
Arguing for Increased Gut-feel in the Age of Analytics
According to a recent HBR article, an astounding 89% of marketers rely on their gut-feel when making decisions. As a marketer…
NYPD and Microsoft Create a Next Generation Law Enforcement Big Data Solution
With an emphasis on surveillance, evidence, and reporting, law enforcement is an extremely data-intensive field and the New York City…
Answers to the Most Frequently Asked PAW Questions
Frequently Asked Questions About PAW BostonYou asked for it, you got it. All the FAQs regarding Predictive Analytics World Boston's…
A Prediction for the Olympic Men’s 100m Sprint
R user Markus Gesmann used the gold-winning times from the Olympic Men's 100m sprint since 1990 as the basis of the…
Predicting Crime
Applying inferential statistics to criminology is not new, but it appears that the market has been maturing. See, for instance,…
Are You an Analytics Champion? Prove It!
With the Summer Olympics starting this week in London, an estimated 10,500 athletes from 204 countries are gathering to compete…
