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
MODULE 1: The Data Warehouse Migration Challenge
MODULE 2: Design and Performance considerations in a DW Migration
MODULE 3: Migrating Data, ETL processing and Loading
MODULE 4: Data Warehouse Security and Operations Migration
MODULE 5: Migrating Data Visualisation and Reporting
MODULE 6: Minimising SQL Differences during migration
MODULE 7: Cloud Data Warehouse vendor and 3rd Party Migration tools
MODULE 8: Beyond Data Warehouse Migration – moving to a modern DW on the cloud
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.
If you can not participate this course, you can send someone else instead of you. If cancellation is done less than 14 days before the course start, we will charge 50% of the price. In case of no show without any cancellation, we will charge the whole price. Cancellation fee will also be charged in case of illness.