Data Manager

Overview

The Data Manager allows you to select and structure the data that you want to display in the dashboard. The Data Manager of all data layers can be accessed via the Data button DataManagerButton at the top menu.

The Data Manager dialog consists of two main sections: the Source Data and the Data Model:

AGOL_DataManagerDialogUS

Source Data

The Source Data panel lists all the data that is available for your dashboard, i.e. the fields of your feature layer, the fields from any CSV files you have added and the fields you have selected from the Data Store.

  • Feature Layer

All feature layers contain a list of table attributes which can be used as indicators in the dashboard. By default all attributes of the selected feature layer are listed in the first folder.

  • CSV Files

There are two ways you can add a CSV file to the Source Data panel: from your Dashboard Builder account or from CKAN portal.

Click here to find out how to add CSV data from Dashboard Builder account.

Click here to find out how to add CSV data from CKAN portal.

  • Data Store

The Data Store contains a set of useful publicly available UK data that you can use in your own dashboards. The data includes Mid-year population estimates; Index of Multiple Deprivation 2015; Jobseekers Allowance Claimants; Crime Statistics; Educational attainment figures.

Data Model 

The data model section on the right hand side shows the data that is shown in your dashboard. By default, all fields from the feature layer are listed here. To add a field simply click and drag it from the data source to the data model.

Feature ID Field

You can assign one of the fields of your feature layer as feature IDs. Feature IDs are needed as common identifiers if you want to use any CSV data or comparison areas. The field that is used for feature IDs should hold unique values for all your features. If you do not plan to use a CSV file or comparison areas you do not need to assign feature IDs.

fid

After adding a CSV file you will not be able to change your feature ID again.

Name Field

One field of your feature layer should be assigned as a Name Field. This field will then determine the names of the features in your dashboard as they appear for example in the first column of the table.

Filters

If you like you can assign one or more fields from your feature layer to the Filters section. This field should group the available features into different categories, for example counties could be grouped into regions. As soon as a field is assigned as a Filter a filter button will automatically appear in the dashboard. Clicking on this filter button will open the filter explorer which lists all categories of the filter field. Applying a filter category (e.g. a specific region) will then suppress all features that do not belong to this category in the map and the associated widgets. The filter can then be cleared by clicking the corresponding button in the map or table.

Properties

You can assign fields to the Properties section that include data that are the same for all of your features, independently of the indicator data. The properties can then be displayed in the map tooltips.

Data hierarchy

Below the Properties section you can build the hierarchy of your data.

The data hierarchy consists of themes, indicators and indicator dates. Indicator dates are not mandatory but can be used if you want to display any time series data. It is also possible to add associates to your indicators that provide additional data or information.

  • Themes are the highest elements in the hierarchy and are used to group indicators thematically. A new theme can be added by pressing the ‘Add Theme’ button at the bottom of the data manager. When hovering over a theme name with the mouse cursor several editing icons appear:
    • : click this icon if you want to rename your theme
    • : click this button to add a sub-theme to your data hierarchy. Every theme can have several sub-themes (and sub-sub-themes). Every sub-theme must include at least one indicator.
    • : use these icons to move your theme up or down in the data hierarchy
    • : click on the bin icon to permanently remove your theme. Please note that deleting a theme will also remove all indicators and associated data within the theme as well.
  • Indicators hold the data you want to map in your dashboard. To add a new indicator to your data model drag the corresponding feature layer or CSV file field from the data source on top of the theme you want to group the indicator in. Once the indicator is in the data model you can edit it by clicking on one of the editing icons that appear when you hover over the indicator name:
    • : click on this icon if you want to rename the indicator, add or change the indicator date or change the data type of the indicator. The data type can be either numeric or categoric. By default, indicators from feature layers will use the data type that was set up in the feature layer for the corresponding field. Indicators from CSV files will always be regarded as numeric if you do not change this setting. To save your changes, please click the save button. To discard your changes, click on the cross symbol.
    • : Use these icons to move the indicator up or down within the theme.
    • : click on the bin symbol to delete this indicator. Please note that when you delete an indicator all corresponding associates are deleted as well.

Practical advice

From a practical point of view the following steps are recommended when building your data model:

  1. If you plan to use CSV data or comparison areas assign a suitable feature ID field.
  2. Assign a Name field.
  3. Clear the data hierarchy that you got when first creating your dashboard. It is very likely that you want to arrange your data in the data model in a different way. Please note: pressing the clear button will only affect the data hierarchy, the filters and properties but not the feature ID field or the name field.
  4. Think about how you want to group your data and add themes in which you want to sort your indicators.
  5. Drag the indicators you want to map in the dashboard from the data source to the corresponding themes. The Shift key will allow you to select and drag several indicators at once.
  6. Make sure that your indicator dates (if you have any time series data) and the data type of the indicators (numeric or categoric) are correct.
  7. Add filters or properties if you like.
  8. Once you are happy with your data model, press the Apply button. If you hit the Close button instead you will lose all changes made.
  9. You might want to download the data model file by clicking to save it on your local machine for safety or to upload it to a different dashboard. To upload a data model file, please click .