Introduction

The KDW Data Warehouse (Survey) - KDW-S is a web application for entering and analyzing survey data utilizing indicators values from a range of spatial locality specifications according to a schedule that facilitate the collection of data across countries.  With built-in functionality for linking indicators, localities and schedules you can view homogeneous surveys results from different countries across the globe.  The purpose of the KDW-S is to improve data, information and knowledge management for KDWField, Regional and Home Offices. The KDW-S gives you the ability to download your data, so that you can carry out your analyses in an offline setting using Excel or other software. This can be an advantage when Internet connections are unstable.

The nutrition survey component is only one of many sections of the Data Warehouse. Other sections include Price, Agricultural Production, and Livelihoods, that is, studying the ways in which people live, obtain food and income, engage in trade and how such aspects have an effect on their health. You can think of the system as a collection of related Data Warehouses built on a common foundation.

KDW-S application is used for various Data Domains: nutrition, crop production, livestock, etc. It is used for capturing the data from surveys that can be customised accordingly; in other words, it is suitable for generic survey data. We will use nutrition as our example to explain this application.

The system is designed to improve data, information and knowledge management for Field, Regional and Home Offices, including:

  • Easier data collection and consolidation

  • Improved data quality

  • More efficient production of standard reports

  • New tools to support online and offline ad hoc analysis

This User Manual covers the Metadata Management for entering Survey Data in KDW Data Warehouse.

The Data Warehouse provides online tools for data entry and downloads for an offline analysis, including the refreshable Microsoft Excel spreadsheets that can automatically fetch the latest data, to enable offline working when internet connections are unstable.