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

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