Description

This internship will teach you how to create interactive reports with the SAP Crystal Dashboard Design tool. You will see the possibilities offered by the tool in terms of presentation, and will learn how to use the wide variety of graphic components available to highlight your data.

Who is this training for ?

For whom ?

Project manager, analyst and business expert, project management assistant.

Prerequisites

Training objectives

Create an interactive SAP Crystal Dashboard Design report from an Excel sheet or a BusinessObjects® query

Add graphical components to the report

Insert interactive elements in the report such as selectors, refresh buttons

Export report data to Excel and to a BusinessObjects® platform

Create an interactive report from a BusinessObjects® query, inserting refresh buttons

Training program

• Know the Office suite and in particular Microsoft Excel.
  • Reminder about BI and SAP BusinessObjects®.
  • Principles of Dashboard Design.
  • Presentation of the interface and the workspace.
  • Exercise: Getting to grips with the environment.
• Building a Dashboard
  • Component types and object lists.
  • Create a simple Dashboard.
  • Import data from an Excel sheet.
  • Insert a component and manage its properties.
  • Components of type "Diagrams" (region.
  • ).
  • Interest of components of type "Containers ".
  • Templates and themes in a Dashboard.
  • Exercise: Creating a simple interactive report from an Excel sheet.
  • Creating diagrams.
• Structure a Dashboard and make it interactive
  • Type of interactive components.
  • Set the "drill down" within a chart.
  • Manage the behavior of an interactive component.
  • Components of type "Selectors" (checkbox.
  • ).
  • Components of type "Single value" (cursor.
  • Components of type "Cards" and "Text".
  • Configuring alerts.
  • Exercise: rnCreating reports with an interactive diagram, inserting components such as selectors, maps and text.
• Use external data
  • External data source connectivity types.
  • Create a connection to an external data source.
  • Use the query browser.
  • Connect to a BusinessObjects® universe and edit queries.
  • Insert the results of a BusinessObjects® query.
  • BusinessObjects® query refresh button.
  • Query Prompt Selector type button.
  • Integrate a BO report into a Dashboard.
  • Exercise: Creating a report interactive from a BusinessObjects® query, insertion of refresh buttons.
• Export and deploy a document
  • Export to Excel, PowerPoint and Word.
  • Export of Dashboards to SWF (Flash) files.
  • Export to PDF.
  • Export of Dashboards on the BusinessObjects® platform.
  • Export via a "Live Office" type connection.
  • Compatibility with mobile devices.
  • Exercise: Creation of an interactive report, export of data to Excel and to a BusinessObjects® platform.