RFP-Warehousing/Database & Dashboard Development

The Rhode Island Commerce Corporation seeks a vendor to design, build, and maintain a centralized data warehouse and interactive dashboard suite that aggregates the state’s tourism‑industry data from dozens of sources. The solution must ingest and store data (monthly, quarterly, annual), provide inbound/outbound APIs, enable dynamic visualizations (visitor flows, regional analysis, spend, sentiment, economic indicators), support manual uploads, integrate with Simpleview CRM, and deliver ongoing support and optional enhancements. The work includes secure data hosting, API development, BI/dashboard construction on the agency‑selected platform, integration of multiple external data feeds (STR, Google Analytics, VisaVue, TSA, etc.), mobile‑location tracking, and the ability for internal staff to create additional reports. • Build a secure, centrally‑managed data warehouse with automated loading from a long list of tourism‑related data sources. • Develop inbound/outbound APIs and integrate the warehouse with Simpleview CRM and other agency systems. • Create interactive dashboards/reports (cross‑visitation maps, region‑level filters, advertising spend analytics, economic indicators) using the agency’s chosen BI tool, plus provide training, support, and optional future development.