How to install SQL Server and import sample data

A local SQL Server install can be a great way to learn SQL and makes a great data source for a Power BI portfolio! Here’s how to download, install SQL Server, and import Microsoft’s AdventureWorks database with SQL Server Management Studio (SSMS). Then we connect to it with Power BI. We also walk through the easy way to import a CSV as a table in SQL Server.

Links used in the video--
SQL Server:

AdventureWorks Sample Database

0:00 Intro
0:26 Download & Install SQL Server & SSMS
2:22 Download AdventureWorks
3:11 Connect and import the database to SQL
5:47 How to import from CSV to SQL
7:21 Connect in Power BI
8:35 Gateways

[stanzy]

Thank you so much for this video! I was going round in circles with SQL and SSMS trying to set up the AdventureWorks database (from a different incorrect website link I found). This was such a quick and easy tutorial which I wish I had found hours ago. Thanks again 😀

[arpangiri]

Thank you! Hope this helps you with the algorithm.

[marcorozzano]

thank you so much for this video, Christine ! i've attempted to install the AdventureWorks database a handful of times. the process was more complicated than i expected and would eventually give up. after watching your video, it turns out that it *is* that complicated 😂. however, your video makes it much easier to follow and ultimately install a sample database to play with. thanks again and keep up the great work :)

[avixx]

Great video! You're a good teacher

[graytonw]

Great tutorial! If you have only a handful (18-20) users who will be writing to the database infrequently, would SQL Server Express do the job if it's installed on a local file server, or is it only meant to single-user access on a local machine?

[joelluis]

Hi,
Did you delete your video showing how you built the "Green report" from scratch ? :(
I saved your video in my favs and wanted to follow that tutorial this week as an inspiration to build a report but I noticed that the video is not available anymore.

I call it "Green" because I remember most of the report page was in green. It's the same report you used on your other video explaining how to use "Text in Power Bi"