MyXcelsius.Com

Video: Trend Analyzer: Combining Data Analysis and Visualization

Dec 29th, 2008

trendanalyzer Often many components in Xcelsius are not used to their full potential. This may be because of the generic business requirements or lack of developers knowledge on the components repository in Xcelsius 2008. One such component is the Trend Analyzer. The Trend Analyzer combines data analysis and visualization. The component analyzes the data selection and provides an additional data series that can be plotted to display a trend line. The Trend Analyzer component does not display in the visualization. You can find the Trend Analyzer under the Other Category of the Components Browser in design mode of Xcelsius 2008. If used appropriately, this component can be a powerful trick to show trends within Xcelsius based dashboards.

Below is a demonstration of Trend Analyzer. You can find the same in Xcelsius 2008 User Guide, however without screenshots.

This is what you can achieve using Trend Analyzer:

It’s Interactive:

The steps below will produce a working visualization that will demonstrate the use of Trend Analyzer: Continue reading →

Posted in: Components, Introduction.
Tagged: Xcelsius Components

Part III: Live Dashboards using BO LiveOffice – Create an Xcelsius Dashboard bound to Live Office data

Dec 29th, 2008

by muhammedismail.

2 comments

This is Part III of the “Live Dashboards using BO LiveOffice” Series. In Part I, Kalyan Verma Introduces LiveOffice and its connection with Xcelsius 2008. In Part II Muhammed Ismail, walks us through the steps on “How to Create a LiveOffice Document and connect it to BusinessObjects Universe data”. In this final Part of the series, Muhammed walks us through the steps on How to bind Xcelsius Components to LiveOffice data and create a live dashboard.

Note: Muhammed used Xcelsius 4.5 to achieve this. He will be posting an Xcelsius 2008 version of the same procedure soon.

This article discussed below shows countries in the Asian region that participated in a survey. The live data is fed from the Business Objects universe; when the number of Asian countries in the universe data increases or decrease the map chart color will change and the number of countries will get updated.

Continue reading →

Posted in: LiveOffice, Xcelsius 2008.
Tagged: BusinessObjects Live Office · Xcelsius Connectivity

Heat Maps: Part I – What Are They?

Dec 28th, 2008

by Kalyan Verma.

2 comments

This is a three part series on Heat Maps. Part I is all about “What are Heat Maps?”, Part II: “Why Use Them” and Part III explains “How to Read One”

What is a Heat Map?

A heat map is a visualization of data which uses color to represent data values in a two-dimensional image. There are many different types of heat maps used in different disciplines, each referred to by the term “heat map”, even though they use different visualization techniques. Most heat maps use mapping techniques to represent their data rather than charting and graphing techniques, thus providing unique views of data not available in charts and graphs.

This article examines the most common types of heat maps and when each is used. The type of heat map used by Lab Escape’s Heat Map Explorer and Enterprise Tree Map SDK products is a tree map, which is the most common type of heat map in the business world.

1. Tree Maps

treemapxcelsius

Tree maps, or “treemaps”, are the most common type of heat map.

Used to represent large or complex data sets in applications ranging from stock market analysis, risk management, project portfolio analysis, market share analysis and network management, tree maps were invented by Ben Shneiderman at the University of Maryland in 1990.

Continue reading →

Posted in: Articles, Charts.
Tagged: Heat Map

Part II: Live Dashboards using BO LiveOffice – Creating a LiveOffice Document and connect it to BusinessObjects Universe data

Dec 25th, 2008

by muhammedismail.

13 comments

This is Part II of the “Live Dashboards using BO LiveOffice” Series. In Part I, Kalyan Verma Introduces LiveOffice and its connection with Xcelsius 2008. In this post Muhammed Ismail, walks us through the steps on “How to Create a LiveOffice Document and connect it to BusinessObjects Universe data”.

To create Live Office document first open the formatted Excel template. Set the BO Enterprise credentials by selecting Live Office, Options from MS Excel.