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

Add subtract data from two different database sources : Howto

How to perform calculations across different data sources/databases Imagine, you have a CRM database that contains all your customer and sales information and you have a different database that stores your GL and ERP data. Now add some complexity to it, your CRM database is say SQL Server or Microsoft Access or just Plain old … Read more

CEO Dashboard by compensation/pay, shares, efficiency, rank and age

Before we start, jump to this Top 500 CEO Compensation Dashboard This cool visualization is built on top of a curated data of top 500 CEOs listed in order of their annual compensation, direct salary, number of shares, efficiency, rank and age. This list is generated by Forbes.com This article is split in two parts, … Read more

Dashboard Examples – Web Dashboards – Samples – Real time live metrics

Dashboard Examples, Real dashboards made with public datasets. Sample charts and graphics that you can use as templates or inspiration. CEO Compensation interactive visualization   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 day chart for dashboards created per day, logins per day. … Read more

How to upload flat files like CSV and Excel data into SQL tables

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 files and perform advanced analytical queries using SQL. NOTE: InfoCaptor provides the ability to directly … Read more

Visual alerts – Exception highlighting in reports and dashboards

In this article we will expand on the “Bells and Whistles” section of our Dashboards. There are multiple ways to alert the user when your data crosses a certain threshold. The most used technique is to change the color of the data depending on whether the data is on the target, above the target or … Read more

HR Dashboard – Build Excel based Human Resource dashboard with filters – parameters and drill down

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 build drill down in the dashboards and reports. Please view each video segment in the … Read more