The Data series management module provides a collection of navigation and editing features for management of all data series and data points stored within the FEWS NET Data Warehouse. The module ties into multiple other modules such as Data entry, and Metadata management, to perform the following operations, all within a single module.
Data series operations:
Browse published and unpublished data series
Chart data series
Add new data series
Edit existing data series
Delete unpublished data series
Download data series
View data series audit history
Data point operations:
Browse data points
Add new data points
Edit existing data points
Delete unpublished data points
View data point audit history
Note: Only users with the appropriate administrative rights can perform the operations outlined above. To review data viewing and editing permissions visit, Categorization and permissions.
Data series operations
Browsing data series
Data series are organized via categories that correspond to Data domains. Once a data series category is selected, the corresponding data series are visible in table format. The column headers, filters and organization of the table are dynamic based on the type of data series selected. For example, the first column header for Acute Food Insecurity Classification data series is titled Geographic unit versus Reporting country for Trade data series.
Charting data series
Several data series categories include options to display the data points as a time-series chart. To view data series chart:
Select the desired data series from the table view. The system will display a Data series information page.
From the Data series information page, select the Chart button
The system will display a Data series chart page with the option to copy an Excel Web Query link for offline access to the data series.
Adding new data series
To add a new data series:
Click Add from the data series table view. The system will then display the Data series information page.
Complete the fields within the Data series information page.
Select one of the Save prompts. A confirmation message will appear when complete.
! Important note: To add a new data series, the necessary metadata must exist within the FEWS NET Data Warehouse system. If the required metadata does not exist, it must be created and registered using the Metadata management module.
For each data series category, there are unique metadata requirements. These requirements are outlined below:
Exchange rates
To add a new Exchange rate data series, the following information is required:
From currency
To currency
Rate type:
Interbank: the monthly averages from OANDA
Government: For example, official fixed exchange rates
Secondary: For example, unofficial exchange rates
Source document
Note: Before adding an Exchange rate, registration of the currency types are required by navigating to Metadata management > Common > Currency.
Market products
To add a new Market products data series, the following information is required:
Geographic unit
Scale
Scenario
Description
Source document
Note: Before adding a Market Product, registration of the Product in the system is required using Metadata Management > Common > Classified Products page
Price index
To add a new Price index data series, the following information is required:
Name
Base value
Source document
Trade flow quantities
To add a new Trade flow quantity data series, the following information is required:
Reporting Country
Border Point
Source
Destination
Product
Unit
Flow Type:
Export
Import
Re-export
Documentation Type
Formal: Level of documentation is fully documented
Informal: Level of documentation is not fully documented
Source Document
Acute food insecurity phases
To add a new Acute food insecurity phase data series, the following information is required:
Geographic unit
Scale
Scenario
Source document
Acutely food insecure population estimates
To add a new Acutely food insecure population estimate data series, the following information is required:
Geographic unit
Scale
Scenario
Source document
Humanitarian food assistance
To add a new Humanitarian food assistance data series, the following information is required:
Geographic unit
Scale
Scenario
Source document
Humanitarian response
To add a new Humanitarian response data series, the following information is required:
Geographic unit
Operator
Operation type
Indicator
Source document
Crop production estimate
Adding Crop Production Indicator data series is done through automated Import into the system via the Import functionality page. To access the Import functionality page, navigate to: Data entry > Import data points > Import crop production estimate values.
Nutrition Indicator
Adding Nutrition indicator data series is done through automated Import into the system via the Import functionality page. To access the Import functionality page, navigate to: Data entry > Import data points > Import nutrition indicator values.
Population Estimate and Census
Adding Population indicator data series is done through automated Import into the system via the Import functionality page. To access the Import functionality page, navigate to: Data entry > Import data points > Import population estimate and census values.
Editing data series
To Edit a given data series:
Select the desired data series from the table view. The system will then display the Data series information page.
From the Data series information page, modify the information with the fields as needed.
Select one of the save prompts. A success message will display if the edits have been applied.
Deleting data series
If necessary, unpublished data series can be deleted. For published data series, this functionality is not available. To delete data series, follow the steps below:
Using the Checkboxes, select the desired data series from the data series table view. Multiple data series can be selected at once.
From the Action drop-down list, select the option, Delete selected data series. Confirm the selection by clicking, Go. This will open a summary page.
From the summary page, confirm the intent to delete the selected data series.
Note: Deleted data series cannot be recovered.
Downloading data series
Data series can be downloaded in CSV format. To download a data series, follow the steps below:
Select the desired data series from the table view. The system will then display the Data series information page.
From the Data series information page, locate and select the Download button.
Once the file is downloaded, the system will display a file save location dialog box. Select the desired location to save the file and confirm.
Data series history
The FEWS NET Data Warehouse system tracks various events that are performed against data series data including the addition, update or deletion of data series data in the system.
Select the desired data series from the table view. The system will then display the Data series information page.
From the Data series information page, locate and select the History button.
Then the system will display the Change history page with details of the updates and other operations carried out against the selected data series record.
Data point operations
To view individual data points within a data series, open the Data series management dropdown menu from the Data Warehouse system menu and select Data points. The data series data points pages list the currently available data series values in a grid format with the following headers. For example, how many kilograms per pound and other common, and non-common values and conversions are included within the Data points section of the Data series management module.
Browsing data points
Unlike Data series, Data points are organized without data domain categories, instead relying on free-text Search functionality and alphabetic ordering.
Making use of search and filters is key to quickly locating specific data point values.
Adding data points
Users can upload/import a bulk file of data point values into the system using the Import functionality. To import data point values in a file into the system:
From the data point value table view, locate and select the Import data series value button. This will open the Import page.
Upload a file and specify the file’s format from the Format drop-down list.
Click Submit to start the import process.
Once the file is uploaded, the system will display the summary including:
New: the data in the file that will be imported.
Updated: the data in the file that are updates to existing data in the system.
Delete: the records in the file that will be deleted from the system.
Skip: the records in the file that will be skipped.
Error: the records in the file that have errors in the data and will not be added to the system.
Total: total number of records in the file.
To continue with the import, select Confirm import. The data series will be imported and a confirmation message will appear when complete.
Editing data points
An existing unpublished data point value can be modified. To Edit a data point value:
Select the desired data point value from the table view. The system will then display the Change value page.
Modify the record information as needed and
Select one of the Save prompts. A confirmation message will appear when complete.
Deleting data points
If necessary, unpublished data point values can be deleted. For published data point values, this functionality is not available. To delete data point values, follow the steps below:
Using the Checkboxes, select the desired data point values from the table view. Multiple data points can be selected at once.
From the Action drop-down list, select the option, Delete selected unpublished values. Confirm the selection by clicking, Go. This will open a summary page.
From the summary page, confirm the intent to delete the selected data series.
Note: Deleted records cannot be recovered.
Viewing history data points
The FEWS NET Data Warehouse system tracks various events that are performed against data series data, including the addition, update or deletion of data series data in the system.
Select the desired data point value from the table view. The system will then display the Data point value information page.
Select the History button.
Then the system will display the Change history page with details of the updates and other operations carried out against the selected data point value.