Getting started

Set up a working example of Neo4j dashboards.

Prerequisites

You need:

  1. A Neo4j Aura account

  2. A Neo4j Aura database instance

See Create an account and Create an instance for details.

Add a sample data set

Import the Northwind dataset to your instance:

  • In Aura, select Learning from the navigation.

  • In the Beginner page, select the Learn the basics guide.

  • When prompted to Connect to instance, select the instance where you would like to import sample data.

  • In step 4 of 11 of the guide, import via Get the Northwind dataset.

  • Run the import from the Import page via Run import.

The examples on this page refer to the Northwind dataset.

Create a dashboard

Create a new dashboard:

  1. In the Dashboards page, create a new dashboard, either with LLM assistance or from scratch.

  2. If prompted to Connect to instance, select your instance.

Creating a dashboard with LLM assistance

See Creating a dashboard with AI for details.

Creating a dashboard from scratch

To create a dashboard from scratch:

  1. select Create from scratch.

  2. The UI takes you directly to the new dashboard. To change the title, select the title text and edit it, then confirm.

  3. Your dashboard has a single page titled "Main page". To change the name, hover it and then use the more menu […​] and Edit page name.

  4. Use Add card to create cards which represent visualizations.

Add a card with a bar chart

Create a bar chart which displays the number of orders per customer.

In the dashboard page tab:

  1. Use Add card at the bottom right of the page.

  2. In the new card, select Bar chart from the chart type drop-down at the top right.

  3. Edit the Cypher query of the card and paste the following Cypher query to the input field, then Save:

    MATCH (c:Customer)-[:PURCHASED]->(o:Order)
    RETURN c.contactName AS Customer, count(o) AS Orders
    ORDER BY Orders DESC LIMIT 10

Your bar chart should look like this:

visualization bar chart
Figure 1. Example bar chart

Alternatively, use natural language to create the query for your bar chart.

Add a card with a line chart

Create a line chart which displays the number of product categories by order dates.

In the dashboard page tab:

  1. Use Add card at the bottom right of the page.

  2. In the new card, select Line chart from the chart type drop-down at the top right.

  3. Edit the Cypher query of the card and paste the following Cypher query to the input field, then Save:

    MATCH (o:Order)-[ORDERS]->(p:Product)-[:PART_OF]->(c:Category)
        WITH o.orderDate AS orderDate, count(DISTINCT c) AS categoryCount
    RETURN orderDate, categoryCount
    ORDER BY orderDate
    LIMIT 20

Your line chart should look like this:

visualization line chart
Figure 2. Example line chart

Alternatively, use natural language to create the query for your bar chart.

Next steps

See Managing dashboards for more dashboard options.

See Visualizations to learn about the different charts and visualizations of Neo4j dashboards.