Oracle BI 11g: Create Analyses & Dashboards
- 3h 16m
- Sideris Courseware Corporation
- Sideris
- 2012
This textbook offers an exhaustive, step-by-step guide through the powerful features of the Oracle Business Intelligence (BI) product suite. One will learn the concepts, methods and techniques for building sophisticated data analytic modules. Analytic results are then organized into interactive dashboards. A solid foundation is laid for one to progress onto the latest and most advanced data analytic capabilities. The following specific topics are included in this guide book: Background discussion of data warehousing, business intelligence (BI) and data analytics presented in a form that business professionals can readily understand; Background concepts regarding logical data models, star schema and snowflake schema warehouse models; How to build analytical models using fact tables, dimensions, dimension hierarchies, cubes, measures and other multidimensional data model objects; Use interactive Dashboards to analyze data, uncover trends and make strategic business decisions; Export BI results to productivity software such as Microsoft Office or other external systems; Design customized Dashboards to reflect an individual's role, perspective or business interest; Creating data analyses and dynamically interact with results produced from Oracle BI; Format analyses using sorts, filters and prompts; Format column output, subtotaling, customization of column properties and transforming column data using formulas; Create results with compound layouts, including views such as tabular, chart, pivot table, gauge and others; Manage content, permissions and access within the Presentation Catalog. This textbook includes dozens of learning exercises, with detailed point-and-click solutions also provided.
In this Book
-
Data Warehousing, Business Intelligence & Data Analytics
-
Getting Started with Oracle BI
-
Workshop: Getting Started with Oracle BI
-
Using a Dashboard
-
Workshop: Using A Dashboard
-
Creating an Analysis
-
Workshop: Creating an Analysis
-
Selecting & Ordering Data
-
Workshop: Selecting & Ordering Data
-
Column Formatting
-
Workshop: Column Formatting
-
Employing Table & Title Views
-
Workshop: Employing Table & Title Views
-
Data Visualization & Graph Views
-
Workshop: Data Visualization & Graph Views
-
Employing Pivot Table Views
-
Workshop: Employing Pivot Table Views
-
Employing Additional View Types
-
Workshop: Employing Additional View Types
-
Building A Dashboard
-
Workshop: Building A Dashboard
YOU MIGHT ALSO LIKE
