About this Course

Participants will gain the detailed knowledge necessary to design a dashboard that can be used to facilitate the decision making process. Participants will become familiar with methods for connecting their dashboards to popular live data sources. Participants will be able to shorten their development time using templates, themes and best practices when designing dashboards.

Audience Profile

This course is intended for inexperienced SAP BusinessObjects Dashboards 4.0 users who need to create and distribute interactive and connected dashboards based on Microsoft Excel workbooks.

Prerequisites

Essential:

• Basic knowledge of Excel spreadsheets

Recommended:

• Familiarity with BusinessObjects Enterprise, Crystal Reports, or Live Office
• Ability to create summarized data from tabular data
• Experience creating database queries

Course Outline

  Creating a Dashboard

• Producing Interactive Dashboards
• Getting Around in Dashboards
• Working with Your Excel Workbook
• Visualizing Data with Charts
• Using Dashboards Components
• Applying Best Practices for Designing Dashboards
• Distributing Your Dashboard

Formatting a Dashboard

• Applying Formatting Options
• Using Themes and Templates to Apply Formatting

Adding Interactivity to a Dashboard

• Using Selectors
• Adding Dynamic Visibility
• Troubleshooting Unintended Behavior in Your Dashboard

Creating a Connected Dashboard

• Using Live Data Sources
• Connecting to XML data
• Connecting to Data Using an Existing Web Service
• Connecting to Crystal Reports Data
• Connecting to SAP BusinessObjects Universes Using Web Service Query (Query as a Web Service)
• Connecting to SAP BusinessObjects Universes Using the Semantic Layer Using the Query Browser
• Using Live Office Data