Course Content
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
