Case Study
Project cost analytics solution implementation using Oracle BI Cloud Service
Download Case StudyAbout 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
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%