Loading data
You must load data before you can configure charts. There are three ways to load data:
Upload a data file
Connect to a database table
Connect to sample data
The data drawer is where you set up your data. To open the data drawer, click the bar at the bottom of the editing panel. Click the bar again to close the data drawer.
Upload a data file
To upload the report's first data file, open the data drawer and drag a flat file (CSV, XLS, or XLSX) containing your data onto the data upload box or click Upload CSV or Excel and select the file to be uploaded. The file will be loaded to a BigQuery table and connected to the report.
To load additional data files, first click the + and then drag-and-drop or select your CSV or Excel file.
When loading data files, it is important that your data be nice and clean. Here are some tips for preparing your data.
Connect to a database table or view
This feature is not available on all plans.
If your report is connected to a database, you can select the schema and table (or view) to use as the data source. To set up a database connection, reach out to us. The following databases are supported:
For databases that are not maintained on a cloud platform, we support the latest two release versions. Earlier versions may work with Juicebox, but are not supported.
Connect to sample data
Juicebox also provides a selection of sample data tables if you want to start exploring before you have your own data. To load sample data, open the data drawer, select the Sample Data button, and choose one of the available datasets.
Choose a sample data table and select Add Table.
The sample data includes the following tables.
Sample Data
Description
lego_sets
🎛 LEGO sets (CSV download or see the data in a Google Sheet). Source: Kaggle
movie_trends
🎬 Movie Trends (CSV download or see the data in a Google Sheet). Source: Kaggle
olympic_medals
🥇Olympic Medals 1896-2012 (CSV download or see the data in a Google Sheet). Source: International Olympic Committee, The Guardian Datablog, and Kaggle
video_game_sales
🎮 Video Game Sales (CSV download or see the data in a Google Sheet). Source: Kaggle. A helpful getting started article and video to create a dynamic bar chart.
world_happiness_report_2020
😀 World Happiness Report 2020 (CSV download or see the data in a Google Sheet). Source: World Happiness Report and Data.World
Last updated
Was this helpful?