Someone on Reddit posted a summary of counts of AMA by category. The counts are shown in this thread Let us see how quickly we can visualize this data? Step1 : We copy the data and paste into Excel Inside the browser, we select the text, right click and copy the text We then paste … Read more
In this article we will expand on the “Bells and Whistles” section of our Dashboards. There are multiple ways to alert the user when your data crosses a certain threshold. The most used technique is to change the color of the data depending on whether the data is on the target, above the target or … Read more
Previously we built this Human Resource dashboard using Excel as the data source. The same can be built by putting the data in Google Spreadsheet and then slightly changing the queries. Checkout the entire HR video series for the tutorial In the same note, we replicated the data into a MySQL database so that … Read more
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
Data comes from variety of sources. It could be your Excel files, Microsoft Access or real SQL databases like MySQL, Oracle, SQL Server, DB2 etc. These databases are used to store information from your ERP, MRP, CRM or Datawarehouses. The data is everywhere and the most challenge is how to consolidate all information in few … Read more
Earlier in May 2012 we released our cloud based Dashboard Solution at https://my.infocaptor.com As anticipated, lot of users requested if they could host the same software within their own network. We are extremely excited to announce the availability of self hosted solution. The same application (https://my.infocaptor.com) is now available for you to use it in-house … Read more
InfoCaptor Enterprise is now available for everybody to build and use dashboards in the cloud. There is no installation or setup required. Just create a login and start using. https://my.infocaptor.com Bottomless visualization options Connection adapters to SQL databases (direct connection, no API needed) Connection adapters to various web applications (twitter, facebook, google spreadsheets, rss, POST, … Read more
When using Excel ODBC with PHP please use the following settings All settings are done in the connection_methods.php Windows 7 and Excel 2007 (support for .xls, .xlsx, .xlsm, .xlsb) $db_url=”DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};FIL=Excel 12.0;DriverID=1046;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text”; Windows XP and older Excel (just .xls) $db_url=”Driver={Microsoft Excel Driver (*.{$fileinfo[‘extension’]})} ;DriverId=790;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text”;