Transcript MIS 451 Building Business Intelligence Systems

MIS 451
Building Business Intelligence Systems
Data Analysis
Project
Planning
Requirements
Analysis
Logical
Design
Designer
Physical
Design
Data
Staging
Builder
Discoverer
Data
Analysis
(OLAP)
2
What is OLAP?

OLTP On-Line Transaction Processing. OLTP is a type of
computing in which the emphasis is on processing
transactions as they are received by the application.

OLAP On-Line Analytical Processing. OLAP is a category
of software technology that enables analysts, managers,
and executives to gain insight into data through fast,
consistent, interactive access to a wide variety of possible
views of information that has been transformed from raw
data to a data warehouse.
3
OLAP tool – Oracle Discoverer

Step 1: log into sql*plus with username/password: dbsr/mis

Step 2: type in sql commnad
grant select on table_name to your_designer_username;

Step 3: log into Oracle Discover user edition with your designer
username and password.
Make sure EUL is DBSR
4
OLAP tool – Oracle Discoverer

Step 4: Create a new workbook

Step 5: select a table (report) layout and create a report




List sales by month table
List sales by month and by gender cross-tab
List sales by year and by product category page-detail table
Step 6: Save the workbook
5
OLAP tool – Oracle Discoverer

Step 7: drill-up and drill-down operations


Adding/removing dimensions
Concept hierarchy of dimension attributes
City  State  Country
Month  Quarter  Year
Product  Product Category

Step 8: Drill across operation

Readings: Data Mining book pp58-61.
6