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 …

Continue reading

Posted in analytics, business intelligence, dashboards | Tagged , , , , , ,


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 …

Continue reading

Posted in analytics, business intelligence, dashboards, Excel, visualization | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


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 …

Continue reading

Posted in analytics, business intelligence, dashboards, data warehouse, datamart, Excel, visualization | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


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 …

Continue reading

Posted in analytics, business intelligence, dashboards | Tagged , , , , , , ,


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 …

Continue reading

Posted in analytics, bigdata, business intelligence, dashboards, data warehouse, Finance Dashboards, visualization | Tagged , , , , , , , ,


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 …

Continue reading

Posted in dashboards | Tagged , , , , , , , , , , , , , , ,


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 …

Continue reading

Posted in Charts, dashboards | Tagged , , , , , , , , , , , , , , , , ,


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 …

Continue reading

Posted in Announcement, dashboards | Tagged , , , , , , , , ,


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 …

Continue reading

Posted in How-to | Tagged , , , , , , , , , ,


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 …

Continue reading

Posted in Charts, dashboards, How-to | Tagged , , , ,


Would you like to build your dashboard now?

If so, click to buy now, including 60 minutes of dashboard development for free!