ITSS 4300 Lecture Notes - Lecture 23: Baseball Cap, Business Intelligence, Data Mining
Document Summary
Most bi systems use sql to create reports and dashboards. Business intelligence (bi) systems are information systems that assist managers and other professionals, now reporting. Started with data mining extracting data that you cannot see manually. Questions that can be answered using database data. How many customers in portland, oregon, bought our green baseball cap? : look for green baseball key, go search in portland, oregon, count customers in database. Created by the user as needed, instead of programmed into an application. Operational databases, other internal data, external data extracttransformload (etl) system (data extraction/cleaning/preparation programs) data warehouse dbms (data warehouse. Metadata, data warehouse database) business intelligence tools. ***rfm customer: analyzing customer, which one is the best, recency, frequency, monetary. Data sublanguage for creating and processing database data and metadata. Data definition language (ddl: used for creating table, relationships and other structures. Data manipulation language (dml: used for queries and data modification.