Loading data
Last updated
Was this helpful?
Last updated
Was this helpful?
You must load data before you can configure charts. There are three ways to load data:
Upload a data file
Connect to sample data
Connect to a database table
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.
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
movie_trends
olympic_medals
video_game_sales
world_happiness_report_2020
If your report is connected to a database, you can select the schema and table (or view) to use as the data source. If you are interested in connecting your report to a database, please reach out to us by emailing us at help@myjuicebox.io or by starting a chat from the Help menu (click the Help icon at the top right of the report header or workspace home page). The following databases are supported:
Redshift
Snowflake
Postgres
BigQuery
SQL Server
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.
🎛 LEGO sets ( or see the data in a ). Source:
🎬 Movie Trends ( or see the data in a ). Source:
🥇Olympic Medals 1896-2012 ( or see the data in a ). Source: International Olympic Committee, The Guardian Datablog, and
🎮 Video Game Sales ( or see the data in a ). Source: . A helpful getting started to create a dynamic bar chart.
😀 World Happiness Report 2020 ( or see the data in a ). Source: and
