Data Warehouse Requirements Checklist

Data Warehouse Requirements Checklist

Project Name

Date

Stakeholders’ Names, Titles, Contact Methods

Business goals: (Detail the goals that the data warehouse must satisfy.)

Current problems to solve: (Detail the business problems that the data warehouse will solve.)

High-level functions: (Detail the high-level business functions that the data warehouse will serve. A high-level walkthrough of the business processes involved helps visualize what’s going on at this level).

Success Criteria: (Detail the metrics for success.)

User Profiles (Describe the types of end-users of the data warehouse. Attach a User Profile Matrix as a chart for quick reference. Capture both technical and business user roles.)

User Task Descriptions: (How do the users complete key tasks using the current automated or manual system that the data warehouse will replace or supplement? Itemize and describe primary user tasks, detailing the Business Process Model.)

Re-engineered Task Descriptions: (How will the new data warehouse enable users to complete key tasks that are being re-engineered?)

Constraints: (List all known technical, budgetary, resource and other constraints that will prohibit satisfying these Requirements. Identify showstoppers.)

Please or Register to post comments.

IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottOur Experts will show you:
• Common SQL Server
Problems
• Best Practices for T-SQL
• SQL Server Integration
Services
• Database Development

Come See Mike Otey & Tim Ford in Person!

Early Registration Now Open

From the Blogs
May 21, 2013
blog

A Common Misconception about MAXDOP

Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.