How to draw a Sankey diagram

What is a sankey diagram? Sankey Diagram is kind of a flow chart that has multi-purpose use. It can be applied in lot of different domains. Even though they are popular to visualize manufacturing flow or energy flow diagrams, there are other domains like HR, Finance, Web analytics etc where you can find the benefit … 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

Thanksgiving Sales – shopping survey

Data source : https://nrf.com/ PDF used for the visualizations Analysing the survey results How Likely Are You Going To Shop On Thanksgiving Which Of The Following Days Do You Plan To Shop Thanksgiving Weekend? Did you shop on Thanksgiving Day last year?   Do You Plan To Shop Specifically For “Small Business Saturday” On Saturday, … Read more

Analysis and Data visualizations : Bed bugs, Y Combinator and Halloween

In this update we bring you different flavors of data analysis on what users have been publishing using our Data Visualizer 1. Y Combinator companies has more funding than the sum total of all remaining accelerators Does the above dinasaur image resemble the bar chart above? Check the complete analysis here 2. Number of local … 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

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

Consumer Price Index – Charts and Dashboard

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 the following spreadsheet The raw excel file has multiple sheets but the data of our … Read more

Create Pivot or crosstab data from flat table – Consumer price index dashboard

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 in certain format. It expects the first column to be the x-axis and the following … 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