DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

6.8. EXERCISES

1. Match the columns:

   information package diagrams need for drill-down data transformations data sources data aging sophisticated analysis simple and complex queries data volume specialized DSS corporate data warehouse

   determine data extraction provide OLAP provide data feed influences load management query management in DBMS low levels of data larger staging area influence data design possible pollution source data staging design

2. It is a known fact that data quality in the source systems is poor in your company. You are assigned to be the Data Quality Assurance Specialist on the project team. Deseribe what details you will include in the requirements definition document to address the data quality problem.

3. As the analyst responsible for data loads and data refreshes, describe all the details you will look for and document during the requirements definition phase.

4. You are the manager for the data warehouse project at a retail chain with stores all across the country and users in every store. How will you ensure that all the details necessary to decide on the DBMS are gathered during the requirements phase? Write a memo to the Senior Analyst directly responsible to coordinate the requirements definition phase.

5. You are the Query Tools Specialist on the project team for a manufacturing company with the primary users based in the main office. These power users need sophisticated tools for analysis. How will you determine what types of information delivery methods are needed? What kinds of details ...