Enterprise-Level Data Warehousing

Data warehousing and business intelligence go hand in hand and can provide tremendous value for an organization. FEi has found that iterative approaches to building and enhancing enterprise-level and domain-level data warehousing solutions can provide value earlier to an organization.

Our critical success factors include:

• Developing a vision for the data warehouse adaptable to the business needs
• Stakeholder involvement early in the project to ensure greater success
• Iterative deployment approach gets results early and has flexibility to adjust to business needs
• Finding best combination of design and technology to meet the current and future requirements

Below is a sampling of our experience with enterprise-level data warehousing:

• Developed a consolidated data warehouse to support the Service Accountability Improvement System (SAIS) reporting for the Substance Abuse and Mental Health Services Administration (SAMHSA) for real time operational monitoring of data collection efforts.
• Built a consolidated Data Warehouse to support the Web Block Grant Application System (WebBGAS) that consolidated more than 8 years of planning and performance date for SAMHSA’s Prevention and Treatment Block Grant programs.
• Implemented a new approach for the data warehousing and analytics for the Centers for Medicare and Medicaid Services (CMS) system used to manage Medicare Administrative Contractor Workload Performance. The system called CMIS/PULSE was redesigned with a new data architecture and a visual dashboard to manage provide better insight into MAC contractor performance and workload.
• Created a multi-level data warehouse for a number of WITS customers that allows real time tracking of substance abuse and mental health services treatment programs.  This data warehouse provides a deep set of program performance metrics including financials, outcomes across a number of specific dimensions.
• Developed a data warehouse to support the Unified Export Strategy (UES) system for U.S. Department of Agriculture Foreign Agricultural Service.  FEi Systems modernized the UES web application and implemented the data warehouse to support ad-hoc reporting capabilities.
• Developing enterprise-level data warehouse requirements for the U.S. Department of Agriculture’s Food Safety and Inspection Service to improve overall data integration and analysis.