9 - Business Intelligence

M cheung william tan and carson woo 13 busi 335

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: er BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 13 BUSI 335 Finance Marketing Accounting Production Internal Data Sources • Internal sources − Data from the organization’s transaction processing system − Data from other functional areas such as accounting, from other functional areas such as accounting finance, and so on Private Data Dialog Management Extraction DSS Database Model Base Management • External sources − Industry data, marketing research data, census data, regional employment data, and so on Data Management System • Private data Database Management System − Rules of thumb by specific decision makers (e.g., subjective estimates of sales) Source: p.90, Decision Support and Expert Systems by Efraim Turban Ef BUSI 335 14 Data Management : Data Sources Management Data Sources Data Management Management External Data Sources Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 15 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 16 Data Management: Extraction Data Management: Extraction Data Management: DBMS Management: DBMS • Import files files • Summarize data • Filter data BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo • Provide basic functions (e.g. retrieval, basic functions (e retrieval update, storage and so on) of a DBMS • Provide query facility 17 BUSI 335 • Characteristics: • Capture summarized/aggregate data summarized/aggregate data • Require faster access • Require de-normalization • Organize in multi-dimension • Examples: data warehouse and data Batch Updated − Separate DSS database from OLTP systems − Integrated data (i.e., data from different OLTP systems) − Various levels of summarization/aggregation levels of summarization/aggregation − Historical data in different levels of details from 3 days to 20 years days to 20 years − Subject-oriented (i.e., business terms and areas of interests) mart mart Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 18 Data Warehouse Warehouse Data Manage...
View Full Document

Ask a homework question - tutors are online