Excel Dashboards – Launch Designer and Connect to Excel

In the Previous article we briefly mentioned the benefits of Excel based dashboard

We continue the series in building the dashboard

This is the sample Excel Spreadsheet test_data.xls

Image

Launch InfoCaptor

Image

Connect to the Excel file

Image

If the path of the Excel file is “c:\files\data.xls” then use “\\” , result c:\\files\\data.xls
In this case the file to be used is “d:\\test_data.xls”.

Select “Excel File – sun.jdbc.odbc.JdbcOdbcDriver” from the Driver list.

Next we Create our first excel based dashboard

Excel Dashboard           OR           Access Dashboard

  1. 4 Responses to “Excel Dashboards – Launch Designer and Connect to Excel”

  2. Hi,

    I have downloaded your software for demo.While iam opening AR,Gl files displaying as Error.

    Can you plz.help me on this?

    Thanks,
    Anil

    By anil on Dec 16, 2008

  3. Hi Anil,
    Can you please send some screenshot of the error? Please email them at infocaptor@gmail.com.

    Thank you

    By admin on Jan 14, 2009

  1. 2 Trackback(s)

  2. Jan 14, 2008: Dashboard Resource - Executive, Business Digital Dashboards » Blog Archive » Create your first Excel Dashboard
  3. Jan 14, 2008: Dashboard Resource - Executive, Business Digital Dashboards » Blog Archive » Excel Dashboard - Charts, Gauges, Tables and Drills, Reports

Post a Comment