Workflow

In KDW the system allows F.O to enter the data accordingly to the requirements the H.O has set. No matter what KDW Data Warehouse component, the workflow process is the following:

a. Enter data

b. FO Submit the data

c. HO and specialists Review the data

d. Comments can be made

e. FO can correct and make comments when the data if set ‘Under Review’

f. Data can be submitted as many times it is required

e. When data has been through quality control it can be Published

In addition to the general rationale, there is specific components rationale:

Prices:

  • Add a Data Collection, which involve the Metadata values from a product price in a given market with additional related information for that product as required by the HO.

  • Enter the collection periods according to a schedule (i.e. monthly) to ensure the Data Collection for a product has enough Data Points to conduct the analysis that will lead us to make further decisions.

  • You may upload data in bulk or manually.

  • Publish it (please consider the workflow process involved as explained above/before)

  • Use it for Data Analysis:

    • Download Data Series individually or in Data Sets

    • Build Multiple Data Series using a Price Data Set with a predefined purposes

    • Calculate Data Series for Calculated indices or Relative Prices

    • Download data for other type of analysis outside the data Warehouse

  • Data Series Management and Metadata Management

    • Set Exchange Rates so that Data Analysis can reflect real prices calculations

    • Predefine market products, so that users can add the relevant data for the relevant product and a list is provided with commodity names and codes.

    • Establish price indices that have been calculated outside the Data Warehouse. I.e. CPI

Surveys

:

  • Before entering data you must add a survey. Adding a survey means that you need to define the survey metadata. It concerns: Enter the 1st Survey Collection. This implies uploading a file with the actual values according to the survey metadata that has been defined when adding a survey.

    • Data Domain

    • Source Organisation

    • Survey Type

    • Name

    • Usage Policy

    • Survey Populations

    • Indicators

    • Schedule

  • Edit your Survey or access it to change the status after submitting. This implies entering the system so that you can see/edit the uploaded values when adding the 1st Survey Collection.

  • Download the data to work with pivot table templates for further analysis outside the Data Warehouse.

  • Use the metadata management settings to classify Survey information according to (only HO):

    • Spatial classification in geographic units, types, zones etc.

    • Indicators groups

    • Indicators

    • Localities

    • Survey types

    • Surveys