data_warehouse

Enterprise Data Warehousing

The Enterprise Data Warehouse of this organization had become quite slow after the re-platforming of their Oracle and Business Objects Warehouse in to the Ware house operating with MicroStrategy, Tableau, and custom .Net applications with Teradata database.

Our principals led a major performance tuning effort. The activities included: Troubleshooting Application versus Network to differentiate between web experiences and report execution time; Fact based optimization on SQL; Implementation of Development Standards and Guidelines; Design and Code reviews; Migration Approvals and Performance review; Implemented Workload Management; Introduced the concept of ‘Design for Performance’; Monitoring and measurement of usage; profiled data and brought visibility to data quality issues early and often.

This initiative resulted in significant reduction system resource usage and highly significant improvement in production throughput and speed.

WANT TO KNOW MORE ABOUT WAVICLE DATA SOLUTIONS?