Words From a Purple Mind

Input on the important topics …to me of course

List of Helpful Sites for Xcelsius

Xcelsius allows you to create interactive dashboards for your personal use or your organization. You can create the dashboards from Microsoft Excel or a live data source, and export your dashboard to a another format – Microsoft Office, Flash (SWF) files, Adobe PDF, and Adobe Air.

Xcelsius Engage 2008

Xcelsius Engage 2008

The dashboard I am currently working on uses Excel for formatting, XML for data collection and PowerPoint for display. There are limitations to Xcelsius (ex: arrays, indirect, etc.) but you can always find a workaround. For instance, I ran into an issue with Xcelsius not allowing arrays for a sumif so my workaround was to have the data come through aggregated already allowing me to remove the sumifs as a whole.
Xcelsius does state that it can handle SUMIF’s, VLOOKUPs, Index, etc. but the more formulas you have in your dashboard the slower it becomes.

Below are some great links to help you with your dashboard creation:

Fellow Tweeters:

Forums:

Recommended Books:

Do you know of any other great sites/links that should be added to the list? Comment below & help others find great resources for their Xcelsius journey.

Check back often as I will be adding links as I find them.

Share

  • Hi Suresh,

    The data has to be formatted in order for Xcelsius to read it. Unfortunately at this time Xcelsuis doesn't provide the ability to hook right to SQL/ODBC connection. If you are set up using LiveOffice you can go that route.

    I personally chose the XML route because you can format the data in XML pretty easily and you are able to have multiple XML connections.

    I've tried the Centigon csv option but ended up not using it because it kept crashing on me, I've found that most of the tools can't handle large amounts of data even if it's aggregated first.

    Hope that helps. Please feel free to contact me if you need help.

    Thanks,
    Jay

  • Hi Suresh,

    The data has to be formatted in order for Xcelsius to read it. Unfortunately at this time Xcelsuis doesn't provide the ability to hook right to SQL/ODBC connection. If you are set up using LiveOffice you can go that route.

    I personally chose the XML route because you can format the data in XML pretty easily and you are able to have multiple XML connections.

    I've tried the Centigon csv option but ended up not using it because it kept crashing on me, I've found that most of the tools can't handle large amounts of data even if it's aggregated first.

    Hope that helps. Please feel free to contact me if you need help.

    Thanks,
    Jay

  • sure19

    Hi Jay,
    I am new to Xcelsius, but am finding it very interesting. My only issue is formatting the existing data to work for this. Do you have any suggestion or help for me on this. Can we use any other data like sql or any on this?
    Suresh – Dubai

  • Hi Andre,

    You could use the filtered rows option with dropdowns, slideshow buttons or label buttons. Let me know if you need any help. I am available for consulting work if needed.

  • andre

    Hi,

    I'm looking for a way to display 2 distinct scenarios in xcelsius. I do have the dataset for the 2 scenarios in a table and would have the user choose between these 2 sets. Any suggestions?

  • I have the data pre-aggregated before it comes into Xcelsius now. I still have Xcelsius do the summing for rollups but that's it.

  • Thank you for recommending the link. I have added it to the list.

  • I loved your collection.Another good site that i found was

    http://analysis-reporting.blogspot.com

    ..Has videos,formatting tricks & some intractive learning demos which was really good..

  • Jeanine McNutt

    Did you ever find a work around for Indirect()?

  • Pingback: PimpThisBlog.com()

  • In case you are interested Ryan Goodman will be the speaker at tomorrow's (5/13) webinar:
    https://www.sdn.sap.com/irj/scn/go/portal/prtro