infocaptor logo

Dashboard Examples, Real dashboards made with public datasets. Sample charts and graphics that you can use as templates or inspiration. Cloud/SAAS Dashboard statistics The above dashboard is my.infocaptor.com statistics. It shows number of users,dashboards,projects,and groups created. It shows rolling 30 …

Continue reading

Posted in dashboards, DB2, Excel, Finance Dashboards, GL, Human Resource, MySQL, Oracle, quickbooks, SQL Server | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


In this article we will build the following consumer price index dashboard The data used in this dashboard is from the Inflation Trends website (source http://www.inflationtrends.com/ , compiled from various government sites such as http://bls.gov/data/#prices) To begin with we have …

Continue reading

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


In the previous section we built a simple dashboard using the CPI data. In this part, we will use some pivot SQL queries to facilitate comparison of multiple categories on the same chart. The charts require the data to be …

Continue reading

Posted in dashboards, Excel, How-to


InfoCaptor Enterprise now comes packaged with in-built mini datawarehouse that you can use it to upload flat files and convert them into SQL tables. Once your flat files are in SQL then you can perform join operations between multiple flat …

Continue reading

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


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 …

Continue reading

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


When you use the Add Date hierarchy columns for any date, by default it brings all calendar quarter and calendar month.   How do you get Fiscal Quarter Let say your fiscal year begins from 1st July then First Quarter …

Continue reading

Posted in Excel, How-to


Previous Step: Excel Dashboards - Part 1 Launch Dashboard Software and Connect Launch InfoCaptor Dashboard Software on your Desktop and click on the connect button on the toolbar The connection wizard has items that simplify connecting to different data sources. …

Continue reading

Posted in Excel, How-to


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


Previous step : Excel Dashboards - 2 Create Dashboard and Table portlet Once connected, it will show you a list of action items to pick from We will click on "New Blank Dashboard" In the Dashboard Name, we type in …

Continue reading

Posted in Excel, How-to


In this article we will take an Excel source containing scorecard information and convert into dials and speedometer charts. We will also create few bar trending charts. Consider the below sample data Source File: You can download the excel file …

Continue reading

Posted in Excel, How-to, MS Access