Experience / Case Studies

Case Study: Wireless Equipment Manufacturer - KPI Cloud Analytics on Amazon Redshift and Tableau

Wireless Equipment Manufacturer

A leading global provider of mission-critical communication products and services with customers in over 100 countries.  Our products and services help government, public safety and commercial customers improve their operations through increased effectiveness, efficiency, and safety of their mobile workforces.   

Business Needs

Wireless Equipment Manufacturer needed to reduce license, support and training costs for its Oracle BI portfolio while ensuring that user needs were met and exceeded. Wireless Equipment Manufacturer had an expensive Oracle BI apps platform running on an on-premise Oracle database and using Oracle BI as the reporting tool.  In addition to its high cost, the Oracle BI platform had performance issues, lacked key capabilities such as data visualization and was very slow to implement.

Selection Criteria

Wireless Equipment Manufacturer initially embarked on a journey to build a custom data warehouse on Amazon Red Shift with Tableau. However, this process was taking a long time. KPI proposed using its pre-built solution: KPI Cloud Analytics for Amazon RedShift and Tableau. Wireless Equipment Manufacturer selected the following modules: Accounts Payable, Accounts Receivables, Projects, General Ledger and Fixed Assets.

KPI did a 6 week POC for Accounts Receivables and delivered a solution 2x as fast and at 75% cost savings over the custom build approach. Wireless Equipment Manufacturer was so pleased with the results that they green lighted a project to deliver an additional 4 KPI Cloud Analytics modules.

What KPI Delivered

KPI delivered five KPI Cloud Analytics modules using a blended onsite and offshore team consisting of business experts in finance, Amazon Red Shift experts and Tableau experts. KPI worked with Wireless Equipment Manufacturer to extend the solution to include near real time reporting as well as a data security model.

The KPI team implemented Amazon Red Shift best practices such as optimized distribution and sort keys, parallel data loads, etc. KPI also implemented Tableau best practices such as user-friendly Tableau Data Sources, a Tableau friendly data security model.

Business Benefits

The KPI Cloud Analytics solution reduced software licensing, hardware and support costs while giving business users a more agile solution for financial reporting including visualization, user self-service and significantly improved performance.

Tags: Case Study, KPI Cloud Analytics, Amazon Redshift, Tableau, Oracle EBS R12, Financial reporting, KPI Cloud Analytics on Amazon Redshift and Tableau



Subscribe to the Case Studies