Working more productively: tools for administrative data
Related Experiment Video
Updated: Aug 30, 2026

Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering
Published on: November 22, 2019
Leslie L Roos1, Ruth-Ann Soodeen, Ruth Bond
1Manitoba Centre for Health Policy, Department of Community Health Sciences, University of Manitoba, Winnipeg, Canada.
Objective:
This paper describes a web-based resource (http://www.umanitoba.ca/centres/mchp/concept/) that contains a series of tools for working with administrative data. This work in knowledge management represents an effort to document, find, and transfer concepts and techniques, both within the local research group and to a more broadly defined user community. Concepts and associated computer programs are made as "modular" as possible to facilitate easy transfer from one project to another.
Study Setting/Data Sources:
Tools to work with a registry, longitudinal administrative data, and special files (survey and clinical) from the Province of Manitoba, Canada in the 1990-2003 period.
Data Collection:
Literature review and analyses of web site utilization were used to generate the findings.
Principal Findings:
The Internet-based Concept Dictionary and SAS macros developed in Manitoba are being used in a growing number of research centers. Nearly 32,000 hits from more than 10,200 hosts in a recent month demonstrate broad interest in the Concept Dictionary.
Conclusions:
The tools, taken together, make up a knowledge repository and research production system that aid local work and have great potential internationally. Modular software provides considerable efficiency. The merging of documentation and researcher-to-researcher dissemination keeps costs manageable.
Related Concept Videos
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Statistical Software for Data Analysis and Clinical Trials
Overview of Microsoft Excel as a Data Analysis Tool
Statgraphics
Overview of Minitab
Manipulation and Analysis
