Smart Infrastructure & Smart Applications for the Smart Business – Infrastructure & Application Performance Monitoring
Data Warehouse Automation & Real-time Data – Reducing Time to Value in a Distributed Analytical Environment
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 Synapse Analytics, IBM Db2 Warehouse on Cloud, Oracle Autonomous Data Warehouse, Snowflake and Teradata Vantage on Cloud.
CDOs, CIO’s, IT Managers, CTOs, Business Analysts, data scientists, BI Managers, data warehousing professionals, enterprise architects, data architects
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 of success and how-to de-risk a project
- How to migrate a data warehouse schema, data and ETL jobs and security while minimising impact on business users
- Understanding SQL differences
- Whether you should you 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