Data Warehouse design

 This is a Sources Sought (SS) / Request For Information (RFI). DO NOT submit a quote or proposal in response to this RFI.  The USAF Academy (USAFA) is seeking interested sources and information concerning capable vendors for Data Warehouse Design and Implementation services. The United States Air Force Academy (USAFA) is required to provide reports on Institutional effectiveness, key performance indicators, and analyze the efficacy of its business processes in educating and training future Air Force officers. With its current data architecture, the ability to produce accurate and consistent reports or perform analysis is often slow and difficult. MITRE Corporation, at the request of USAFA, was tasked to design a data warehouse logical model that would support enterprise-wide reporting, enable a self-service reporting capability, and facilitate the capture of high-quality and timely data for analytical purposes. The data warehouse logical data model is the preliminary step in building

a business intelligence environment that will allow for accurate, integrated and consistent reporting while providing access to data across the enterprise. An alternative approach is to perform the desired self-service reporting, data capture and analytics within an existing data warehouse structure built and maintained by USAFA. This approach will obviously result in very different methods and costs and should be considered when preparing responses. Interested sources are encouraged to provide the following information:•a.      Company name, address, cage code, DUNS Number, NAICS codes, name of point of contact, telephone number and email address;•b.      Small business status (service disabled veteran owned small business, HUB Zone, 8(a) minority business enterprise, etc.), if any.•c.       Please identify which NAICS code you perform this work under.•d.      Have you ever performed these requirements on federal Government contracts?•e.      Are there any aspects of this requirement which are not consistent with current industry practices?•f.        Describe any experience your company has with designing and implementing data warehousing and business intelligence environments in the DOD and or Higher Education domains.•g.      Describe a recommended technical approach you would use to development a satisfactory data warehouse and business intelligence environment.•h.      Is your company staffed to be flexible and scalable to handle both short-term peaks and long-term business needs in the development and maintenance phases? •i.        How would you plan to provide and support a self-service reporting capability in the multi-domain environment such as variations in policies and best practices between and among ".gov", ".mil", and ".edu" domains?•j.        Does your company offer proactive network and system monitoring and reporting services? •k.       Will you need to subcontract any of the components to deliver the necessary •l.        capabilities?•m.    What is a rough cost estimate to deliver and sustain the capability described here?  Or do you have projects similar to this?  If so, what was the estimated cost for those?  As much as possible please provide relevant costing tables for both labor and materials for a commercial cloud hosted environment (FedRAMP+/DOD Impact Level 4).•n.      How long will it take to implement?  Please provide a sample, generic timeline to estimate large milestones from contract award to full implementation.•o.      System must employ multi-factor authentication for accessAttachment #1: USAFA Enterprise Data Warehouse Design and Implementation Recommendations, outlines the overall requirements of the requested Data Warehouse and a recommended design of the United States Air force Academy's (USAFA) "To Be" enterprise data warehouse (EDW). The design is composed of a logical data model for the warehouse environment as well as implementation considerations for the development phase of the warehouse project. Vendors are encouraged to propose industry's best practices and solutions that can meet our requirements and should not limit themselves to the recommended design presented in Attachment #1.  Attachment #2: Business Analytics. Knowledge and Information Management Process Maps and a spreadsheet that outlines basic analytic requirements and shows the extent of USAFA data analytics illustrate the following issues.USAFA seeks an enterprise business analytic capability to do complex, routine and ad hoc reporting and analysis. The system would draw data from the data warehouse referenced above and would be able to add additional data sources in the future. The system should enable USAFA to easily combine data from the data warehouse with other data sources at the user level. The system should provide user friendly tools to access data, export data, assess data, report on data, create and maintain interactive dashboards, and exert data governance and maintenance. Data producers should be able to protect personally identifying data from the consumers of the interactive dashboards. USAFA has a communityof about 50 heavy analytic users (information producers), 400 average analytic consumers, and both internal to USAFA's network and external information consumers.  Attachment #3: Notional Operational View Level 1 (OV1) architecture diagram depicting how the data warehouse may be envisioned to interface with USAFA applications and their associated production databases. Provide responses not later than 12:00 pm Mountain Daylight Time on 9-May-2018.