The Data series management Series Management module provides a collection of navigation and editing features for the 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, Entry and Metadata managementManagement, to perform the following operations , all within a single module.:
Data
...
Series operations
...
Browse published and unpublished
Data Series by Data Domain category
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
...
| Info |
|---|
Only users with the appropriate administrative rights can perform the operations outlined above. To review data viewing and editing permissions, visit |
...
...
...
Data
...
Series operations
Browsing
...
Data Series
Data series Series are organized via into categories that correspond corresponding to Data domains. Once a data series specific Data Domains, which are reflected in the dropdown menu (e.g., Data Series Management > Price > Exchange Rates).
Once a Data Series category is selected, the corresponding data series Data Series are visible in a table format.
The table's 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 unitUnit versus Reporting countryCountry 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 seriesData Series:
Click Add from the data series Data Series table view. The system will then display the add Data series information Series page.
Complete the fields within the add Data series information Series page.
Select one of the Save prompts. A confirmation message will appear when complete.
| Info |
|---|
...
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 |
...
added using the Metadata |
...
Management module. |
For each data series category, there are unique metadata requirements. These requirements are outlined below:
...
:
| Expand | ||
|---|---|---|
| ||
Each Data Source Document has a Document Type which specifies the Domain the data is in. At minimum, Data Series within a given Data Source Document consist of an Indicator, Geographic Unit, and Source Document, but can also contain other metadata as described below. Exchange RatesTo add a new |
...
exchange rate |
...
Data Series, the following information is required:
|
...
Source document
...
Market |
...
ProductsTo add a new |
...
market products |
...
Data Series, the following information is required:
|
...
|
...
|
...
|
...
|
...
Price |
...
IndexTo add a new |
...
price index |
...
Data Series, the following information is required:
|
...
Source document
...
Trade Flow QuantitiesTo add a new |
...
trade flow quantity |
...
Data Series, the following information is required:
|
...
Source Document
Acute Food Insecurity PhasesTo add a new |
...
acute food insecurity phase |
...
Data Series, the following information is required: |
...
Geographic unit
...
|
...
Source document
Acutely Food Insecure Population EstimatesTo add a new |
...
acutely food insecure population estimate |
...
Data Series, the following information is required: |
...
Geographic unit
|
...
Humanitarian |
...
Food AssistanceTo add a new |
...
humanitarian food assistance |
...
Data Series, the following information is required: |
...
|
...
Humanitarian |
...
ResponseTo add a new |
...
humanitarian response |
...
Data Series, the following information is required: |
...
|
...
Indicator
...
Source document
Crop production estimate
...
Crop Production EstimateAdding 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. Crop Yield Forecast Crop yield forecast indicator Data Series are added through automated import into the system via the |
...
import functionality page. To access the |
...
import functionality page, navigate to: Data Series Management > Data |
...
Points > Crop Yield Forecast Values > Import Crop Yield Forecast Values. Nutrition Indicator |
...
Nutrition indicator |
...
Data Series are added 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 |
...
Population indicator |
...
Data Series are added through automated |
...
import into the system via the |
...
import functionality page. To access the |
...
import functionality page, navigate to: Data |
...
Entry > Import |
...
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.
...
Data Points > Import Population Estimate and Census Values. Semi-StructuredRequirements beyond the Source Document, Geographic Unit, and Indicator may vary based on the Document Type. Commodity BalanceTo add a new commodity balance Data Series, the following information is required:
|
Charting data series
Several Data Series categories include options to display the Data Points as a time series chart. To view a Data Series chart:
Click the hyperlinked text of the desired Data Series from the table view to navigate to the Data Series information page.
Select the Chart button.
The system will display a Data Series chart page. You can interact with the chart in the following ways:
Hover over a point in the chart to view Data Point values.
Adjust the start and end dates using the zoom options, the From and To date fields, or the time slider at the bottom.
Print or download the chart using the options from the button to the right of the From and To date fields.
...
Editing Data Series
To edit a given Data Series:
Click the hyperlinked text of the desired Data Series from the table view to navigate to the Data Series information page.
Modify the information with the fields as needed.
Select one of the save prompts Save options at the bottom of the page. A success message will display if the edits have been applied.
...
Deleting
...
Data Series
If necessary, unpublished data series Data Series can be deleted. For published data series, this This functionality is not available for published Data Series. To delete data seriesData Series, follow the steps below:
Using the Checkboxes, select the desired data series Data Series from the data series Data Series table view. Multiple data series Data Series can be selected at once.
From the Action drop-down list, select the option , to Delete selected data seriesData 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 seriesData Series.
...
| Info |
|---|
Deleted Data Series cannot be recovered. |
...
Downloading
...
Data Series
Data series can be downloaded in CSV format. To download a data seriesData Series, follow the steps below:
Select Click the hyperlinked text of the desired data series Data Series from the table view . The system will then display to navigate to the Data series Series information page.
From the Data series information page, locate and select 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 Data Series including the addition, update or deletion of data series data in the system.
...
To view the Data Series history, follow the steps below:
Click the hyperlinked text of the desired Data Series from the table view . The system will then display to navigate to the Data series Series information page.
From the Data series information page, locate and select the Select the History button.
Then the system will display the Change history page with Review the change history table for details of the updates and other operations carried out against the selected data series 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 Individual Data Points are organized by Data Domain within the Data Points submenu, accessible via Data Warehouse > Data Series Management > Data Points.
The Data Points pages list the currently available data series Data Series values in a grid table format with the following column 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:
Data Series: the Data Series the data point belongs to.
Period Date: the last day of the Collection Period.
Collection Status: the status of the Data Collection.
Value: the value of the Data Point.
...
Browsing
...
Data Points
Unlike the Data seriesSeries table, 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 the Data Point table uses standardized column headings that are not unique to the Data Domain category and cannot be sorted.
Use keyword searches and the filters options to quickly locate specific Data Point values.
Adding data points
Users can upload/import a bulk file of data point Data Point values into the system using the Import import functionality. To import data point Data Point values in a file into the system:
From the data point 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
Select Choose File to choose the file to be imported.
Specify the file 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 importImport. The data series will be imported and a confirmation message will appear when complete.
Editing data points
An existing unpublished data point Data Point value can be modified. To Edit edit a data point Data Point value:
Select Click the hyperlinked text of the desired data point Data Point value from the table view . The system will then display the Change to navigate to the change value page.
Modify the record information as needed and.
Select one of the Save prompts options at the bottom of the page. A confirmation message will appear when complete.
Deleting
...
Data Points
If necessary, unpublished data point Data Point values can be deleted. For published data point values, this This functionality is not available for published Data Point values. To delete data point Data Point values, follow the steps below:
Using the Checkboxescheckboxes, select the desired data point Data Point values from the table view. Multiple data points 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 seriesData Series.
| Info |
|---|
...
Deleted records cannot be recovered. |
Viewing
...
data points history
The FEWS NET Data Warehouse system tracks various events that are performed against data series data, Data Series including the addition, update or deletion of data series data in the system.
...
To view the data series history, follow the steps below:
Click the hyperlinked text of the desired Data Point value from the table view . The system will then display to navigate to the Data point Point value information page.
Select the History button.
Then the system will display the Change history page with Review the change history table for details of the updates and other operations carried out against the selected data point valueData Series record.