Dashboard Resource - Executive, Business Digital Dashboards

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

Launch InfoCaptor

Connect to the Excel file

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