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 , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


Databases are often under lock-n-key of the IT Department and not possible to connect directly due to security reasons. So if you plan to build a Dashboard prototype or a Dashboard Mockup it makes sense to export the data to …

Continue reading

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


In this article we will discuss a scenario and how to accomplish it within the dashboard. Let say you have two databases. Both databases have similar tables and you need to display the difference in the number of rows from …

Continue reading

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


  This is a simple chart to generate. It needs only X and Y values select film_id x ,count(inventory_id) y1 from inventory group by film_id

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


Would you like to build your dashboard now?

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