Desktop User Guides > Professional > Data management scripting > Data Management overview
Data Management overview
UNICOM Intelligence Professional includes these components that facilitate data management tasks:
Transferring data
You can transfer data from one format or location to another. For example, when you collect data using UNICOM Intelligence Interviewer - Server, it is stored in a relational MR database and you can use a DataManagementScript (DMS) file to transfer the data to an IBM SPSS .sav file so that you can analyze it using IBM SPSS.
Merging data
You can use a DataManagementScript (DMS) file to combine the case data from two or more data sources into a single data source. For example, if the case data for your survey has been collected in separate data sources, you might want to merge the data before cleaning and analyzing it.
Filtering data
You can use filters to restrict the transfer to certain variables or respondents. For example, you might want to create filters to restrict the transfer to specific variables that record demographic details and to include respondent data only if the interview was completed in the last 24 hours.
Cleaning data
This involves correcting errors and anomalies in the case data. For example, checking whether more than one response has been selected for each single response question, and if so, marking the case as requiring review or taking some action to correct the problem such as randomly selecting one of the responses and removing the others. When cleaning data, it is usual, but not necessary, to store the “clean” data separately so that the original data remains intact.
Publishing data
You can publish live data, via DMS scripting, to reporting applications (namely IBM Cognos Business Intelligence). The feature is designed to provide enterprise level reporting, analysis, score-carding, and event notification.
Setting up weighting
This involves creating special weighting variables that can be used to weight data during analysis; for example, so that it more accurately reflects the target population.
Creating new variables
You can define filter variables and other derived variables, which can then make analysis easier. For example, if a questionnaire asked respondents to enter their exact age as a numeric value, you might want to create a derived categorical variable that groups respondents into standard age groups.
Scripting tables
If you have UNICOM Intelligence Reporter, you can create batch tables using a script.
Data Management infrastructure
Data management scripting