Database modernization for internal services team at major global technology company

Database modernization for internal services team at major global technology company

Challenge-V2

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-V1

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