Cindy Howson on cool things happening in BI

Posted by: ward in Untagged  on

Cindi Howson wrote an article on November 10, 2008  for Intelligent Enterprise
I found the article very informative.  She wrote about a number of things. I took an interest in "In-memory analytics" and "Advanced Visualization".  Following are my comments on the topics she wrote about. 


In-memory analytics

:  One of the potential benefits of in-memory is that it replaces the expensive & time-consuming aspects of reporting databases or cubes. 

When a user has "new" business question, underlying data is created on-the-fly with no IT overhead either to design it, or to maintain it.


Advanced Visualization

:  Most "visualization" technology gets its data directly from a database or cube and suffers the limitations of query technology (and not using a business tier in a 3 tier model): 

* single-pass queries, such as SQL;
* single data source;
* complex SQL & MDX being the gating factor in answering business questions;

Due visualization being based on query technology, the data you're going to discover just isn't going to be that interesting.


Here's my solution

What these products need is a "business layer" sitting on top of the query results. 

Advanced metrics and kpis can be developed in a business layer, without much impact on the database.

If it can be created in-memory, so much the better.

If visualization products can plot it, even better.

Our product acts is an in-memory business layer and can supply data to any BI or visualization tool. We give them useful numbers to display and explore visually.

On top of that, per your previous page in this article, it is highly desirable that the business user can experiment with and author their own metrics and KPIs.  Again, we've solved that.  Come take a look!

 


Trackback(0)
Comments (0)Add Comment

Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

busy