Synapse demo using AdventureWorks2019 data

In this repo we demonstrate some Azure Synapse Analytics functionality using AdventureWorks2019 Database data.

AdventureWorks2019 Database
Download AdventureWorks sample database
Create Synapse Workspace
Connect Synapse to GitHub
Ingest AdventureWorks2019 into Data Lake
Create Synapse Notebook
Create a dedicated SQL pool
Ingest Models into dedicated SQL pool
Create PowerBI Report

Let's start by creating a Database Server to host the AdventureWorks2019 database.

Search for Azure SQL in the search box on the top of the Azure portal and let's create a new SQL server by clicking the Create button.

On the SQL databases tile, in the Select SQL deployment options page, select Database server and click Create.

In the Create SQL Database Server page, select the Subscription and enter the Resource group (we recommend creating a new Resource group for this demo) enter the server's name.

Enter the authentication information and click the Review + create button.

On the Review + create tab click the Create button.

Wait until the deployment is completed and click Go to resource.

Go to https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms

Download AdventureWorks2019.bak file and follow the steps described in that document.

Next: Create Synapse Workspace