Setting up the Contoso Retail Dataset in SQL Server
In which Johnny takes you through step by step how to set up a local instance of SQL Server and then import the Contoso Retail Data Warehouse so that you can have your very own database playground for experimenting and building out Power BI solutions.
Ok, maybe a slightly tenuous Power BI link, but hopefully useful for those getting started who want experience interacting with a SQL database.
If you don't know what this has got to do with an avocado and a can of craft ale... well, you're just going to have to watch the video.
References:
SQL Server download: https://www.microsoft.com/en-gb/sql-s...
Contoso dataset: https://www.microsoft.com/en-gb/downl...
Azure Data Studio download: https://docs.microsoft.com/en-us/sql/...
Wide World Importers dataset: https://github.com/Microsoft/sql-serv...
Adventure Works dataset: https://docs.microsoft.com/en-us/sql/...
Chapters:
0:00 Intro
1:45 Download and Install SQL Server
6:27 Introducing Azure Data Studio
8:24 Download and restore Contoso Retail dataset
12:35 Connect to the data with Power BI
#PowerBI #PBI #BusinessIntelligence #SQL #SQLServer
Credits:
background music: https://www.streambeats.com/
sound effects: https://soundbible.com/
gifs: https://giphy.com/
additional sounds: https://www.FesliyanStudios.com
title music: written and recorded by ME!!!
Watch video Setting up the Contoso Retail Dataset in SQL Server online without registration, duration hours minute second in high quality. This video was added by user Greyskull Analytics 20 April 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 8,884 once and liked it 230 people.