We provide course about Migrating SQL Server Datawarehouse to Azure in english. You have a Datawarehouse and a BI solution in place. You probably have some doubts about how it will scale or if it is aligned with modern trends. Then this workshop is for you!
Course description:
A modern data warehouse lets you bring together all your data at any scale easily, and allows you to get insights through analytical dashboards, operational reports, or advanced analytics for all your users. The cloud, of course, provides all of that and more but with a complex mixture of services, that you need to carefully select. You need to plan your costs, your data movement, modeling engine, data storage and most importantly - how are you going to consume that data in an optimal way.
Choosing the right service for the right task is crucial if you want scalable, performant and easy to maintain platform. In this workshop you will get an architectural overview of the Azure BI Data Platform stack with focus on industry patterns, strategies to migrate existing DWH and BI solutions, including SSIS, SSAS, SSRS to an environment, where only the sky is the limit.
You will understand what is behind the buzzwords like Data Lake, Azure Analysis Services, Azure DataBricks, Azure Data Factory and Azure Data Lake, and you will get familiar with them. You will dive into the modern DW concept and Synapse Analytics. You will get all the help you need and the knowledge to select the right data architecture or data pipeline for your scenario, and then select the Azure services and technologies that best fit your requirements.
Training overview:
This migration training is focusing on describing the Azure services that participate in the modern Datawarehouse deployment first (such as Azure Data Lake, Azure Data Factory, Azure SQL DB, Azure Synapse Analytics, Azure Analysis Services, PBI). It also covers extension of the traditional DWH with big-data scenarios and potential services and how they integrate with the traditional data flow.
During the hands-on part of the workshop we take an on-premise deployment of SQL Server Integration Services, SQL Server Database and SQL Server Analysis Services, that is pre-prepared by Inspir-IT, and migrate it to Azure, discussing the different migration scenarios and deciding what is the best approach out of all available ones.
Agenda:
• Day 1: Services Overview
• Day 2: Approaching a migration, lift and shift to the Cloud
• Day 3: Tune and Modernize
• Day 4: HandsOn
• Day 5: Design and Planning session
Instructor: Magi Naumova
Margarita Naumova is a very well-known SQL Expert. Magi holds the highest possible SQL Server Technical Certification in the field - Microsoft Certified Master, making her one of the best SQL Server Experts Worldwide. Magi is also a Microsoft Data Platform MVP (Most Valuable Professional). She has more than 20 years of SQL Server and BI technologies consulting and training experience and is a trusted advisor for many large companies in SQL Server Platform Area.
Currently she works as a Managing Partner and Chief SQL Architect of Inspir-it AS, her own newly established Consulting Company in Norway. Margarita is a regular speaker at the largest IT events, SQLBits, SQL Saturday in Europe.
Target audience:
Datawarehouse specialists, data experts, BI developers and all others who deal with data and are responsible for creating, managing and maintaining your company’s Datawarehouse solution.
Prerequisites:
• Experience with SQL Server Relational DW, star schema, SSIS, SSAS
• Azure Fundamentals or similar
Language:
• English course material and english speaking instructor