Spinner

Data Warehouse Implementation

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).

CapRelo
  • 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

Overview

Industries

Transportation & Mobility
Transportation & Mobility

Capabilities

Data Architecture & Engineering
Data Architecture & Engineering
Technology Platform
Technology Platform
Data Visualization & Analytics
Data Visualization & Analytics
Quality Engineering
Quality Engineering

Scope of service

Program Management
Program Management
Architecture & Design
Architecture & Design
Requirement Gathering
Requirement Gathering
Development
Development
Manual Testing
Manual Testing

Technology

1TrakIt Cloud Application Modules:
No items found.
No items found.

Related cases

Related cases