1 / 6

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. Data Analysis (OLAP). Discoverer. What is OLAP?.

camila
Download Presentation

MIS 451 Building Business Intelligence Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MIS 451Building Business Intelligence Systems Data Analysis

  2. Project Planning Requirements Analysis Logical Design Designer Physical Design Data Staging Builder Data Analysis (OLAP) Discoverer

  3. 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.

  4. 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

  5. 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

  6. 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.

More Related