Oracle Business Intelligence (OBIEE): Interactive Dashboards & Answers
- 3h 31m
- Sideris Courseware Corporation
- Sideris
- 2009
Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated database requests and to format resulting answers. Microsoft SQL Server data warehouse environments frequently utilize the Oracle Business Intelligence Enterprise Edition (OBIEE) as the front-end analytic and presentation tool.
The following topics are included in this training courseware guide book:
- Background discussion of relational databases, the SQL database language, data warehousing, business intelligence (BI) and data analytics presented in a form that business professionals can readily understand.
- Background concepts regarding logical data models, physical data models, star schema and snowflake schema warehouse models.
- Important data concepts including fact tables, dimensions, cubes, measures and other dimensional data model objects.
- An introduction to Oracle BI concepts, including the Oracle BI repository layers, Oracle BI Presentation Services, Oracle BI Presentation Catalog and basic navigation of the Oracle BI Answers and Dashboards interface.
- Use interactive Dashboards to analyze warehouse data, uncover trends and reach important business decisions.
- Design customized Dashboards to reflect an individual's role, perspective or business interest.
- Creating requests and viewing answers produced from Oracle BI.
- Formatting requests using sorts, filters and prompts.
- Formatting column output and modifying column data using formulas.
- Creating report results with compound layouts, including views such as tabular, chart, pivot table, gauge and others.
- Drill-down into report details, navigation and employing variables to create a dynamic and interactive analytics environment.
- Deploying report results for specific devices, such as mobile devices commonly in use like Apple iPhone, Blackberry or other popular devices.
- Advanced features such as presenting interactive maps as filter criteria, HTML customization of report output and other topics.
In this Book
-
Course Introduction
-
Databases & Data Models
-
Data Warehousing & BI
-
Introduction To Oracle BI Answers & Dashboards
-
Using a Dashboard
-
Building a Dashboard
-
Creating A Report
-
Report Formatting
-
Column Formatting
-
Using Primary Views
-
Using Secondary Views
-
Using Pivot Table Views
-
Advanced Formatting
-
Administering The Presentation Catalog
-
Deploying Requests to Dashboards
SHOW MORE
FREE ACCESS
