Best Practices in Data Warehousing

Data warehousing has been a successful approach for supporting the important concept of knowledge management— one of the keys to organizational success at the enterprise level. Based on successful implementations of warehousing projects, a number of lessons learned and best practices were derived from these project experiences. The scope was limited to projects funded and implemented by federal agencies, military institutions and organizations directly supporting them. Projects and organizations reviewed include the following: • Census 2000 Cost and Progress System • Defense Dental Standard System • Defense Medical Logistics Support System Data Warehouse Program • Department of Agriculture Rural Development Data Warehouse • Department of Defense (DoD) Computerized Executive Information System • Department of Energy, Lawrence Livermore National Laboratory, Enterprise Reporting Workbench • Department of Health and Human Services, Health Care Financing Administration (HFCA) Teraplex Integration Center • Environmental Protection Agency (EPA) Envirofacts Warehouse • Federal Bureau of Investigation (FBI) Investigative Data Warehouse • Federal Credit Union • Internal Revenue Service (IRS) Compliance Data Warehouse • Securities and Exchange Commission (SEC) Data Warehouse • U.S. Army Operational Testing and Evaluation Command • U.S. Coast Guard Executive Information System • U.S. Navy Type Commander’s Readiness Management System