Dirty Jobs with Dirty Data
(Return to Workshop Listing)
Presenters:
John Berry, SAS Institute
Requirements:
Laptop will be provided (*for this workshop only)
Software provided
Prerequisites:
To participate in this workshop, an attendee will need to:
1. Have no experience in SAS; any level of familiarity or knowledge can attend.
2. Have no coding experience.
Description:
Up to 40% of all strategic processes fail because of poor data quality. Do you want to be in the 60%? Do you have data in multiple places with different standards for input? Do you struggle to bring it together to maintain reliable reporting so stakeholders are on the same page? This workshop will help you increase your data quality to tackle these problems. Not sure where to start? We will begin there, sharing with you how to best profile and explore your data to better understand its makeup. Tips will be shared on how to standardize your data so that addresses, phone numbers, abbreviations, etc. are formatted consistently. Tame the disparate data by learning to identify and resolve records representing individuals across multiple data sources. Learn how to make better decisions using data you can trust, and build a better data-driven organization.
Intended Learning Outcomes:
Participants in this workshop will:
1. Gain hands-on experience in exploring and standardizing institutional data.
2. Gain experience with combining data from different data sources as well as strategies for preparing data for reporting and analysis.
Presenters:
John Berry, SAS Institute
Requirements:
Laptop will be provided (*for this workshop only)
Software provided
Prerequisites:
To participate in this workshop, an attendee will need to:
1. Have no experience in SAS; any level of familiarity or knowledge can attend.
2. Have no coding experience.
Description:
Up to 40% of all strategic processes fail because of poor data quality. Do you want to be in the 60%? Do you have data in multiple places with different standards for input? Do you struggle to bring it together to maintain reliable reporting so stakeholders are on the same page? This workshop will help you increase your data quality to tackle these problems. Not sure where to start? We will begin there, sharing with you how to best profile and explore your data to better understand its makeup. Tips will be shared on how to standardize your data so that addresses, phone numbers, abbreviations, etc. are formatted consistently. Tame the disparate data by learning to identify and resolve records representing individuals across multiple data sources. Learn how to make better decisions using data you can trust, and build a better data-driven organization.
Intended Learning Outcomes:
Participants in this workshop will:
1. Gain hands-on experience in exploring and standardizing institutional data.
2. Gain experience with combining data from different data sources as well as strategies for preparing data for reporting and analysis.