SAP Crystal Dashboard Design

Introduction To Dashboard Design 2011 and Presentation Design

• What is Dashboard Design?
• What’s New in Dashboard Design 2011?
• Getting Help
• What is a Dashboard?

Quick Tour Of Dashboard Design

• The Start Page
• The Workspace
• The Canvas
• The Menu
• The Online Help File
• Toolbars
• File Types
• Dashboard Examples
• Formatting Options
• Order Options
• Selecting Components
• Nudging Components

Exploring The Workspace

• The Workspace
• Components Browser
• Object Browser
• How to Resize Panels and Windows
• Resizing the Canvas
• The Canvas Properties Panel
• Docking Panels
• Using the Auto Hide Option
• Quick Views
• Preferences
• Printing Dashboards
• Print Preview
• Copy and Paste Components
• Using the Built In Spreadsheet
• Importing Xcelsius 2008 and Crystal Xcelsius 4.5 Model Files

Creating Your First Dashboard

• Designing Dashboards Overview
• Designing for Scalability
• Dashboard Design Process
• Refreshing Data
• Dashboard Prototype
• Dashboard Creation Options
• The Component Properties Panel
• What Are Components?
• Other Component Types

Preparing Excel Spreadsheets For Dashboards

• Excel Overview
• Dashboard Design Benefits
• Excel Functionality that Dashboard Design Does Not Support
• Excel Functions Supported in Dashboard Design
• Reports vs Dashboards
• Data Modeling
• How Metrics and KPI’s Influence the Spreadsheet Structure
• Using Multiple Tabs
• Using Enterprise Data
• Connecting to External Data Sources
• Microsoft Query Wizard
• How Many Rows and columns is Too Many?
• Filtering Data
• Cells With and Without Formulas
• Demistifying Chart Data
• Formatting Options

Single Value Components

• Single Value Component Categories
• Single Value Component Options
• Value Component
• Play Control Component
• Dial Component
• Horizontal and Vertical Slider Components
• Dual Slider Component
• Progress Bar Components
• Gauge Component
• Spinner Component

Creating Charts

• Charts Overview
• Selecting a Chart Type
• Chart Component Options
• Pie Chart Component
• Bar Chart Component
• Column Chart Component

Advanced Charts

• Stacked Bar and Stacked Column Chart Components
• Area and Stacked Area Chart Components
• Bubble Chart Component
• Candlestick and OHLC Chart Components
• XY Chart Component
• Radar and Filled Radar Chart Components
• Combination Chart Component
• Horizontal Bullet and Vertical Bullet Chart Components

Creating Menu Based Dashboards

• Menu Components
• Filter Data Using Selectors
• Selector Components
• Selector Compontent Options
• Adding Animation to a Model
• Play Selector Component
• Spreadsheet Table Component
• Radio Button Component
• Grid Component
• Combo Box Component
• Filter Component
• List View Component
• Label Baeed Menu Component

Creating Dashboards With Alerts

• Alerts View Options
• Chart Component Alerts View Options
• Selector Component Alerts View Options
• Ticker Component
• Scorecard Component

Map Components

• Map Component
• Mapping to Specific States

Enhancing Dashboards

• Art and Backgrounds Components
• Background Component
• Image Component
• Ellipse and Rectangle Component
• Vertical and Horizontal Line Components
• Text Components
• Input Text Area Component
• Web Connectivity Components
• URL Button Component
• Reporting Services Button Component
• Slide Show Component
• SWF Loader Component
• Connection Refresh Button Component
• Other Components
• Local Scenario Button Component
• Trend Icon Component
• Panel Set Component
• Source Data Component
• Print Button Component
• Reset Button Component
• Refreshing Data in a Dashboard

Advanced Menus And Charts

• Accordion Menu Component
• Calendar Component
• External Files
• Nested Flash Files
• Embedding Files
• Picture Menus
• Picture Menu Components
• Fisheye Picture Menu Component
• Sliding Picture Menu Component
• Insertion View Options
• Tree Map Component
• How to Read a Tree Map Chart
• Sparkline Chart Component

Advanced Functionality

• Dynamic Visibility
• Check Box Component
• Input Text Component
• Toggle Button Component
• Label Component
• Push Button Component
• Displaying Multiple Charts
• Icon Component

Advanced Components

• Dual Axis Charts
• Filtered Rows
• Ignore Blank Cells Options
• Containers Components
• Panel Container Component
• Canvas Container Component
• Tab Set Component
• Canvas Panel
• List Builder Component
• History Component
• Trend Analyzer Component

Customization And Exporting Options

• Customization Options
• Themes
• Color Schemes
• How to Create a Custom Color Scheme
• How to Create Your Own Template
• Exporting
• Export to Flash
• Export to Adobe AIR
• Export to HTML
• Export to PowerPoint
• Export to Outlook
• Export to Word
• Export to a PDF File