Dealing with Spreadmarts: Strategies for Migrating to a Managed BI Environment

BI & DW Hype: 8 for ’08 Real-time Business Intelligence (BI): Give People What They Need – And Not What They Don’t
January 22, 2008
BI & DW Trends: 8 for ’08 Dazed and Confused: Product Roadmaps, Upgrades & Migrations
January 25, 2008
Show all

Dealing with Spreadmarts: Strategies for Migrating to a Managed BI Environment

I recently co-authored with Wayne Eckerson of TDWI the Best Practices Report and webinar: "Dealing with Spreadmarts: Strategies for Migrating to a Managed BI Environment."

Anyone who has read my articles and blog knows I often talk about data shadow systems. Read this report and listen to this on-demand webinar for the latest thinking and research on spreadmarts/data shadow systems.

About the Best Practices Report

In organizations all over the world, business people bypass their IT groups to get data from spreadmarts. Spreadmarts are data shadow systems in which individuals collect and massage data on an ongoing basis to support their information requirements or those of their immediate workgroup. These shadow systems, which are usually built on spreadsheets, exist outside of approved, IT-managed corporate data repositories, such as data warehouses, data marts, or ERP systems, and contain data and logic that often conflict with corporate data. Once created, these systems spread throughout an organization like pernicious vines, strangling any chance for information consistency and reliability. You’ll find them in all industries, supporting all business functions. According to TDWI Research, more than 90% of all organizations have spreadmarts.

The technical remedy for spreadmarts is to manage and store data and logic centrally in a uniform, consistent fashion and then let individuals access this data using their tools of choice. At TDWI, we call this a managed business intelligence environment. The goal is to transform spreadmarts into managed spreadsheets. This lets IT do what it does best—collect, integrate, and validate data and rules—and lets business analysts do what they do best—analyze data, identify trends, create plans, and recommend decisions.
Download the Report

About the Webinar

One of the most insidious problems in data warehousing is the proliferation of spreadmarts—spreadsheets and Access databases that masquerade as data marts. Created independently, these data shadow systems deliver a fragmented view of the enterprise and an inconsistent view of the business that cripples the business. This Webinar will show how spreadmarts are a symptom of a larger problem and then outline strategies for migrating organizations to a managed BI environment that delivers a single version of truth.
Watch this TDWI Webinar

(Click for more business intelligence webinars)

Leave a Reply

Your email address will not be published. Required fields are marked *