The process of hosting your data warehouse in the cloud starts at the Microsoft Azure portal. In this video, database expert Adam Wilbert shows you how to create a new resource group and deploy an Azure SQL Data Warehouse.
- [Adam] To create an Azure SQL Data Warehouse … you'll need a Microsoft account and an Azure account. … There's a free option if you'd like to test out the service, … and you can find out more information about that … by going to azure.microsoft.com … and then following the links for Start Free. … Once you have an account set up, … go ahead and login to the portal at portal.azure.com … and you'll be presented with the dashboard. … In order to create an Azure SQL Data Warehouse … click on the link to create a resource … over on the left hand side of the screen, … then from the Azure Marketplace click the databases link, … and then underneath Featured … select the SQL Data Warehouse link. … That'll start up the configuration process. … The first thing we need to choose is our subscription. … I'm on a pay-as-you-go plan, … but you might be on a free account. … Go ahead and select that from the dropdown menu here. … Then we need to configure a resource group. … This will contain all of the different kinds of resources …
Author
Adam Wilbert
Released
10/23/2019- Transactional databases vs. data warehouses
- Star and snowflake schemas
- Creating a data warehouse
- Designing tables and views
- Rebuilding columnstore indexes
- Creating an Azure SQL Data Warehouse
- Establishing control flow beyond ETL
- Enforcing data quality
- Configuring Master Data Services
- Consuming data from the warehouse in BI services
Skill Level Intermediate
Duration
Views
-
Introduction
-
Set up the example databases2m 32s
-
1. Data Warehouse Foundations
-
Data warehouse core concepts3m 58s
-
Dimensions and facts5m 1s
-
Star and snowflake schemas3m 50s
-
Hardware and infrastructure2m 35s
-
-
2. Create a Data Warehouse
-
Design dimension tables5m 46s
-
Design fact tables3m 33s
-
Create an indexed view3m 28s
-
3. Columnstore Indexes
-
4. Implement an Azure SQL Data Warehouse
-
5. Extract, Transform, and Load (ETL)
-
Understand data flow3m 12s
-
Establish control flow1m 54s
-
6. Enforce Data Quality
-
Cleanse data with DQS6m 48s
-
7. Master Data Services
-
Install MDS and IIS4m 37s
-
Deploy a sample MDS model6m 35s
-
Install the MDS Excel add-in2m 28s
-
Update master data in Excel3m 40s
-
8. Consume Data from the Warehouse
-
Conclusion
-
Next steps1m 3s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create an Azure SQL Data Warehouse project