Skip to main content

Create a dashboard from CSV data

Upload a CSV file to a collection and connect it to a map widget. When you finish, the uploaded clinic locations appear on a dashboard.

Prerequisites​

  • A D.Hub account
  • A CSV file containing location data

To follow this tutorial, use the clinics.csv sample. It contains latitude and longitude columns.

1. Sign in​

  1. Open the D.Hub portal.
  2. Enter your email and password.
  3. Select Sign in.

In an environment that uses SSO, select SSO sign-in and use your organization account. See Troubleshoot sign-in if you cannot sign in.

2. Create a collection​

  1. Open Collections from the sidebar.
  2. Select Create collection.
  3. Enter my_first_project under Name on the single-page form.
  4. Select Create.

Name is required. Complete Alias, Description, and Tags in the same dialog only if needed.

After creation, my_first_project is selected automatically and its detail screen opens. Add assets such as datasets with Add Item after creating the collection.

3. Upload the CSV file​

  1. Continue from the automatically opened my_first_project collection detail screen.
  2. Select + Add Item ▾, then select Quick Add....

Selecting Quick Add from the Add Item menu on a collection detail screen

  1. Drop clinics.csv into the upload area or choose it in the file picker.
  2. Confirm that the preview contains latitude and longitude columns.

Quick Add preview showing the clinics CSV file type and data

  1. Select Upload 1 file.

When the upload finishes, the result list contains the clinics dataset. If a file fails, review the reason in the same list.

4. Create a map dashboard​

  1. Open Dashboards from the sidebar.
  2. Select Create at the top right of the list.
  3. Choose the my_first_project collection as the save location and select Continue.
  4. Enter Clinic locations as the dashboard name.
  5. Select Map in the Widget Library.
  6. Under Analysis Source in Widget settings, select the clinics dataset.
  7. Set the latitude field to latitude and the longitude field to longitude.

Map widget editor showing locations by connecting the latitude and longitude fields from the clinics dataset

  1. When locations appear on the map, select Save.

Verify the result​

The quick start is complete when all three results are present.

  • The my_first_project collection contains the clinics dataset.
  • Location points appear on the map in the Clinic locations dashboard.
  • The saved widget and data connection remain after reopening the dashboard.

Continue learning​