CapRelo was looking to upgrade their aging database. 1Rivet helped to define a solution of a unified data warehouse to manage their data from 2 separate databases (CapView and Phoenix).
Client dashboard and reporting integrated to newly created Data Warehouse
Stored procedures updated to use newly created data warehouse
Reporting to utilize new Data Warehouse
Outcome
GAP Analysis of existing Data Warehouse
Use of SSIS to fetch the data from Capview to Phoenix to build the new Data Warehouse
All reporting migrated to new Data Warehouse
Share This
Industries
Transportation & Mobility
Capabilities
Data Architecture Engineering, Data Visualization Analytics, Quality Engineering, Technology Platform
Scope Of Service
Architecture Design, Development, Manual Testing, Program Management, Requirement Gathering