Adventureworks database schema diagram

broken image
broken image

This will be our Primary Data Source for our B.I Project. Once it is loaded, you should be able to see the AdventureWorks2017 database in your Object Explorer in SSMS

broken image

See here for a variety of methods to do so Once you have that up and running, you will need to load a copy of the Adventure Works Database into your newly created SQL Server Instance. Before we begin, we will need a local instance of MS SQL Server 2017 running, along with SQL Server Management Studio.

broken image