Load data into your Aura instance
To create dashboards in Neo4j Aura, you will need to:
-
Connect to a Neo4j database - either an Aura instance or local instance.
-
Either upload a CSV file - from local system or from Cloud storage, this requires knowledge of how to Import data.
-
OR Run the import-recommendations.cypher script provided in this lesson, this will load all the necessary Movies Recommendation dataset nodes and relationships.
-
Map properties from the CSV file to the node
-
Run the import
Step 1: Connect to your database
To import data using the Import data service in the console, follow these steps: * Select a data source, either from other cloud storage or local CSV files. * Select a model, either create/generate one, or use an existing one. * Map files to the model. * Select the instance to import into. * Enter credentials.
Use the connection details of your Aura instance to connect.
If you have any existing on-prem Neo4j database, you can also connect to it by entering the connection details.
If you have an existing data importer model, you can clear it by selecting the Clear all option from the menu ….
Any data import you run will be against the connected Neo4j database.
Step 2: Navigate to the Query Editor
After connecting to your Aura instance, you will need to navigate to the Query Editor in order to load data using Cypher.
At this point, you do not need to understand Cypher in detail; you will only run the script that loads the data.
Step 3: Import the Movies Recommendation dataset
Use the following Cypher script to create the Movies Recommendation dataset in your Aura instance:
Download the import-recommendations.cypher script
You can copy and paste the script into the Query Editor, and click the Run button to execute it.
An easier way to quickly see the imported data is to run the following command in the Query Editor:
CALL db.schema.visualizationThis will display a visualization of the database schema, showing the nodes and relationships that have been created.
In the Explore tab, you need to search for a node label or use the Show a graph snippet button in the empty state to view part of the graph. image::images/run-query.png[The import-recommendations.cypher script in the Query Editor]
Once the script has finished running, you will see a summary of the nodes and relationships created in your Aura instance.
Go to the Explore tab to visualize and explore the data you have just loaded:
If this is your first time using Dashboards, you will see an empty state with options to Create with AI, Create from scratch, or Import. You do not need to use the dropdown menu in this case.
Generating a demo dashboard using AI
Once you have successfully loaded the data into your Aura instance, you can generate a demo dashboard using the AI tool.
You will learn more about creating and managing dashboards in the next lessons, but for now, let’s see how to quickly generate a dashboard using AI.
Prior to using the AI tool, ensure that you have read the AI disclaimer available in the Aura Dashboards interface:
From the Dashboards menu, click on the Create dashboard dropdown, and select Create with AI.
Use the graph visualization to explore the relationships between users, movies, and genres interactively:
In the prompt dialog, enter a description of the insights you want to visualize. For example, you can enter a description like "Visualize movie recommendations based on user ratings and genres.", or simply "Comedy movies":
After you run the prompt, the AI will generate a dashboard based on your description:
In this dashboard, you can see various visualizations such as single values, bar charts, pie charts, and graph visualizations that provide insights into movie recommendations based on user ratings and genres. You will learn more about each type of chart in the following lessons.
Use the graph visualisation to explore the relationships between users, movies, and genres interactively:
Before moving to the next lesson, take your time to explore the different cards and visualisations generated by the AI tool.
Check your understanding
Dashboards requirements
Which of the following requirements should you follow when planning to create a dashboard in Neo4j Aura Dashboards?
-
❏ Use Aura Business Critical for exploring and learning about dashboards.
-
❏ Create multiple Aura instances to host different dashboards.
-
✓ Import data for exploring and learning about dashboards.
-
❏ Use complex Cypher queries to visualize data relationships.
Hint
Think about what you need to do before creating dashboards in Aura.
Solution
-
Use Aura Free for exploring and learning about dashboards.
-
Use a single Aura instance to host your dashboards.
-
Import data for exploring and learning about dashboards.
-
Use simple Cypher queries to visualize data relationships.
Getting access to Aura Dashboards
Why is the Dashboards canvas page empty when you first access it?
-
❏ Because you need to pay extra.
-
✓ Because you need to import data first.
-
❏ Because you need to create another account.
-
❏ Because you need to install additional software.
Hint
Think about what is required to visualize data in dashboards.
Solution
To visualize data in Aura Dashboards, you first need to import data into your Neo4j Aura instance. Without any data, the dashboards canvas will be empty as there is nothing to display.
Summary
In this lesson, you learned how to load data into your Aura instance using a Cypher script and generate a demo dashboard using the AI tool.
In the next lesson, you will learn how to describe your movie data model and design dashboards that align with stakeholder requirements.