This hands-on instructor led course in 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. Background discussion of relational databases, the SQL database language, data warehousing, business intelligence (BI) and data analytics is presented in a form that business professionals can readily understand. This training course will guide students through all of the features available from the product to allow them to build sophisticated database requests and to format resulting answers.
The course covers 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 are introduced.
By the end of the class students will be able to:
- Understand 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.
- Create requests and view answers produced from Oracle BI.
- Format requests using sorts, filters and prompts.
- Format column output and modify column data using formulas.
- Create 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.
- Deploy report results for specific devices, such as mobile devices commonly in use like Apple iPhone, Blackberry or other popular devices.
- Work with advanced features such as presenting interactive maps as filter criteria, HTML customization of report output and other topics.
A general working knowledge of desktop business software and the use of web-based services via a browser are the only mandatory technical prerequisites.
OVERVIEW OF ORACLE9I ARCHITECTURE
- Database Architecture
- User Processes
- Resources for the DBA
UNDERSTANDING THE ORACLE INSTANCE
- Overview of Database Creation
- Creating a Database with the Database Configuration Assistant
- Logical and Physical Structures
- Database Objects and Their Storage
- Managing the Database Instance
- Obtaining Instance Information
MANAGING TABLESPACES AND DATAFILES
- Managing Tablespaces
- Resizing and Moving Tablespaces
- Overview of Oracle Managed Files
MANAGING TABLES AND INDEXES
- Constructing Tables
- Table Information and Analysis
- Overview of Indexes
- Managing Indexes
- Implementing Constraints
- Maintaining Integrity Constraints
MANAGING UNDO DATA
- Overview of Rollback Segments
- Implementing Automatic Undo Management
MANAGING THE ONLINE REDO LOG AND THE CONTROL FILE
- Overview of the Online Redo Log
- Plan and Configure the Online Redo Log
- Managing and Maintaining the Control File
MANAGING USERS AND SECURITY
- Managing Users
- Managing Privileges and Roles
- Managing Passwords and Profiles
- Overview of Globalization Support
- NLS Parameters