ITSS 4300 Lecture Notes - Lecture 15: Data Mining, Database, Missing Data

• School: UT-Dallas
• Department: Information Technology and Systems
• Course: ITSS 4300
• Professor: Dogan

Document Summary

Ch 13: database processing for business intelligence systems. Business intelligence (bi) systems are information systems that assist managers and other professionals: to analyze current and past activities, to predict future events. Two broad categories: reporting, data mining, exm. Reporting system applications: filter, sort, group, make simple calculations, classify entities. Rfm analysis: an be performed using standard sql, extensions to sql are sometimes used, reported physically or through dashboard. Data mining applications are used to: perform what-if analysis, make predictions, facilitate decision making. Data mining application use sophisticated statistical and mathematical techniques. Operational databases, other internal data, external data etl (data. Extraction/cleaning/preparation programs) data warehouse dbms (data warehouse. Metadata, data warehouse database) business intelligence tools bi users. Data warehouses and data marts: problems with operational data. Wrong format: too fine, not fine enough. Too much data: too many attributes, too much volume. Marts: warehouse split up into pieces: exm. Data warehouse dbms web log data, store sale data, inventory history data.