United States Department of Labor publishes quarterly data of H1-B and other visa applications. Below is an analysis and visualization of the same data. What is in the Data files? The data is available as CSV files. Each file contains around 500k records. It contains details of each application whether it is approved, rejected or … Read more
Let say you have the following three widgets on the dashboard Typically each widget can use its own individual SQL query to populate the widgets. Users widget: select count(*) from xuser Projects widget: select count(*) from xcategory Dashboards widget: select count(*) from xobject Now in the above example the SQL is pretty simple and it … Read more
With the latest release of InfoCaptor Enterprise Dashboards, you can now easily build visualizations using vector maps. Without the maps, you would usually view the countries or states within the country either on a bar chart or line chart. But now you can plot them on the geographic map with simple drag and drop. A … Read more
Following is an alternative visualization to the Veteran Suicide Dataset and visual found at News21 Since the dataset is available by USA state codes, it made sense to use the State cloropleth as below. Here is the direct link to the Veteran Suicide Visualization Dashboard On the top you can select the year and on … Read more
1. Add any box container or the icon that will display the date 2. Next right click and select ‘Data source’ In the connection drop down, select ‘Personal Cloud’ and in the SQL enter the following SQL select ‘dummy’ as Today 3. In the javascript window add this following code //get today’s … Read more
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
In the new release of InfoCaptor Enterprise, we added some very useful features. 1. Ability to connect to Postgres SQL 2. Ability to connect to Pervasive database 3. Test Database connections before adding them to the system. Infocaptor works will all types of JDBC and ODBC connections. So if you need to connect to DB2 … Read more
By default SQL server 2008 is not enabled for remote connection First you need to enable SQL server for remote connection to avoid the “SQL server connection refused: connect” error. Assuming your SQLserver is enabled for windows authentication and remote connection we can proceed as below. 1. Install Tomcat as service under the desired login … Read more
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
The front page of any company or organization is a very significant piece of that entity’s web presence. The question whether the front page does its job depends on 1. What message it is trying to deliver to the audience. 2. How quickly it delivers the message to the audience. 3. How forceful the message … Read more