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!!!
Смотрите видео Setting up the Contoso Retail Dataset in SQL Server онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Greyskull Analytics 20 Апрель 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 8,884 раз и оно понравилось 230 людям.