What is the true benefit of Dashboards or Business Intelligence software?

In fact, the question should be “What should be the true benefit of Dashboards or Business Intelligence software? ” Whether you are using dashboard in excel, Dashboards in Microsoft Access, Quickbooks, business objects, Salesforce or big ERP like Oracle EBS or SAP, there are numerous tangible benefits of using InfoCaptor as your primary BI and … Read more

Have we lost the true meaning and purpose of Business Intelligence?

Have we lost the true meaning and purpose of Business Intelligence Companies in a variety of industries are still data-rich but information-poor and this ratio keeps increasing every day. The rate of data generation is so high that organizations simply cannot keep up with generating insights out of it. These enterprises lack the kind of … Read more

Venture Capital Investment Analytics on 20 years of investment data

In this article we will take an analytical approach and perform straight analytics on a huge dataset available from https://www.pwcmoneytree.com/. PWC Money tree provides a data dump of all the Venture capital investments from 1995 onwards. Having data that goes far into the history should give us enough to extract the necessary analytical juice out … Read more

Impact of sports in movies : Simple Data visualization Analysis – Basketball, Football, Hockey, Lacrosse, Miscellaneous sports

This http://www.the-numbers.com/keywords/ website contains lot of statistics related to movies and one important piece of juicy data is that they have categorized the movie listings by keywords. Using this list we try to analyze the popularity of sports in movies. 1. How has the featuring of sports as backdrop or prominent theme increased over the … Read more

Color and Pattern analysis on Flags of Countries – Simple visualization but interesting data

Flags are symbolic and have deep roots in the history of the country it represents. Ever wondered why certain countries have certain colors in their flags, why it has certain symbols and what are the different patterns. Recently, here at InfoCaptor we started a small research on the subject of flags. We wanted to answer … Read more

InfoCaptor 2.1 : Stunning Visual Analyzer and Data Discovery done right in your browser

People are drowning in Data and Organizations are drowning in a plethora of Analytic applications. Organizations are increasingly abandoning thin client mantra and are forced to adopt a mix of desktop based and web based analytic applications. If you notice around, all major BI vendors are increasingly pushing Desktop based Data visualizations. Providing Data Visualizations, … 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