SOURCES SOUGHT
70 -- Data warehouse
- Notice Date
- 11/1/2004
- Notice Type
- Sources Sought
- Contracting Office
- 2251 Lakeshore Dr., New Orleans LA 70145-0001
- ZIP Code
- 70145-0001
- Solicitation Number
- SITC_New_Orleans_MKTSVY_2355E
- Response Due
- 11/8/2004
- Small Business Set-Aside
- N/A
- Description
- The Space and Naval Warfare Command Systems Center New Orleans (SSC NOLA) has developed an enterprise data warehouse (EDW). The enterprise being served is N1 Manpower and Personnel Navy. The main purpose of the EDW is to provide efficient and effective reporting and support tactical and strategic decision-making for Headquarters staff, program managers, decision makers, and fleet units. Personnel, manpower, and financial information from multiple legacy information systems (IS) and other data sources are periodically loaded into the data warehouse and the data made available to end-users via the data marts. These data marts currently supply information to their respective customers via commercial reporting and ad hoc applications. Each data mart has a specific purpose and has views and reports developed with commercial packages, mainly Business Objects. (See Attachment A for the EDW Design Document). There are plans to add additional data marts. There will be additional feeds to the data warehouse from authoritative data sources and interfaces. These plans are broken into separate projects with multiple phases. ? The first project will provide retention data through a web-based graphical user interface (GUI). ? The second project provides data pertaining to sailors? career through both reporting and ad-hoc queries. ? The third and fourth projects provide reports using various graphical representations (pie and bar charts, dashboards, etc.) used in Distribution and Readiness Briefs for the officer and enlisted Navy. Each of these reports requires drill through and drill-down capabilities, as well as, providing alerts and email triggers when thresholds are exceeded. Due to the factors outlined above, we are seeking information regarding technology and technical approaches to address these requirements. We require canned reporting and ad-hoc query capabilities with the ability to manually alter data without impacting or changing the data stored in the data warehouse or data marts. The alteration and adjustment of the data is required on the face of the report and displays themselves prior to presenting the results to those above the individuals in the chain-of-command that make the alterations and adjustments. This would also include storing the manually altered data for historical purposes and the retrieval of this historical data for trend analysis in reporting. On the other hand, the EDW will continue to be updated by the legacy IS. As time progresses, there is a strong possibility of data varying between the EDW and that altered by users of projects three and four. We require the ability to readily identify these differences. Ideally, the solution would be all encompassing, preferably a tightly, integrated solution, but information on all solutions is solicited. This RFI requests information on architectures, interoperability, object and data models, interfaces, etc. of existing Data Warehouse (DW) technology. Refer to Attachment 1 for the EDW Design Document. Appendices have been removed from the EDW Design Document for simplicity and lack of relevance to this effort. Responses to this RFI are due by 4:00 PM on November 22, 2004. See section 3.0 for further details.
- Web Link
-
Click on this link to access the SPAWAR E-Commerce Central Web Site
(https://e-commerce.spawar.navy.mil/Command/02/ACQ/navhome.nsf/homepage?readform&db=navbusopor.nsf&whichdoc=43A2A83E7186BA1888256F40000082A4&editflag=0)
- Place of Performance
- Address: 2251 Lakeshore Dr , New Orleans LA
- Zip Code: 70145
- Country: USA
- Zip Code: 70145
- Record
- SN00702271-W 20041103/041102061905 (fbodaily.com)
- Source
-
FedBizOpps.gov Link to This Notice
(may not be valid after Archive Date)
| FSG Index | This Issue's Index | Today's FBO Daily Index Page |