Ride the Next Wave of Flexible 'BI Workspaces' - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
News
6/30/2008
02:47 PM
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail
50%
50%

Ride the Next Wave of Flexible 'BI Workspaces'

Forrester Research says SaaS and in-memory options will let power users and analysts gain insight without IT bottlenecks. Embrace the trend, but beware the costs and risks.

Much has been written in recent years about the need to spread BI to the masses — embedding intelligence within applications, simplifying interfaces, improving access to reports and so on. A new report from Forrester Research suggests that the next wave of productivity lies in providing flexible "BI Workspaces" to the oranization's few analysts and power users. Overcoming the classic tech struggle between autonomy and centralized control, BI Workspaces are said to offer a best-of-both-worlds environment in which experts can analyze and model vetted data without facing IT constraints.

Just what are "BI Workspaces"? The Forrester Report, "BI Workspaces: BI Without Borders," defines them as "a data exploration environment where a power user can analyze production, clean data with near complete freedom to modify data models, enrich data sets, and run the analysis whenever necessary, without much dependency on IT and production environment restrictions." The primary examples of these environments are multidimensional OLAP (MOLAP) slice-and-dice analytics, BI and data warehousing delivered Software as a Service (SaaS) style, and in-memory analytics platforms. This article explains why report author Boris Evelson writes that one or more of these capabilities must now be on the list for any leading-edge BI environment.

Why Your Arms Are Tied

The quest for the proverbial "single version of the truth" and various compliance requirements have in many ways restricted the flexibility of reporting and analysis, according to Forrester. As an example, corporate security, data privacy and regulatory requirements are often an obstacle to open and timely access to information. What's more, despite ever-faster-and-more-powerful processing capacities, analyst and power-user demands still take a back seat to day-to-day transactional loads. Perhaps most restrictive is the architecture of many BI environments, which creates a "cascading effect of interdependent components" (see chart at right).

chart: Cascading Effects of Independent BI Components
Cascading Effects of Independent BI Components
(click image for larger view)
"Most BI environment architectures use several components (sometimes more than 30!), such as data discovery, transformation and integration, data modeling, online analytical processing (OLAP), reporting, dashboards, and alerts, and involve as many steps for raw data to reach its final destination in a report or a dashboard," writes Evelson. "One simple change to even a single source data element may result in a few changes to extract, transform, load (ETL) and data cleansing jobs, which may turn into several data model changes in operational data store (ODS), data warehouse (DW), and data marts; this in turn affects dozens of metrics and measures that could be referenced in hundreds of queries, reports, and dashboards."

All too often, power users, analysts and business users alike have attempted to work around these restrictions by resorting to spreadsheets, but this approach no longer works. "Aside from the lack of controls and huge operational risk, spreadsheets are just not powerful enough to analyze terabytes of data involved in any modern, competitive decision-making," Evelson writes.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Previous
1 of 2
Next
Comment  | 
Print  | 
More Insights
Slideshows
Top-Paying U.S. Cities for Data Scientists and Data Analysts
Cynthia Harvey, Freelance Journalist, InformationWeek,  11/5/2019
Slideshows
10 Strategic Technology Trends for 2020
Jessica Davis, Senior Editor, Enterprise Apps,  11/1/2019
Commentary
Study Proposes 5 Primary Traits of Innovation Leaders
Joao-Pierre S. Ruth, Senior Writer,  11/8/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Getting Started With Emerging Technologies
Looking to help your enterprise IT team ease the stress of putting new/emerging technologies such as AI, machine learning and IoT to work for their organizations? There are a few ways to get off on the right foot. In this report we share some expert advice on how to approach some of these seemingly daunting tech challenges.
Slideshows
Flash Poll