ADM 1370 Lecture Notes - Lecture 1: Microsoft Sql Server, Affinity Analysis, Enterprise Resource Planning

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Umar Ruhi

Document Summary

Data: raw facts that describe characteristics of an event. E(cid:454). detailed data f(cid:396)o(cid:373) pos te(cid:396)(cid:373)i(cid:374)als; t(cid:396)a(cid:374)sa(cid:272)tio(cid:374)al data (cid:894)(cid:271)a(cid:374)ks, (cid:373)o(cid:271)ile se(cid:396)(cid:448)i(cid:272)es, (cid:895); filte(cid:396)ed data f(cid:396)o(cid:373) crm, supply chain, & enterprise resource planning applications; clickstream data from web & e-commerce applications; medical record, medical images. Data have become central & vital to orgs: orgs. need to manage their data assets very carefully to make sure that data are easily accessed by managers & employees across org. If (cid:455)ou do(cid:374)"t a(cid:272)t o(cid:374) (cid:455)ou(cid:396) data i(cid:374) a ti(cid:373)el(cid:455) (cid:373)a(cid:374)(cid:374)e(cid:396) (cid:894)if data is (cid:373)o(cid:396)e tha(cid:374) (cid:1007)(cid:1004) da(cid:455)s old,(cid:895) the(cid:374) (cid:455)ou (cid:272)a(cid:374)"t ope(cid:396)ate at (cid:455)ou(cid:396) best: essence of time is crucial. Principle of data in context: when you take data & manipulate it, you need to be actual, ex. market basket analysis. Data is created & used offline w/o going thru quality control checks. Data may be redundant & out-of-date, creating a huge maintenance problem.