Documenting the data warehouse: a SAS®-based hands-on workshop

Presenter Bio: 
Mark Smith

Associate Director, Repository and Deliverables, Manitoba Centre for Health Policy (MCHP), College of Medicine, Rady Faculty of Health Sciences, University of Manitoba

Say Hong

Say Hong

Data Management Analyst, MCHP.

Dave Towns

Dave Towns

Senior Data Management Analyst, MCHP.

Ken Turner

Ken Turner

Data Repository Analyst, MCHP.

Duration: 
8:00 am - 12:00 pm
Brief description: 

In this workshop we describe and illustrate the documentation tools and resources we have developed at the Manitoba Center for Health Policy (MCHP), with hands-on opportunities for you to try them out. This includes a demonstration of the structure and content of the Metadata Repository, a hands-on experience running the Data Quality SAS macros on a sample database, and a demonstration of the structure and content of the MCHP Concept Dictionary and Glossary. Attendees will gain knowledge and experience with the methods and techniques we use related to our documentation efforts. Minimal prior experience with SAS® would be an asset.

Objectives: 

• identify the variety of documentation tools and resources available at MCHP (which can be downloaded and transferred to any data management environment)
• learn how documentation is automatically generated for the Data Quality Report and Metadata Repository via live demonstration of the tools we have developed;
• learn how to run the Data Quality macros on a sample dataset and how to interpret the results;
• identify and discuss the integration capabilities between the various documentation tools and resources

Participants: 

Maximum 40 participants. Minimal prior experience with SAS® would be an asset.