module.2.session.4

module.2.session.4 - Click to edit Master subtitle style...

Info iconThis preview shows pages 1–14. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style 8/11/11 BUSMIS 1060 Module 2: Data Management Session 4: Quality, Privacy, & Security Dr. Russ Robbins 8/11/11 Taking Stock of Progress Data Warehouse Concepts Review Data Quality, Security, & Privacy Lecture Intro Data Privacy/Security Data Quality and Integration Managing Data Quality Extra Concepts Transactions Agenda 8/11/11 Read Chapter 3 Read XLM J Read XLM C Reviewed SQL MS Access 2007 Examples Reviewed Solomon Enterprise (Improved) DB Built your own DB, built a table, built a query Reviewed Database Concepts Lecture Reviewed DBMS Concepts & SQL Lecture By Now You Should Have 8/11/11 Look at Registration Master DB Take Student Starter and play with it to create components you see in Registration Master Data Warehousing Review Data Warehouse Lecture (This one) Data Quality Read Boosting Data Quality White Paper Read Data Quality Business Case And 8/11/11 Read Haag XLM A For Next Time Click to edit Master subtitle style 8/11/11 Data Quality and Data Integration 8/11/11 Have you ever Received a bill that was in error? Received an order that was not what you had ordered? Not received something because it was sent to the wrong address? Had a professor record your grade wrong? Personal Experiences with Poor 8/11/11 Definition Data are high quality if they fit their intended uses in operations, decision making, and planning. They are fit for use if they are free of defects and possess desired features. 1 Relative to the task Data Quality 8/11/11 Some Data Quality Dimensions Free of defects Possess desired 8/11/11 Customer data degenerates over time as customers situations change Data entry errors Misspellings Transposition of numerals Invalid or missing codes Data placed in the wrong fields Unrecognizable abbreviations or acronyms Lack of validation routines for data entry Database referential integrity checks are often turned off when loading a data warehouse to increase performance Systems integrations of data with mismatched format or structure According to a survey by the Data Warehousing Institute, almost Causes of Poor Quality Data 8/11/11 Hmm Too Much Data - Personal Privacy.swf 8/11/11 As companies collect more and more data, it becomes harder to keep the data secure, and to ensure the privacy of customer information Data redundancy not only threatens data quality, it makes it harder to keep data secure and private Data Security and Privacy 8/11/11 Data Integration...
View Full Document

Page1 / 39

module.2.session.4 - Click to edit Master subtitle style...

This preview shows document pages 1 - 14. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online