9 - Business Intelligence

M cheung william tan and carson woo 30 model base

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: m Turban Ef BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 29 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 30 Model Base Management: Model Execution Execution Model Base Management: Model Directory Directory • Controls the actual operation of the model the actual operation of the model • A catalog of all the models in the model catalog of all the models in the model base • Integrates several models • Contains model definitions • Accepts and interpret modeling • Answer questions about the availability questions about the availability instructions instructions and capability of the models (e.g., What models should be used for occasion?) models should be used for occasion?) BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 31 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 32 Model Model Base Management: Examples Multidimensional Modeling Modeling OLAP: On-line Analytical Processing. OLAP tools provide the ability to examine information at various levels of summarization along multiple business dimensions in a very flexible and intuitive interface • Multidimensional Modeling Modeling • Data Mining BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 33 BUSI 335 Slicing an OLAP Cube an OLAP Cube • Allows users to view data in different perspectives by using multidimensional mo modeling tools (e.g., OLAP OLAP tools) • Allows users to compare, rotate, and “slice and dice” corporate data across corporate data across different management viewpoints viewpoints Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo Multi-Dimensional View of Data View of Data Operations Finance Profit by Division Division by City by Month by Actual/Budget BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 34 35 BUSI 335 Sales Revenue by Product by Region by Sales Rep by Quarter Marketing Revenue by Customer by Industry by Channel by Week Week Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo Volume by Plant Plant by Shift by Product by Day 36 Multidimensional Multidimensional Modeling: Examples Examples Multidimensional Modeling: Examples (cont Examples (cont’d) Examine data in various levels of summarization/ aggregation along common business dimensions such as aggregation along common business dimensions such as ti...
View Full Document

Ask a homework question - tutors are online