Chapter 12 Sections Q1-Q4: Business Intelligence Chapter 13 Sections Q2-Q4: Knowledge Mgmt Chapter 14 All Sections: Database Marketing Chapter 15 Sections Q1 & Q4: OLAP Business Intelligence Expert Systems Reporting Knowledge Management Data Mining  Define business intelligence systems.  Know the characteristics of reporting systems.  Know the purpose and role of data warehouses and data marts.  Understand fundamental data-mining techniques.  Know the purpose, features, and functions of knowledge management systems.   Q1: How Big is an Exatype? Q3: What Problems do Operational Data Pose?  software that searches vast amounts of data to derive information for improved decision making  Reporting  Data Mining  Knowledge Management  Expert Systems  software that reads data  processes data by: ◦ ◦ ◦ ◦  filtering sorting grouping simple calculations produces formatted summaries of data  On-Line Analytical Processing ◦ Drill-Down ◦ Consolidation ◦ Slicing and Dicing Report A Report B  Large Database  Subject-Oriented  Integrated  Time-Variant  Nonvolatile  User-Friendly Interface Reporting Operational DB External DB Data Warehouse Data Mining KM Other DB Expert    Mini data warehouses Hold subsets of data from the data warehouse Data focuses on a specific aspect of the company  software that searches through data  uses complex statistical calculations  outputs ◦ ◦ ◦ ◦ Trends Patterns Correlations Exceptions  Nestle processes Social Media http://uk.reuters.com/article/video/idUKBRE89P07Q 20121026?videoId=238680321    Process Creating Value from Intellectual Property Sharing Knowledge with Others http://answers.vt.edu/kb/entry/3354/  Knowledge captured as rules. www.lpa.co.uk/wfs_dem6.htm  Poor data quality  Context  User resistance