University Session: Quality "Shmality"-Why You Need Data Quality and How to Conduct a Data Quality Program

Quality "Shmality"-Why You Need Data Quality and How to Conduct a Data Quality Program
William Wimsatt, Wells Landers Group
Business Intelligence/Data Warehousing
Room 104/106

PLEASE NOTE: This is a hands-on session. Users are required to bring their own laptops. We will be sending an email to participants with directions for loading the required software prior to the session.

Understand data quality, how to conduct data profiling, and discuss options for starting a data quality or governance program in your organization.
Data stored in a data warehouse or data mart must be trusted to have true actionability. When you bring data into your data warehouse, you need to first understand the structure and the meaning of your data, and then assess the quality and the extent to which you may need to cleanse and transform it. Once you know what actions you need to take, you then need to make the required corrections to the data, and put in place a means to detect and correct any more errors that might occur in future loads.

Many organizations build a data warehouse to provide an integrated, reliable, and consistent version of the truth. Data is typically sourced from various systems and has to be extracted, cleansed, and integrated before being made available for users to query.

The quality of the data loaded data warehouses and data marts is highly variable; however, the process of profiling your source data has been a time-consuming, manual process via custom programs or the purchase of an expensive third-party tool. This presentation will present data quality, and formation of a data quality program through hands-on demonstrations and exercises with Oracle Warehouse Builder Data Profiler and an open source data profiler.

Register Now!http://www.technicalconferencesolutions.com/RMOUG_registration.html