Why Business Needs Public Data
With over 30 years in retail site location strategy, I used Census data every day to analyze business critical issues.…
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
Open Data: What’s It Hiding?
Let’s get this straight – I’m all for open data. Yet the fanfare about open data is taking up so…
Building Your Analytical Team: Tips for Executives
As the concept of using analytics as a strategic advantage is gaining more and more traction, many organizations are asking…
Interactive Analytics and OLAP – Part I
Many BI practitioners have heard about OLAP which is an important constituent part of business intelligence. And today we will…
IBM’s Billion-Dollar Bet on Kenexa for Social Business and Talent Management
IBM has announced its intention to acquire Kenexa as part of IBM Smarter Workforce initiative and social business software division. It’s a…
Matt Lease: Recent Adventures in Crowdsourcing and Human Computation
Today we (specifically, my colleague Daria Sorokina) had the pleasure of hosting UT-Austin professor Matt Lease at LinkedIn to give…
Back to the Future of Business Intelligence
When was the term "business intelligence" first coined? You might assume it was first conceived in the late 1980's; coinciding…
Location Intelligence: Top 12 industries
Location Intelligence (LI) – the ability to map and compare your spatially significant data with your more traditional metrics captured…
More on Forecasting Benchmarks
The Perils RevisitedA few posts ago I warned of the perils of forecasting benchmarks, and why they should not be…
