Video: Trend Analyzer: Combining Data Analysis and Visualization

trendanalyzerOften 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:

Click below to launch the Video in a New Window.

video_thumbnail

  1. Download the Excel file that will be used in this Example.
  2. Launch Xcelsius 2008 and Import the Downloaded Excel file.trendanalyzer1
  3. Place a Combination Chart component on the canvas.
    trendanalyzer3
  4. Double-click the Combination Chart to open the Properties panel.
    trendanalyzer2
  5. Bind Chart Title to Cell A1 and Subtitle to Cell A2.
    trendanalyzer4
  6. Click Data by Series; click the plus button to add a series to the list box. Bind the ‘Name’ of the series to Cell E2.
  7. Click the Values (Y) cell selector button and select the Source Data for this series; for this sample, select the data under the column header “Price”.
    trendanalyzer5
  8. Click the plus button to add another series to the list box. In the Name box, type “Trend”.
  9. Click the Values (Y) cell selector button and select the Source Data for this series; for this sample, select the empty cells under the column header “Analyzed Trend Data” (In Yellow).
    trendanalyzer5
  10. Click the Category Labels (X) cell selector button and select the data labels; for this sample select the data under the column header “Date”.
  11. Click the Appearance tab on the top; click the Series sub-tab.
  12. For the series “Price”, click the Type dropdown menu and select Column. For the series “Trend”, click the Type dropdown menu and select Line.
    trendanalyzer7
  13. Place a Trend Analyzer component on the canvas. Click the Trend Analyzer to open its Properties panel.
    trendanalyzer8
  14. Click the Data cell selector button and select the data to be analyzed for trending; for this sample, select the data under the column header “Price”.
  15. In the Trend/Regression Type section, click the Use Best Fit radio button.
  16. Click the Analyzed Data Destination cell selector button and select an empty range of cells for the new data series to be inserted into; for this sample, select the empty cells under the column header “Analyzed Trend Data”.
    trendanalyzer9
  17. Click Preview to view the between the Combination Chart component displayed with a trend line.
    trendanalyzer10

In this sample, the Trend Analyzer component analyzes the selected data and determines a the best way to display a trend line for the data.

Download Source Files:

download

  • Antony

    Thanks for the quick reply

    In “Trend Analyzer Component” Property, Click/Expand “More Options”

    under that “Equation Type Destination” & “Equation Destination”
    options are available.

    According to the data in “Trendanalyzer.Xls” the “Equation Destination” shows y=1.2517x+18.0616

    How this formula derived by Xcelsius ?

    How “Equation Type Destination” & “Equation Destination” works ?

  • Is it also possible to add a trend line to an xy chart?

    Regards

  • Krismaly

    I love your site.
    I wish further success in your future activities.
    I suggest to mention VersionĀ  of Xcelsius as point number 1

  • Anonymous

    Thanks Kris. I will make that change in all my future videos.