For most companies today the attraction of cloud computing is too tempting to ignore and one of the areas, that is a high priority, is analytics. Many companies are looking take to advantage of new technologies available on the cloud for real-time analytics, machine learning, and analysis of huge volumes of multi-structured data, to add to what they already know.  However, given that their core analytical systems are data warehouses and data marts sitting in their data centers, it’s not surprising that migrating these systems to the cloud is high on the agenda.

This 1-day course details what is involved in migrating data warehouses and data marts to cloud-based Analytical Relational DBMSs such as Amazon Redshift, Google Big Query, Microsoft Azure SQL Data Warehouse, IBM DB2 Warehouse on Cloud, Oracle Autonomous Data Warehouse, Snowflake, and Teradata Vantage on Cloud.

Why attend

You will learn:

  • What should be in a data warehouse migration plan
  • Pre-migration preparation
  • Defining a data warehouse migration strategy
  • The risks that can threaten the chance of success and how to de-risk a project
  • How to migrate a data warehouse schema, data, and ETL jobs and security while minimizing the impact on business users
  • Understanding SQL differences
  • Whether you should migrate an existing data warehouse ‘as is’ or try to make changes during migration?
  • Existing data warehouse DBMS specifics you need to know about in a migration
  • Migration tools to help you 

Who should attend

CDO's, CIO’s, IT managers, CTO's, business analysts, data analysts, data scientists, BI managers, business intelligence and data warehousing professionals, enterprise architects, data architects.

Code: CDW2021
Price: 725 EUR

Inquire about this course

Related articles

Coronavirus (COVID-19)



The Data Warehouse Migration Challenge

  • Why migrate your data warehouse to the cloud?
    • Business case
    • Technology
  • Planning for a data warehouse migration
  • Pre-migration preparation
    • Roles and responsibilities
    • Skills and training
    • Assessing your existing data warehouse
    • On-premises preparation
    • Cloud preparation
  • Defining a migration strategy
  • De-risking your data warehouse migration project

Design and Performance Considerations in a DW Migration

  • Defining schema migration scope
  • Preparing for schema migration
    • Options for migrating existing data warehouse schema to the cloud
  • Options for migrating existing data mart schema to a cloud-based data warehouse
  • Performance options on your target cloud-based data warehouse
  • Existing data warehouse database design migration specifics

Migrating Data, ETL Processing, and Loading

  • Migrating your historical data to a cloud-based data warehouse
  • Migrating your ETL jobs to a cloud-based data warehouse
  • Migrating load processing to a cloud-based data warehouse
  • Existing data warehouse database data, ETL and loading migration specifics

Data Warehouse Security and Operations Migration

  • Beyond SQL DDL and DML migration
  • Azure, AWS and GCP security overview
  • Database authorization and access control
  • Automating migration of privileges from an existing system
  • Dynamic data masking
  • Connecting to cloud-based data warehouses
  • Data Encryption in cloud-based data warehouses
  • High Availability (HA) and Disaster Recovery (DR) in cloud-based data warehouses
  • Existing data warehouse database security migration specifics

Migrating Data Visualization and Reporting

  • Migrating reports and visualizations – the challenge
  • Minimising the impact of DW migration on BI tools and reports using data virtualization
  • Identifying high priority reports to migrate first
  • Migration incompatibility issues that can impact reports and visualizations
  • Testing report and dashboard migration to your cloud-based data warehouse
  • Migrating BI tool semantic layers to your cloud-based data warehouse
  • Conclusions and recommendations

Minimizing SQL Differences During Migration

  • SQL issues that can occur when migrating to a cloud-based data warehouse
  • SQL Data Definition Language (DDL) differences and workarounds
  • SQL Data Manipulation Language (DML) differences and workarounds
  • SQL Data Control Language (DCL) differences and workarounds
  • Extended SQL differences and workarounds

Cloud Data Warehouse Vendor and 3rd Party Migration Tools

  • Cloud data warehouse vendor migration tools
  • Third party data warehouse migration tools
  • Third party data warehouse automation tools

Beyond Data Warehouse Migration - Moving to a Modern DW on the Cloud

  • Beyond data warehouse migration – new capabilities on cloud-based data warehouses
  • Modernizing your ETL processing in a cloud environment
  • Integrating your cloud-based data warehouse with data science technologies on the cloud
  • Integrating live streaming data into your cloud-based data warehouse
  • Creating a logical data warehouse using data virtualization


Mike Ferguson

Mike is Managing Director of Intelligent Business Strategies Limited.  As an analyst and consultant he specializes in business intelligence and enterprise business integration. With over 35 years of IT experience, Mike has consulted for dozens of companies. He has spoken at events all over the world and written numerous articles.  Mike is Chairman of Big Data LDN – the fastest growing Big Data conference in Europe, and chairman of the CDO Exchange.  Formerly he was a principal and co-founder of Codd and Date Europe Limited – the inventors of the Relational Model, a Chief Architect at Teradata on the Teradata DBMS, and European Managing Director of Database Associates.  He teaches popular master classes in Analytics, Big Data, Data Governance & MDM, Data Warehouse Modernisation, and Data Lake operations.


24 Sep24 Sep
Virtual Live Class


The fee for this 1-day course is EUR 725 (+VAT) per person.

We offer the following discounts.

  • 10% discount for groups of 2 or more students from the same company registering at the same time.
  • 20% discount for groups of 4 or more students from the same company registering at the same time.

Note: Groups that register at a discounted rate must retain the minimum group size or the discount will be revoked. Discounts cannot be combined.

Copyright ©2021 quest for knowledge