Business Intelligence

1
Business Intelligence Data Warehouse

• Prepared by Group 4
• 1. ???????? ??????? 471021001
• 2. ??????????? ????????????? 471021003
• 3. ????????????? ???????? 471021021
• 4. ?????????? ???????????? 471021031
• 5. ??????????? ?????? 471021032

2
Topic

• Business Intelligence
• What is business intelligence
• Why business intelligence
• Business intelligence tools
• Data Warehouse
• Decision support and OLAP
• What is Data Warehouse
• Data Warehousing Architecture
• OLAP VS OLTP
• QA

3
What is business intelligence

• Application program and technologies for
  gathering, storing and analyzing.
• Providing access to data to help enterprise user
  make better business decision.
• BI application are decision support, query and
  reporting, online analytical processing (OLAP),
  statistical analysis, forecasting and data mining.

Business Intelligence
4
Why business intelligence
The goal of every business is to be successful by
gaining new customers and retaining old
customers. A crucial way of achieving this end is
through Business Intelligence. Business
intelligence is also known as simply BI.

• Slowdown economic make IT to demonstrate real ROI
  (Return on investment) on any investment made in
  new technology
• An essential idea of business is that data is
  enhanced into information and then into
  knowledge.
• Business use BI to gain an advantage in the
  marketplace by understanding their customers
  needs, customers decision-making processes, and
  economic, cultural, and technological trends.
• Business intelligence involves analyzing not only
  the customer but the entire industry as a whole.

5
Business intelligence Tools

• Reporting
• Query And Analysis
• Performance Management

6
Data Warehouse

• Decision support and OLAP
• What is Data Warehouse
• Data Warehousing Architecture
• OLAP VS OLTP

7
Decision Support and OLAP

• Information technology to help the knowledge
  worker (executive, manager, analyst) make faster
  and better decisions
• What were the sales volumes by region and product
  category for the last year?
• How did the share price of computer manufacturers
  correlate with quarterly profits over the past 10
  years?
• Which orders should we fill to maximize revenues?
• Will a 10 discount increase sales volume
  sufficiently?
• Which of two new medications will result in the
  best outcome higher recovery rate shorter
  hospital stay?
• On-Line Analytical Processing (OLAP) is an
  element of decision support systems (DSS)

8
What is Data Warehouse

• A decision support database that is maintained
  separately from the organizations operational
  databases.
• A data warehouse is a
• subject-oriented,
• integrated,
• time-varying,
• non-volatile
• A collection of data that is used primarily in
  organizational decision making

9
Data Warehousing Architecture
10
OLTP vs. OLAP
OLTP
OLAP

• Clerk, IT Professional
• Day to day operations
• Application-oriented (E-R based)
• Current, Isolated
• Detailed, Flat relational
• Structured, Repetitive
• Short, Simple transaction
• Read/write
• Index/hash on prim. Key
• Tens
• Thousands
• 100 MB-GB
• Trans. throughput

• Knowledge worker
• Decision support
• Subject-oriented (Star, snowflake)
• Historical, Consolidated
• Summarized, Multidimensional
• Ad hoc
• Complex query
• Read Mostly
• Lots of Scans
• Millions
• Hundreds
• 100GB-TB
• Query throughput, response

User Function DB Design Data
View Usage Unit of work Access Operations
Records accessed Users Db size Metric
11
Q A
12
THANK YOU