How do you create new groups and delete groups?
To create new groups: Navigate to the folder in which you would like to add a new group. Click on 'Create new group'. Type your new group name in the pop up and click on ‘Save’. To delete groups: Navigate to the group you woFew readersWhat is the Data Upload tool?
The Data Upload tool provides an interface for users to upload and update data for static datasets such as Excel or Dataprep -based integrations. This functionality allows Data Managers to directly manage the updating of their static datasets directly from the platform. Since integrations are built based on the formatting of the original dataset, it is important that any new data uploaded for existing static integrations follow the conventions of the original data. In order to ensure this, theFew readersHow do you navigate the indicator directory?
Click on the hamburger menu button on the far right of the blue ribbon. Click on ‘Data Catalog’ from the hamburger menu. Clicking on 'All Resources' will display a list of all data sources and folders. Once your desired folder is open, click on 'Navigate to Folder' to open it. Alternatively, click into each category group in the table below.Few readersWhat is the process for adding new data sources to the Data upload tool?
Click on the ‘Add Source’ button on the homepage of the Data upload tool. A new window will open. Select the Data Source Type. For a CSV Source: Add the datasource name. Upload a file in csv format. The data must be in the Zenysis Base format which specifies the order of columns in the dataset, i.e. group by 1, group by 2, ..., group by N, date, indicator 1, indicator 2, ..., indicator N. The date values should be in the format YYYY-MM-DD (e.g. 2021-01-01). Click on ‘MappFew readersWhat are 'copy' type indicators?
Copied indicators are indicators that replicate an existing indicator. This allows Data Managers to place a single indicator in more than one location in the Data Catalog. In addition, it also allows Data Managers to define the same indicator in more than one way with different operations or aggregations (e.g. SUM, COUNT etc.).Few readersHow do I create new formula indicators?
Navigate to the folder in which the new indicator will be placed. Click on 'Define new indicator' on the top right of the screen. In the ‘Create Indicator’ pop up, enter the indicator’s name, short name, description and visibility status.Few readersHow are new indicators integrated added to Data Catalog through Field Setup?
New indicators added to existing integrations or through new integrations can be added to Data Catalog using a tool called Field Setup. How? Wait for data to be integrated into Druid before creating new fields to be added to Data Catalog. Field Setup can be accessed by clicking on the hamburger button on the far right of the blue navigation bar and clicking on ‘Field Setup’ in the menu. Note that this tool is available to Site Admins only. New fields get surfaced in the Field Setup page aFew readersHow does the platform data pipeline work?
Integration is the process of combining multiple data sources into a unified data format. The platform integrates data by importing it, running it through a series of cleaning and standardization steps, and finally writing it to a final standard data format. This is orchestrated by the data pipeline. There are several steps in a pipeline: Generate Process Index Validate In the generate step of the pipeline, data is "generated" by running queries or copying from the source data system.Few readersWhat batch operations can I make in the catalog?
Move multiple folders or indicators: In your desired folder, click on the check box to the left of the 'Name' column heading. This will select all items in the folder and all items that you do not want to move need to be unchecked. Click on 'Move to' and select the folder to which the selected items should be moved. To effect the changes, click on 'Apply'. (Few readersWhat is an indicator page in Data Catalog?
The indicator page shows various details about an indicator such as its name, description, data sources, location, operation, formula, etc. It can be accessed by clicking on an indicator record in Data Catalog. On the indicator page, you can edit any metadata items that have the pencil/edit icon next to them, e.g. name, short name, description, location, visibility statusFew readersHow do I upload new data to an existing Dataprep integration?
A new datasource can be uploaded using the following steps: Click on the menu button on the far right of the blue ribbon. Click on ‘Data Upload’ from the hamburger menu. This will open the Data Upload tool homepage and display a list of data sets that have been uploaded. Click on ‘Update Data’ next to the datasource that you would like to update. An ‘Update Data’ modal will appear. Click on ‘Replace File’. Drag and drop a file or click the blue box to select a file from yourFew readersWhat is the difference between a 'replace' and 'append' Dataprep integration?
Replacing a file means changing the single input file that was initially used for integration. Append file, on the other hand, means attaching another file having the same format to the existing file(s) integrated in the platform. When a Dataprep job is run, these files are merged and processed through the Dataprep recipes. All these files are listed and the user can download these input files and also delete an appended input file if needed from the Data Upload tool directly.Few readersHow can I review what dimensions currently have unmatched values that appear as 'empty' in my query results?
This is possible in the Data Digest tool. To do so: Click on the hamburger button on the far right of the blue navigation bar. Click on ‘Data Digest’ on the hamburger menu. Navigate to the ‘Datasource overview’ tab. Navigate down to the section titled ‘Unmatched Dimensions’. It will display all the dimension values that could not get matched in the pipeline.Few readersWhat is the Data Catalog?
Data Catalog enables Data Managers to manage their indicators and augment them with useful information. Specifically this allows: Organizing datasets into a hierarchical structure that is surfaced in the Analyze tool. Hide or make visible specific groups of data. Provide useful metadata to indicators (e.g. definitions, operations etc.) Create new custom calculations. In Data Catalog, the Analyze hierarchical selector is organized in the form of a directory table that resembles a ‘fiFew readersHow do you move groups and indicators in the directory?
In Data Catalog, navigate to the desired folder and click on the three dots on the far right of your indicator or group name. Click on 'Move To' and click on the folder to which you want to move the indicator or group. Click on 'Move to FFew readersWhat is the Data Digest tool?
The Data Digest tool is a tool targeted to Data Managers and Administrators to manage aspects of the integration pipeline. For example, users can access the following information: Pipeline overview: this includes information about the most recent pipeline and a summary of location matching. Data source overview: this includes an overview of the number of data points, indicators, mapped and unmatched location for each data source integrated via the pipeline. Mapping fFew readersHow can I update the platform’s geographic matches?
Navigate to Data Digest. Download mapping file(s) from the Mapping Files tab. For each location in the Unmatched Locations table, find the mapping file row that the location belongs in, then add that location to the first empty match column available for that row. If a location has lots of matches, it might look like you ran out of match columns. For example, maybe the CSV file only went up to match4, but you need to add another possible match for a location. In this case, you canFew readers