Extreme Scoping: How to Ensure Data Quality in Your Data Warehouse Through Iterative Development
Larissa Moss
President
Method Focus, Inc.
Tuesday
8:30am - 5:00pm
Level: Intermediate
A DW is not a DW unless it has two components: data management (cleaning up the data chaos) and data delivery (front-end applications and end-user access tools). Yet, most companies put more emphasis on data delivery than on getting their data under control. There are several reasons for this. Using the 80/20 rule, data management is 80% of the total effort as compared to 20% for building applications with BI tools. Second, untangling (rationalizing) redundant and inconsistent data is tedious work and a lot less impressive on a resume than using new BI tools. But the main reason is that business users are pressing for quick deliverables (90 days or less) while constantly “refining” their requirements, and DW teams scramble to oblige. The end result is often a collection of non-integrated independent data marts – always with the promise to consolidate them later, which regrettably rarely happens. Does this dilemma have another solution? Can you “have the cake” (address data management) "and eat it too" (produce quick deliverables)? In this tutorial, Larissa will explain the solution she calls “extreme scoping.”
You will learn about:
Larissa Moss is the founder and president of Method Focus Inc. She has 26 years of IT experience, with a focus on data warehousing for the past 18 years. She frequently speaks at conferences worldwide on the topics of data warehousing, business intelligence, information quality, project management, development methodologies, and other information asset management topics, such as enterprise architecture, data integration, and information quality. She is co-author of Data Warehouse Project Management, Impossible Data Warehouse Situations, Business Intelligence Roadmap: The Complete Project Lifecycle for Decision Support Applications, and Data Strategy. She can be reached at methodfocus@earthlink.net.