About the Client

RagingWire Data Centers designs, builds, and operates mission critical data centers that deliver 100% availability, high-density power, flexible configurations, carrier neutral connectivity, and superior customer service. The company has 177 MW of critical IT load spread across 2 million square feet of data center infrastructure in Northern California, Ashburn, Virginia, and Texas.

Oracle Cloud Used

Oracle BI Cloud Service
Oracle Data Sync
Oracle Cloud DB

Business Requirements

Build cloud based BI reporting solution
Implement BI reporting capabilities for Project Costing & Project Budgeting

Download Case Study

Business Challenges

Complicated business logic to derive various metrics

Create a drilldown capability to track project costing from summarized to detailed level

Loading data from on premise database to Cloud database

The Solution

Built data-model to use confirmed dimensions to have dimension-wise visibility of metrics and designed DW to suit this kind of reporting
Created hierarchical data for drilling down
Created navigational links to see grain level data from summarized report
Created DataSync Tasks and Jobs to load data from on premise database to Cloud BICS DW
Implemented incremental update logic in DataSync

The Benefits

RDC improved their project invoice reconciliation processes by 50-70% because of availability of BICS reports
Availability of common model in BICS increased the efficiency of business by 25% as it saved business time in trying to gain insights from multiple sources
Publishing and scheduling of BICS reports increased the user adoption by 40%