Northwind Data Set

Introduction

In this lesson, you are going to load the Northwind dataset you will need for the course.

You will need to:

Download the Northwind graph data model.
Create a new graph data model
Open the Northwind dataset in the Import tool
Run the import

Northwind Dataset

The Northwind dataset contains data about a fictional company called Northwind Traders, which imports and exports specialty foods from around the world.

The graph data model contains nodes and relationships for Customers, Orders, Products, Categories, and Employees.

mermaid

Northwind Graph Model

graph TD
    Territory -->|IN_REGION| Region
    Supplier -->|SUPPLIES| Product
    Product -->|PART_OF| Category
    Shipper -->|SHIPS| Order
    Customer -->|PURCHASED| Order
    Employee -->|SOLD| Order
    Employee -->|IN_TERRITORY| Territory
    Employee -->|REPORTS_TO| Employee
    Order -->|ORDERS<br/>unitPrice<br/>quantity<br/>discount| Product
    
    Territory(("<b>Territory</b>"))
    
    Region(("<b>Region</b>"))
    
    Supplier(("<b>Supplier</b>"))
    
    Shipper(("<b>Shipper</b>"))
    
    Product(("<b>Product</b>"))
    
    Category(("<b>Category</b>"))
    
    Order(("<b>Order</b>"))
    
    Customer(("<b>Customer</b>"))
    
    Employee(("<b>Employee</b>"))

Create a graph data model

Continue with the lesson to create the graph data model

You will need to:

Download the Northwind dataset.
Create a new graph data model in the Import tool.
Use the Open model (with data) function to open the Northwind dataset.
Run the import to create the graph data model.

Import the Northwind dataset

You need to download the complete Northwind dataset and create a new blank graph data model:

Download the complete Northwind dataset
Open the Import tool in Aura and select Graph Models.
Open Import Tool →
Create a new graph data model.
Use the … menu to Open model (with data) and select the northwind-complete.zip file you downloaded.
You will see the tables (csv files) from the Northwind dataset and the graph data model.