A1262529188SGzwk

1
Business Intelligence with Business Objects

• COMMITTE MEMBERS
• Dr. RICHARD J. EASTON
• Dr. ROBERT W. STERNFIELD
• Dr. LARRY E. KUNES

• PROJECT GUIDE
• Dr. HENJIN CHI
  

BY RAJASEKHARA KANDULA
2
Objective

• Design and Develop Critical Reports
• Designing Data Marts for Developing Reports
• Advanced knowledge of the underlying data sources
  and structures

3
What is Business Intelligence

• Business intelligence
• Acquisition of data and information for use in
  decision-making activities
• Applying models and methods to data to identify
  patterns and trends
• But How?
• Ans By designing a DATA WAREHOUSE

4
What is Data Warehousing?

• Is the process of taking internal and/or external
  data, cleansing it and storing it in a warehouse
  where it can be accessed by various decision
  makers in the decision support process.
• A data mart is a part of a data warehouse
  containing a subject area data.
• Data warehousing solves the data acquisition or
  access problem.
• The end users perform ad hoc query, reporting,
  analysis and visualization on the data warehouse
  or on one or more data marts.

5
Definition

• Data Warehouse
• A subject-oriented, integrated, time-variant,
  non-updatable collection of data used in support
  of management decision-making processes
• Subject-oriented e.g. customers,
  sales,finanace,inventory products
• Integrated Consistent naming conventions,
  formats, encoding structures from multiple data
  sources
• Time-variant Can study trends and changes
• No updatable Read-only, periodically refreshed
• Data Mart
• A data warehouse that is limited in scope

6
Loading the Data Warehouse
Data is periodically extracted
Data is cleansed and transformed
(OLTP)
Users query the data warehouse
Data Staging Area
Data Warehouse
Source Systems
7
Data Warehouses

• Doing OLTP and OLAP in the same database system
  is often impractical
• Different performance requirements
• Different data modeling requirements
• Analysis queries require data from many sources
• Solution Build a data warehouse
• Copy data from various OLTP systems
• Optimize data organization, system tuning for
  OLAP
• Transactions arent slowed by big analysis
  queries
• Periodically refresh the data in the warehouse

8
Schema used to design a DATA MART
Fact tables contain factual or quantitative data
Dimension tables are denormalized to maximize
performance
1N relationship between dimension tables and
fact tables
Dimension tables contain descriptions about the
subjects of the business

• Star Schema

9
Universes, Classes, and Objects
Information is identified by common terms
Universe
10
Designing A Universe
11
Adding Data Base Tables to Universe
12
Universe designed for reporting
13
Using Business Objects
14
Choose the Universe (data source) for your query
15

Selecting a Universe
16
Query Panel
17
Classes of Data and Objects
Shows Classes and the Objects in the selected
universe
18
Query Panel in Conditions Window
This is "Conditions Window where data can be
restricted .
19
Presentation Styles

• BO has different block types that you can use to
  format data in your report

Table Block
Chart Block
Cross-tab Block
20
Tables

• Table is the default style for presenting data.

21
Charts
BO has the following types of charts

• Area
• Column
• Line
• Pie
• XY (Scatter)
• 3-D Area
• 3-D Column
• 3-D Line
• 3-D Pie

22
CROSS-TABS

• A cross-tab looks like a spreadsheet with data in
  cells.

Table Block
Cross-tab Block
23
Conclusion

• Business objects relate to real world things
  they are understandable to end-users
• They offer a convenience for both developers and
  end-users
• Business objects can encapsulate data and expose
  common services
• Users can interact with business information and
  answer ad hoc questions themselves, without
  advanced knowledge of the underlying data sources
  and structures.

24
ACKNOWLEDGEMENT

• Dr. HENJIN CHI
• Dr. ROBERT W. STERNFIELD
• Dr. LARRY E. KUNES

25
Thank You