Documenting the data warehouse: a SAS®-based hands-on workshop
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.
• 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
Maximum 40 participants. Minimal prior experience with SAS® would be an asset.