Single Data Series¶

Window: Select data series to change¶

• Name: Depending on the type of Data Series, the metadata that make up the name varies. This will be explained under each data series type below.

• Data Series Id: Each Data Series has an Id. Number. When you access the system, it is under data series URL ([https://fdwdev.fews.net/en/admin/warehouse/dataseries/

68161¶

/?_changelist_filters=q%3Dmaize](https://fdwdev.fews.net/en/admin/warehouse/dataseries/68161/?_changelist_filters=q=maize)), you can change the Id. Number to the one you are looking for and when you press enter, the system will take you to the Data Series you require.

• Source Document:  After selecting the relevant Data series, when you click the Source Document, the system will take you to where you may access or add another source organisation as well as revise other related details: Usage policy, usage last changed, current schedule, first and last period date, collection period count and a list of Data Series within that Source Document. In other words, the Source Document where your data series belongs. Note the Display order is only relevant for prices data series to set up what goes first in the excel spreadsheet (market then product) so that the system can recognise the data. In addition you may edit the schedule as well as add another schedule.

• First/last period date: It refers to the first period when data was entered and the last period when data was entered. In other words, the timeframe for that data series or the collection.

• Data point count: The number of values entered within a collection. In surveys it represents the value for each indicator within one collection or collection period(s). In prices it represents the price values that make up a tendency line. One price per period within one single data series.

• Search box: You can use the search box to narrow your search by entering keywords. When you click in one Data Series, the system will take you to a different window.

• In Prices

  • Price Single Data Series

  • Calculated Price indices

  • Calculated Relative Prices

  • CPI

  • Exchange rates

  • Cross Border Trade Data Series

Window: Change data series¶

The metadata listed on the previous window can be seen as already explained.

• Data Sets: you can see the data set(s) where the data series belongs under Chosen data sets box, or simply select one if required by clicking on it under Available data sets and pressing next the blue arrow. If the Data Series belongs to a large Data Collection (long timeframe), you can narrow the number of collection periods to reduce the amount of data you want to have in your data set. This can be done by selecting the start date and the end date within that data series collection. The system will select the relevant price values within the data collection periods that make up the price data series collection.

• Excel Web Query: You can access the URL to extract the data series data. See Offline Analysis using Microsoft Excel for more detailed information.

• Browse: When clicking on Browse from the chosen data series you will get a table showing the information from the chosen data series classified according to the H.O setting (defined metadata).

  • You can scroll down to see all Data points deriving from collection periods within that data series collection you selected.

  • Each row represents a data point of the data series.

• Chart: When clicking on Chart, it shows an interactive chart that displays the data as a line graph plotting the price for each Collection Period.

  • Manipulating the Graph

    • Move the mouse around the graph and see the values from the pop up window in different periods.

    • Note that if there are more than six Data Series in the Graph, you will only be able to see the average

  • You can view the data points in time all along the tendency line:

    • The legend shows the Data Series Metadata

    • The popup window shows the values for each data point from the data series in the legend

  • Percentage changes from data series collection periods can be visualised from the graph but not measured in percentages like from the manual data entry window in data collection/collection periods

  • There are two types of Zoom

    • Top left: shows the data according to years

    • Bottom: It is a flexible period selection

    • If you have selected the dates in the previous window, which if not selecting dates by default the system will gather all the available data, then the graph will only include the dates for your search. I.e. Rather than providing the data of 10 years, it will only show the data of the past 2 years (if that was your selection)

  • Chart context menu is for printing the Graph or download it in different available formats: PNG, JPEG, PDF, SVG files

• History: Is the Detail Audit Trail access

• In Surveys:

  • Nutrition Data Series

  • Crop Production Data Series

Window: Change data series¶

Data Series is very useful for online data exploration provided there are more than one Data Points. Otherwise offline analysis using Microsoft Excel after downloading the data will be more useful.

The metadata listed on the previous window can be seen as already explained.

• Data Sets: you can see the data set(s) where the data series belongs under Chosen data sets box, or simply select one if required by clicking on it under Available data sets and pressing the blue arrow. If the Data Series belongs to a large Data Collection (long timeframe), you can narrow the number of collection periods to reduce the amount of data you want to have in your data set. This can be done by selecting the start date and the end date within that data series collection. The system will select the relevant indicator values within the Survey Collection periods that make up the data series Survey Collection.

• Excel Web Query: You can access the URL to extract the data series data. See Offline Analysis using Microsoft Excel for more detailed information on Download Survey Data.

• Browse:

• Chart:

• History: Is the Detail Audit Trail access.