How to build Dashboards using Excel data with InfoCaptor Dashboard Designer

by Nilesh Jethwa, Founder, InfoCaptorThursday, January 17, 2008

This paper will illustrate how to build Dashboard (reports, charts) from Excel Spreadsheet. The data file is also provided so you can follow the steps.

Final Digital Dashboard

For practice, you can download this excel spreadsheet and use the same SQL code in this document.
All of the SQL code that is highlighted in Yellow can be selected and copied using the Acrobat select option

Did you download InfoCaptor Dashboard Designer? If not, then it is a good idea to have it installed so you can follow the steps easily.

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.


1 2 3 4 5

 


    Other articles by this author

Discussion:

No comments have been posted yet.

Site Map | Contribute | Privacy Policy | Contact Us | Dashboard Insight © 2010