An evaluation of relational database systems determines the most suitable engine for a data warehouse. This report is an example of a comparative analysis of data warehouse database tools.
How do you select the best data extraction/transformation toolset for your data warehouse? Evaluate features, functionality, vendor reputation... the works. Follow the example set by this robust tool evaluation.
This example will help you put in place logical as well as physical database design standards for building data warehouses using Business Objects.
What is the best way to get data from the legacy system(s) into the new system? Design your conversion routines to organize the process.
What data should you keep in a Data Warehouse and why? This form helps you identify the needed data and its associated characteristics in relation to your business requirements.
A handy spreadsheet for recording Data Warehouse QA issues, from data transformation to report generation problems.
Here's a template, with attached examples, for testing your Data Warehouse canned queries (analytical reports).
Need help selecting a Data Warehouse toolset? You must consider many factors regarding vendor service and reputation, tool functionality and tool quality against your technical and business requirements when selecting Data Warehouse construction and implementation tools. Let this matrix guide your selection.
Map the transformation of the data elements from source system tables to data warehouse target tables.
What's the password? Do the right and only the right people know how to get into the system? Document the procedures and access priveleges and restrictions for keeping your application package system secure.
|
"The best way to cheer yourself up is to try to cheer somebody else up." - Mark Twain |
