How to build pivot table in the dashboard
Check the different flavors of pivot tables you can build using dashboard software Here is a quick video, click on it Click on the above image to see full screen
dashboards
Do you spend too much time building reports with Google Analytics data?
How to streamline dashboard reporting with Google Analytics? There are lot of ways you can optimize your reporting with Google Analytics and I would like to bring your attention to a very powerful solution as described below. Our solution is not an Excel plugin but it is a packaged Datawarehouse. Let me assure and explain … Read more
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
Marriage and Divorce Rates Analysis Dashboard – CDC Data set
In this analysis we gather data from CDC for Marriage and Divorce rates across all the states of USA for past several years. As usual the bulk of the time is consumed in the data gathering, munging and preparation step for the analysis. All the data for each year is manually copy/pasted from the website … 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
Don’t Expect A Large Salary Increase If You Didn’t Go To College
What is the importance of education and getting formal degree? As per US Census data, following chart illustrates that if you have less than “college degree” then the jumps in your salary is very less as you progress in your age Notice the big jump in median salary with better than college degrees. This is … Read more
Sending and receiving money across the world – remittances between countries
The world bank publishes lot of interesting data and one about we are discussing is the remiitances between countries Using the 2013 dataset, we come with the following visualizations. Aggregating all the sending remiitances in millions of USD, we see that United States is the top country for sending remittances acros the world Click on … 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
SQL Server : Windows authentication with Tomcat
By default SQL server 2008 is not enabled for remote connection First you need to enable SQL server for remote connection to avoid the “SQL server connection refused: connect” error. Assuming your SQLserver is enabled for windows authentication and remote connection we can proceed as below. 1. Install Tomcat as service under the desired login … Read more