HR Dashboard – Build Excel based Human Resource dashboard with filters – parameters and drill down

In this tutorial, we will demonstrate some of the new and powerful features of InfoCaptor Enterprise. The new features include Dashboard prompts that let you set global filters on one or multiple widgets. It also demonstrates and teaches how to build drill down in the dashboards and reports. Please view each video segment in the … Read more

Excel Cell Ranges using SQL – Named – Unnamed – ODBC – JDBC

How to query Excel files using ODBC – JDBC? Summary : Why use square brackets for SQL against Excel? How to access range of cells from Excel? How to use un-named range of cells? This topic is covered in various tutorial for InfoCaptor. These following snippets are taken directly from Microsoft website as easy reference … Read more