Project cost analytics solution implementation using Oracle BI Cloud Service | Jade

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

Oracle

Complicated business logic to derive various metrics

Oracle

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

Oracle

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%
Back to Top ↑