Modern Data Architecture using Microsoft Azure
What you'll learn
- Navigate the Azure Portal
- Create Resource Groups and Provisioning in Azure
- Create and Load an Azure SQL Database
- How to load a Azure Data Lake
- How to move data using Azure Data Factory
- How to Configure and use Data Bricks
- How to provision and load a Azure Data Warehousing
- Connect Power BI to your Azure Synapse Analytics Data Warehouse
Course content
- Preview01:18
- Preview04:51
- Preview01:43
- Preview02:58
- Preview03:39
- 09:07Creating Data Lake Storage
- 09:30Setting up a SQL Server
- 12:44Loading Data Lake with Data Factory
- 02:10Auto running Jobs using Data Factory
- 08:48Configuring and setting up Data Bricks
- 11:30Staging Data into Data Lake
- 06:16Provisioning a Synapsis SQL Data Warehouse
- 07:35Loading Data into your Data Warehouse
- 04:04Exploring your Data using Power BI
- 01:18Deprovisioning your Resources
- 00:09Free eBook
Requirements
- Basic understanding of SQL and Data Warehousing Principles
Description
A hands on walk through of a Modern Data Architecture using Microsoft Azure. For beginners and experienced business intelligence experts alike, learn the basic of navigating the Azure Portal to building an end to end solution of a modern data warehouse using popular technologies such as SQL Database, Data Lake, Data Factory, Data Bricks, Azure Synapse Data Warehouse and Power BI.
Who this course is for:
- Beginner Business Intelligence Developers
Instructor
Director of Business Intelligence and Technology with extensive background as Senior Enterprise Data Architect. Over 15 years of experience in Business Intelligence and Data Warehousing solutions with implementations across Real Estate, Finance, Consumer Goods, Software Products, Pharmaceuticals, Sales and Professional Services, Government and Healthcare industries. Roles on these projects across various horizontals include cloud modernization, user experience architect, data modeler, data architect, solutions developer and business analyst. Knowledge of Business Intelligence tools across the Microsoft BI stack, including: SQL Server, Analysis Services, Integration Services, and Reporting Services as well as Big Data fundamentals.