Prerequisite: None
Improving data quality is difficult. Packaged data cleansing solutions typically respond to patterned problems such as de-duplication and address standardization. But real data cleansing is deeper and more complex. It requires understanding and implementation of your unique business rules. Out-of-the-box data cleansing barely scratches the surface. Rule-based data cleansing provides the techniques needed for deep and thorough cleaning of data.
In academics there are two kinds of scientists: experimental and theoretical. In information management, there are theorists and experimentalists. Experimentalists deal with deadlines, crashing servers, angry clients, and idiosyncratic software. Theorists describe an ideal environment rarely found in reality.
Come join an experimentalist and learn his pragmatic, real-world approach to data cleansing. You’ll learn proven and repeatable techniques while using computers loaded with state-of-the-art data management software from leading vendors (currently offering Trillium, DataFlux, and Talend). You will learn the principles of data cleansing, then immediately put them into action in a computer lab–based environment. The class is a travelling small business, with workstations, a network, and a server loaded with Oracle, SQL Server, scrambled data, and data quality tools.
In addition to data cleansing techniques, you’ll learn about the risk-management considerations of data cleansing. The act of changing business critical data must be handled carefully. We’ll explore techniques to help you succeed with data cleansing while simultaneously mitigating the risks inherent in changing critical data.
You Will Learn:
- Modern data quality assessment techniques
- How to create business-based data quality rules and data correction algorithms
- Implementation considerations for data correction including triggers, sequencing, and audit trail
- How to implement and manage programmatic, business-based data quality rules
- How to make the case for and manage a data quality initiative
- What the vendors offer today with hands-on experience
Geared To:
- Anyone challenged to cleanse data and improve data quality; data analysts and managers "in the trenches" of data quality improvement efforts; anyone considering an investment in data cleansing tools who needs an overview of vendor offerings
Attendance is limited to 45.