• Votes for this article 69 people voted for this
  • Dashboard Insight Newsletter Sign Up

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

 

Tweet article    Stumble article    Digg article    Buzz article    Delicious bookmark      Dashboard Insight RSS Feed
 
Other articles by this author

Discussion:

No comments have been posted yet.

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