Mike Ferguson

Guidelines for Migrating Your Data Warehouse to the Cloud

Many companies today are looking to migrate their existing data warehouse to the cloud as part of an a data warehouse modernisation programme. There are many reasons for doing this including the fact that many transactional data sources have now moved to the cloud or the capacity of an on-premises data warehouse has been reached with another project looming. Whatever the reason, data warehouse migration can be a daunting task because these systems are often five or ten years old. A lot may have happened in that timeframe and so there is a lot to think about. There are also a lot of temptations and decisions you can make that can increase risk of failure. This session looks at the what is involved in migrating data warehouses to the cloud environment, what options you have and how a migration can cause changes to data architecture.

  • Why migrate your data warehouse to the cloud?
  • The attraction of cloud based analytical DBMSs and data platforms
  • Should you just migrate, re-design, switch DBMSs or do all of this?
  • What are the options and their pros and cons when migrating a data warehouse to the cloud?
  • How can you de-risk a data warehouse migration project before you migrate anything?
  • Steps involved in migrating an existing data warehouse to the cloud
  • Dealing with cloud DW migration issues such SQL differences
  • How will migration affect data staging, ETL processing and data architecture?
  • Integrating data science into a cloud-based data warehouse
    • Training and deploying machine learning models into your cloud analytical database
  • Integrating cloud-based data warehouses, data science and streaming with your BI tools.