SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK DATA.VISUALIZATION.FOR.ORACLE.BUSINESS.INTELLIGENCE.11G
SUMMARY
-
Items Found: 426
- 1. Introduction
- About Oracle Business Intelligence 11g
- Business Intelligence System Goals
- Humans Evolved to Sense the World,Not to “Do Numbers”
- Basic Principles of BI Dashboards
- BI Systems Need Training
- Dashboard Best Practices
- Motion Demands Attention and Cannot Be Ignored
- Color Is Powerful
- Alignment and Position
- A Little Bit about Tables
- Background Thoughts on Graphs
- Data Visualization Graph Views
- Map Views Communicate Effectively
- Dashboard Design Examples
- Oracle’s OBIEE SampleApp
- The Sample Dashboard Is a Good Start
- Improving a Dashboard from SampleApp
- Where the World of Business Intelligence Data Visualization Is Headed
- Data Visualization for Oracle Business Intelligence 11g
- 2. Tables
- Understanding Table Design
- Table Views vs. Pivot Table Views
- Stating a “Need” Sentence
- Table Views
- The Criteria Tab Sets the Basic Properties
- The Column Properties Dialog
- Table Views—Results Tab
- Editing Table Views
- Pivot Table Views—Results Tab
- Organizing Dimensions in Pivot Table Views
- Conditional Formatting
- Table and Pivot Table Right-Click Interaction Menus
- Performance Tiles
- 3. Graphs
- Types of Graphs and When to Use Them
- Line Graphs
- Time Series Line Graphs
- Bar Graphs
- Line-Bar Combo Graphs
- Waterfall Graphs
- Pie Graphs
- Area Graphs
- Scatter Plot Graphs
- Bubble Graphs
- Radar Graphs
- Pareto Graphs
- 4. Maps
- Justification for Maps and When to Use Them
- Maps,Layers,and Spatial Basics
- Geocoding
- MapViewer Basics
- MapViewer and OBIEE
- MapViewer Administration
- Using Maps with OBIEE
- Creating Choropleth Maps
- Interacting with Maps
- Map Color Choices
- Bubbles and Variable Shapes on Maps
- Placing Graphs on Maps
- Placing Lines on Maps
- Combining Data Sets on Maps and Using Map Feature Layers
- Custom Integration of Maps in OBIEE
- 5. Advanced Visualizations
- Trellis Charts
- Simple Trellis Charts (Type 1 Trellis Charts)
- Advanced Trellis Charts (Type 2 Trellis Charts)
- Gauges and Dials
- Extending Native OBIEE Data Visualization Views
- Showing Data Distributions Using Tricks with OBIEE
- Stacked Bar Graphs
- Oracle ADF Visualizations
- Using R Visualizations in OBIEE Dashboards
- Using the Third-Party Visualization Engine D3
- JQuery
- 6. BI Publisher
- The Power of Pixel Perfect Visualizations
- BI Publisher Contrasted with OBIEE
- BI Publisher Report Components
- Data Model
- Template
- Properties
- Layout Editor Is the Major Interface
- Interacting with BI Publisher
- BI Publisher Dual-Y Graph Types
- Bursting Reports
- 7. Dashboard Design and Mechanics
- Roles of Dashboard Users
- Common Roles in Organizations
- Importance of Dashboards Depends on Roles and Usage
- Dashboard Content Can Vary by User
- Dashboard Standards and Style Guides
- Important OBIEE Dashboard Considerations
- Basic Layout
- Include Contextual Information on Dashboards
- Dashboard Format and Placement of Contents
- Form Follows Function
- Alignment,Grids,and Structure
- x Data Visualization for Oracle Business Intelligence 11g
- Dashboard Layout Mechanics
- Dashboard Property Page Size
- Laying Out Dashboard Columns
- Laying Out Dashboard Sections
- 8. Dashboard Interactions
- Users Already Know about Interactions
- Dashboard Interactions Are about Engagement
- Master-Detail Linking
- Configuring Master-Detail Linking
- Formatting Views with Master-Detail Linking
- Slider Prompts with Master-Detail Linking
- Map Views as Detail Views
- Dashboard Prompts
- Standard Prompts
- Calendar Prompt
- Slider Prompt
- Image Prompt
- Cascading Prompts
- Creating and Applying Saved Customizations
- Navigation
- Primary Navigation Actions
- Action Link Menus and Navigation Dashboards
- 9. Scorecard and Strategy Management
- Oracle Score Card and Strategy Management Objects
- KPIs
- Objectives
- Initiatives
- Scorecards Defined
- OSSM Visualizations
- KPI Watchlist
- Strategy Tree
- Strategy Wheel
- Strategy Map
- Cause-and-Effect Map
- Custom View
- 10. Mobile
- Three Main Methodologies for Viewing OBIEE Dashboards
- and Content on Mobile Devices
- Web Browser
- Oracle Business Intelligence Mobile HD and Oracle BI Mobile
- BI Mobile App Designer
- General Principles for Effective Data Visualization on all Mobile Devices
- Smaller Screen Resolution
- Design Dashboards with a Specific Role in Mind
- Prefer Small Tables
- Prefer Performance Tiles
- Prefer Visualizations That Show an Overall Pattern in the Data
- Eliminate Unnecessary Visual Noise
- Include Fewer Prompts and Limit Prompt Selections
- Consciously Organize Catalog Structure and Folders
- Encourage Users to Capitalize on Mobile Navigational Features
- Dashboard Layouts and Gestures for Mobile
- Mobile Layout
- Original Layout
- Gestures
- White vs. Black Dashboard Backgrounds
- Maps on Mobile
- BI Mobile App Designer
- 11. Other Visualization Topics
- Principles of Design
- Unity
- Harmony
- Balance
- Rhythm
- Proportion and Scale
- Emphasis or Dominance
- Variation
- Color
- ColorBrewer 2.0
- iWantHue
- W3Schools HTML Color Picker
- Changing the Default Colors for Graphs in OBIEE
- Defining OBIEE’s User Interface Through Skins,
- Styles,and Messages
- Skins
- Styles
- Messages
- Alerts
- Best and Recommended Visualizations
- Data in the Real World
- Controlling What Data You Show
- Data Visualization for Oracle Business Intelligence 11g
- Filters
- Selection Steps
- Grouping Values: Bins and Groups
- Top/Bottom 10: Exception Analysis
- Label Visualizations Appropriately
- Sorting
- Significant Digits
- Null Values
- Interactions
- Hover-Over
- Click Events
- 12. General Advice
- Working with BI Catalog
- Organizing the BI Catalog
- Copying Dashboards for Modifying
- Using Save As
- Keeping the Catalog Clean
- Search to the Rescue
- Development Standards
- Why Have Development Standards
- What to Include in Development Standards
- Working the Project
- Working with Executives
- Working with IT and DBAs
- Whole Organization
- Developing Trust in BI Systems
- Getting Started
- Workshops
- Assessments
- Training
- Metadata Communication and Documentation
- The Long Road
- 1. Introduction
- About Oracle Business Intelligence 11g
- Business Intelligence System Goals
- Humans Evolved to Sense the World,Not to “Do Numbers”
- Basic Principles of BI Dashboards
- BI Systems Need Training
- Dashboard Best Practices
- Motion Demands Attention and Cannot Be Ignored
- Color Is Powerful
- Alignment and Position
- A Little Bit about Tables
- Background Thoughts on Graphs
- Data Visualization Graph Views
- Map Views Communicate Effectively
- Dashboard Design Examples
- Oracle’s OBIEE SampleApp
- The Sample Dashboard Is a Good Start
- Improving a Dashboard from SampleApp
- Where the World of Business Intelligence Data Visualization Is Headed
- Data Visualization for Oracle Business Intelligence 11g
- 2. Tables
- Understanding Table Design
- Table Views vs. Pivot Table Views
- Stating a “Need” Sentence
- Table Views
- The Criteria Tab Sets the Basic Properties
- The Column Properties Dialog
- Table Views—Results Tab
- Editing Table Views
- Pivot Table Views—Results Tab
- Organizing Dimensions in Pivot Table Views
- Conditional Formatting
- Table and Pivot Table Right-Click Interaction Menus
- Performance Tiles
- 3. Graphs
- Types of Graphs and When to Use Them
- Line Graphs
- Time Series Line Graphs
- Bar Graphs
- Line-Bar Combo Graphs
- Waterfall Graphs
- Pie Graphs
- Area Graphs
- Scatter Plot Graphs
- Bubble Graphs
- Radar Graphs
- Pareto Graphs
- 4. Maps
- Justification for Maps and When to Use Them
- Maps,Layers,and Spatial Basics
- Geocoding
- MapViewer Basics
- MapViewer and OBIEE
- MapViewer Administration
- Using Maps with OBIEE
- Creating Choropleth Maps
- Interacting with Maps
- Map Color Choices
- Bubbles and Variable Shapes on Maps
- Placing Graphs on Maps
- Placing Lines on Maps
- Combining Data Sets on Maps and Using Map Feature Layers
- Custom Integration of Maps in OBIEE
- 5. Advanced Visualizations
- Trellis Charts
- Simple Trellis Charts (Type 1 Trellis Charts)
- Advanced Trellis Charts (Type 2 Trellis Charts)
- Gauges and Dials
- Extending Native OBIEE Data Visualization Views
- Showing Data Distributions Using Tricks with OBIEE
- Stacked Bar Graphs
- Oracle ADF Visualizations
- Using R Visualizations in OBIEE Dashboards
- Using the Third-Party Visualization Engine D3
- JQuery
- 6. BI Publisher
- The Power of Pixel Perfect Visualizations
- BI Publisher Contrasted with OBIEE
- BI Publisher Report Components
- Data Model
- Template
- Properties
- Layout Editor Is the Major Interface
- Interacting with BI Publisher
- BI Publisher Dual-Y Graph Types
- Bursting Reports
- 7. Dashboard Design and Mechanics
- Roles of Dashboard Users
- Common Roles in Organizations
- Importance of Dashboards Depends on Roles and Usage
- Dashboard Content Can Vary by User
- Dashboard Standards and Style Guides
- Important OBIEE Dashboard Considerations
- Basic Layout
- Include Contextual Information on Dashboards
- Dashboard Format and Placement of Contents
- Form Follows Function
- Alignment,Grids,and Structure
- x Data Visualization for Oracle Business Intelligence 11g
- Dashboard Layout Mechanics
- Dashboard Property Page Size
- Laying Out Dashboard Columns
- Laying Out Dashboard Sections
- 8. Dashboard Interactions
- Users Already Know about Interactions
- Dashboard Interactions Are about Engagement
- Master-Detail Linking
- Configuring Master-Detail Linking
- Formatting Views with Master-Detail Linking
- Slider Prompts with Master-Detail Linking
- Map Views as Detail Views
- Dashboard Prompts
- Standard Prompts
- Calendar Prompt
- Slider Prompt
- Image Prompt
- Cascading Prompts
- Creating and Applying Saved Customizations
- Navigation
- Primary Navigation Actions
- Action Link Menus and Navigation Dashboards
- 9. Scorecard and Strategy Management
- Oracle Score Card and Strategy Management Objects
- KPIs
- Objectives
- Initiatives
- Scorecards Defined
- OSSM Visualizations
- KPI Watchlist
- Strategy Tree
- Strategy Wheel
- Strategy Map
- Cause-and-Effect Map
- Custom View
- 10. Mobile
- Three Main Methodologies for Viewing OBIEE Dashboards
- and Content on Mobile Devices
- Web Browser
- Oracle Business Intelligence Mobile HD and Oracle BI Mobile
- BI Mobile App Designer
- General Principles for Effective Data Visualization on all Mobile Devices
- Smaller Screen Resolution
- Design Dashboards with a Specific Role in Mind
- Prefer Small Tables
- Prefer Performance Tiles
- Prefer Visualizations That Show an Overall Pattern in the Data
- Eliminate Unnecessary Visual Noise
- Include Fewer Prompts and Limit Prompt Selections
- Consciously Organize Catalog Structure and Folders
- Encourage Users to Capitalize on Mobile Navigational Features
- Dashboard Layouts and Gestures for Mobile
- Mobile Layout
- Original Layout
- Gestures
- White vs. Black Dashboard Backgrounds
- Maps on Mobile
- BI Mobile App Designer
- 11. Other Visualization Topics
- Principles of Design
- Unity
- Harmony
- Balance
- Rhythm
- Proportion and Scale
- Emphasis or Dominance
- Variation
- Color
- ColorBrewer 2.0
- iWantHue
- W3Schools HTML Color Picker
- Changing the Default Colors for Graphs in OBIEE
- Defining OBIEE’s User Interface Through Skins,
- Styles,and Messages
- Skins
- Styles
- Messages
- Alerts
- Best and Recommended Visualizations
- Data in the Real World
- Controlling What Data You Show
- Data Visualization for Oracle Business Intelligence 11g
- Filters
- Selection Steps
- Grouping Values: Bins and Groups
- Top/Bottom 10: Exception Analysis
- Label Visualizations Appropriately
- Sorting
- Significant Digits
- Null Values
- Interactions
- Hover-Over
- Click Events
- 12. General Advice
- Working with BI Catalog
- Organizing the BI Catalog
- Copying Dashboards for Modifying
- Using Save As
- Keeping the Catalog Clean
- Search to the Rescue
- Development Standards
- Why Have Development Standards
- What to Include in Development Standards
- Working the Project
- Working with Executives
- Working with IT and DBAs
- Whole Organization
- Developing Trust in BI Systems
- Getting Started
- Workshops
- Assessments
- Training
- Metadata Communication and Documentation
- The Long Road
