Business Intelligence Systems and ERP PENN STATE HARRISBURG
Business Intelligence Systems and ERP PENN STATE HARRISBURG INFSY 489 – Fall 2004 David Sincavage 12/17/2021 1
Business Intelligence – What is it? “Business Intelligence is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better decisions. ” (word. IQ. com) 12/17/2021 2
Business Intelligence Components l. Data Storage – Data Warehouse – Data Mart l. Data 12/17/2021 Mining 3
What is a Data Warehouse? “An orderly and accessible repository of known facts and related data used as a basis for better management decisions. ” (Olsen) 12/17/2021 4
Data Warehouse Characteristics l Enterprise Information l Expensive l Permanent Storage l Historical Data l Read-Only 12/17/2021 5
What is a Data Mart? “A type of data warehouse designed primarily to address a specific function or department's needs, as opposed to a data warehouse which is traditionally meant to address the needs of the organization from an enterprise perspective. ” (hyperdictionary. com) 12/17/2021 6
Data Mart Characteristics l Subset of Enterprise Information l Less Expensive than DW l Temporary Storage l Short-term Data needs l Ability to add/change Data 12/17/2021 7
What is Data Mining “Data mining is the process of applying a variety of statistical and machine learning techniques to discover and interpret previously unknown patterns in data to solve business problems. ” (teradata. com) 12/17/2021 8
Interesting Factoid In 2001, Wal-mart was believed to have the largest commercial data warehouse consisting of 101 TB of data. Wal-mart just announced on October 13, 2004 that it’s expanding their data warehouse with the help from Teradata, an NCR company. Believed now to be 500 TB. (e. Week) 1 Terabyte ~ 250 Million pages of text 12/17/2021 9
Data Mining Business Applications and Benefits l Customer Relationship Management – Profile customers and understand behavior l Retail – Target profitable consumers with the right offer l Credit Card Management – Churn l Insurance – Fraud detection l Telemarketing – On-line caller information l Human Resource Management – Churn (employee turnover) (Olsen) 12/17/2021 10
Business Intelligence Data Mining Data Warehouse (Allen) 12/17/2021 11
Business Intelligence/CRM Demo http: //www. peoplesoft. com/corp/en/pro ducts/ent/crm/resource_library. jsp 12/17/2021 12
References l l l l Definition of Business Intelligence. Retrieved November 06, 2004. http: //www. wordiq. com/definition/Business_intelligence Olsen, David Louis (2004). Managerial Issues of Enterprise Resource Planning Systems, 123 -145. Meaning of DATA MART. Retrieved November 06, 2004. http: //www. hyperdictionary. com/computing/data+mart Data Mining Definition. Retrieved November 06, 2004. http: //www. teradata. com/t/page/43595/ At Wal-Mart, World's Largest Retail Data Warehouse Gets Even Larger. Retrieved November 06, 2004. http: //www. eweek. com/article 2/0, 1759, 1676042, 00. asp Allen, Will (1999). Knowledge and Information Management. Retrieved November 06, 2004. http: //nrm. massey. ac. nz/changelinks/kno_inf. html People. Soft CRM Resource Library (2004). CRM for Financial Services. Retrieved November 06, 2004. http: //www. peoplesoft. com/corp/en/products/ent/crm/resource_library. jsp 12/17/2021 13
- Slides: 13