Book description
Over 90 simple and incredibly effective recipes for transforming your business data into exciting dashboards with SAP BusinessObjects Dashboards 4.0 Xcelsius
- Learn valuable Dashboard Design best practices and tips through easy to follow recipes
- Become skilled in using and configuring all Dashboard Design components
- Learn how to apply Dynamic Visibility to enhance your dashboards
- Get introduced to the most important add-ons available for Dashboard Design with the most up to date information for Dashboards 4.0
In Detail
Xcelsius 2008 was recently included in SAP’s BusinessObjects 4.0 family, rebranding “Xcelsius Enterprise” as “SAP BusinessObjects Dashboards 4.0”. With features like flexible design and what-if scenarios, the powerful dashboarding software allows enterprises to make business decisions at a glance, and this book allows you to go far beyond the basics of these techniques.
This cookbook full of practical and applicable recipes will enable you to use the full latest capabilities of Dashboard Design to visually transform your business data. A wide range of recipes will equip you with the knowledge and confidence to perform tasks like configuring charts, creating drill- downs, making component colors dynamic, using alerts in maps, building pop-up screens, setting up What-If scenarios, and many more..
The recipes begin by covering best practices for using the Dashboard Design spreadsheet, the data-model, and the connection with the components on the canvas, later moving on to some from-the-trenches tricks for using Excel within Dashboard Design. The book then guides you through the exploration of various data visualization components and dashboard interactivity, as well as offering recipes on using alerts, dashboard connectivity, and making the most of the aesthetics of the dashboard. Finally, the recipes conclude by considering the most important add-ons available for Dashboard Design and enabling you to perform relevant and useful tasks straight away.
Create Dynamic Dashboards from Business Data using SAP BusinessObjects Dashboards 4.0 (fka Xcelsius)
Table of contents
-
SAP BusinessObjects Dashboards 4.0 Cookbook
- SAP BusinessObjects Dashboards 4.0 Cookbook
- Credits
- Foreword
- About the Authors
- Acknowledgement
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Staying in Control
- Introduction
- Making the spreadsheet more readable with colors
- Making the spreadsheet more readable with comments
- Making the spreadsheet more readable using borders
- Using named ranges
- Selecting all worksheet cells with one click
- Copying the formatting of one cell to another cell or range
- Debugging your spreadsheets
- Navigation between worksheets
- Grouping the canvas components
-
2. Data Visualization
- Introduction
- Adding a line chart to your dashboard
- Using the bullet chart
- Using sparklines
- Using the combination chart
- Using the pie chart
- Using the XY chart
- Using the bubble chart
- Using the radar chart
- Using the OHLC chart and candlestick chart
- Sorting series
- Zooming in on charts
- Scaling the y-axis
- Using the tree map
- Showing a trend without a chart
- Displaying raw data
- Illustrating single values
-
3. From a Static to an Interactive Dashboard
- Introduction
- Drilling down from a chart
- Selecting your data from a list
- Using the Filter Selector component for hierarchies
- Alternative hierarchy selection method
- Using Filtered Rows
- Using maps to select data of an area or country
- Adding a MacOSX loading dock to your dashboard
- Resetting your data (reset button)
- Making selections from a custom image (push button and image component)
- Inputting data values
- Using Play Selector/Play Control
- Opening up a Web Intelligence report using dashboard parameters
- Selecting calendar dates
- Using sliders to create a what-if scenario
- 4. Dynamic Visibility
- 5. Using Alerts
- 6. Advanced Components
- 7. Dashboard Look and Feel
-
8. Dashboard Connectivity
- Introduction
- Creating a news ticker with Excel XML Maps
- Using Query as a WebService (QaaWS)
- Using Live Office connection
- Connecting to SAP BW
- Using Universe queries
- Passing values from dashboard to dashboard with Flash Variables
- Accessing dashboards with live data outside of Infoview using CELogonToken
- 9. Exporting and Publishing
-
10. Top Third-Party Add-ons
- Introduction
- Managing add-ons in Dashboard Design
- Connecting to CSV-files with the CSV-connector
- Integrating Google Maps with the GMaps plugin
- Connecting to Salesforce.com with DashConn
- Transferring data between dashboards with Data Sharer
- Presenting micro charts in a tree grid
- Integrating Web Intelligence with Antivia XWIS
- A. Real World Dashboard Case Studies
- B. Additional Resources— Supported Excel Functions and System/Software Requirements
Product information
- Title: SAP BusinessObjects Dashboards 4.0 Cookbook
- Author(s):
- Release date: May 2011
- Publisher(s): Packt Publishing
- ISBN: 9781849681780
You might also like
audiobook
Brainhacker
If you feel like your brain is "glitching," or working against you, know that you're not …
book
Quick Start Guide to Large Language Models: Strategies and Best Practices for Using ChatGPT and Other LLMs
The advancement of Large Language Models (LLMs) has revolutionized the field of Natural Language Processing in …
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
book
Generative Deep Learning, 2nd Edition
Generative AI is the hottest topic in tech. This practical book teaches machine learning engineers and …
