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:

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:
title music: written and recorded by ME!!!

Рекомендации по теме

Комментарии

Even with over 30 years of experience with Microsoft products, I would not have figured that out by myself!! Thank you!

cherylenns

Many thanks for this, you made a convulated process dead easy. I was trying to do this in vain. Cheers, now subscribed 👍

londonred

Thanks I've been looking for something like this for a long time. Always felt I couldn't replicate and properly learn Power BI without access to the full Contoso data set. Cheers!

Sullyball

Great video! Very clear and exactly what I needed. Cheers!

danstockdale

That was a great walkthrough and respected the effort in the comedy. This worked like a charm!! You have a new subscriber!

drod

In the part where you click restore in the connections, I do not have that option available to me. I'm stuck as to how to connect to this database.

rachelfrost

Thanks, exactly what I was looking for !

omgwasgeht

If you don't have an existing connection, then RESTORE is NOT AN update this piece for those of us who have never established a connection before.

rachelfrost

Very useful and what I am needing, many thanks

chrisc

Thanks for your video. It helps me a lot

hoangkim

Exactly what I was looking for, great walkthrough

Thursdaysaretheworst

Sir, I am struggling so much to connect to this dataset via Azure and have hunted for hours all over the internet for further information but cannot find anything that can help me figure this out. Please assist.

rachelfrost

Thanks so much... I was looking for link to MS sample databases and SQL Server install instructions, but got so much more... Azure Data Studio is really the cool tool... :) What a pitty, it is not available as VS Code extension :)

pioraj

Hello,

I downloaded the data set. I want to import in excel but its quiet large.

How can i reduce the rows in order to be more suitable for excel?

Vaggelis

I think in some DAX optimization video Alberto Ferrari mentions he's going to test it with "the full contoso model" wich is several gigs in size and I think he says like 200 M rows. Not that I need it at this point, but just curious on where/how he got the larger version.

AgulloBernat