Database modernization for internal services team at major global technology company
Challenge
- An internal services team at a globally-recognized tech company sought to improved enablement of downstream self-service business intelligence
- Need to redesign data models and ETL processes being used to support an ever-growing volume of activity and make operations more resilient
Solution
Neal Analytics architects assisted in fixing performance issues and designed a more resilient ETL and DW approach for the services team to improve overall data services. Key activities included:
- Data model analysis and improvements
- Utilization of new features in SQL Server
- Deployment of Virtual Machines within Azure
- Created SQL Server cubes
- Created a hybrid cloud / on-premise solution
- High Availability / Disaster Recovery
Result
- Greatly increased performance (ETL efficiency, business intelligence accessibility, etc.)
- ETL and DW now scale to handle billions of transactions monthly
- Continuous improvements to reliability and availability of the database
