Etusivu / Kurssit / Migrating To A Cloud Data Warehouse

Migrating To A Cloud Data Warehouse

Kurssin esittely

OVERVIEW

For most companies today the attraction of cloud computing is too tempting to ignore and one of the areas that is high priority is analytics. Many companies are looking take 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 centres. 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 warehouse 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.

What 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 ofsuccess and how-to de-risk a project
How to migrate a data warehouse schema, dataand ETL jobs and security while minimisingimpact on business users
Understanding SQL differences
Whether you should you migrate an existingdata warehouse ‘as is’ or try to make changesduring migration?
Existing data warehouse DBMS specifics youneed to know about in a migration
Migration tools to help you

MODULE 1: The Data Warehouse Migration Challenge

Why Migrate Your Data Warehouse to the cloud?
o BusinessCase
o Technology
Planning for Data Warehouse Migration
Pre-Migration Preparationo Roles and responsibilities
o Skills and training
o Assessing your existing datawarehouse
o On-premisespreparation
o Cloud preparation

Defining a migration strategy
De-risking your data warehouse migration project

MODULE 2: Design and Performance considerations in a DW Migration

Defining schema migration scope
Preparing for schema migration
o 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

MODULE 3: 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

MODULE 4: Data Warehouse Security and Operations Migration

Beyond SQL DDL and DML migration
Azure, AWS and GCP security overview
Database authorisation 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

MODULE 5: Migrating Data Visualisation and Reporting

Migrating reports and visualisations – the challenge
Minimising the impact of DW migration on BI tools and reports using data virtualisation

Identifying high priority reports to migrate first
Migration incompatibility issues that can impactreports and visualisations
Testing report and dashboard migration to yourcloud-based data warehouse
Migrating BI tool semantic layers to your cloud-based data warehouse
Conclusions and recommendations

MODULE 6: Minimising 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

MODULE 7: 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

MODULE 8: Beyond Data Warehouse Migration – moving to a modern DW on the cloud

Beyond data warehouse migration – new capabilities on cloud-based Data Warehouses
Modernising your ETL processing in a cloud environment
Integrating you’re 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 virtualisation

+ Lue koko kurssiesittely

Kouluttaja:

MIKE FERGUSON

Managing Director, Intelligent Business Strategies Limited

Mike Ferguson is Managing Director of Intelligent Business Strategies Limited. As an independent analyst and consultant he specialises in data management and analytics. With over 38 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.

Lue lisää

Etusivu / Kurssit / Migrating To A Cloud Data Warehouse