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
Infocaptor is a Business intelligence dashboard tool that also acts as a prototyping tool. In organizations there are users who develop and build dashboards, some users build the design and hand it over to the IT to create data connections and write SQL queries while some users simply want to view and interact with dashboards … Read more
Previously we saw how to build D3js Analog clock on the dashboard In the same note, we dig deeper and now take our data from database tables and visualize into pretty bubbles. Here is how the tabular data looks like Brazil 5,197.89 Argentina 702.69 France 1,025,156.84 Germany 2,604,893.08 Saudi Arabia 628.89 Denmark 598,323.01 Singapore 909,996.22 … Read more
This is a fun visualization using the power of D3 library InfoCaptor has this custom draw widget that lets you embed any HTML and external javascript. Using either the HTML widget or this custom draw widget we can use external libraries to build some cool visualizations. The HTML widget is pure static, means whatever html … Read more
Following steps will illustrate how to migrate dashboards from one infocaptor installation to another. This applies to the scenario for migrating dashboards from DEV to TEST or from TEST to Production enviornments. You may also use these steps to clone existing dashboards. In this tutorial we will migrate the following HR dashboard Each of … Read more
Someone on Reddit posted a summary of counts of AMA by category. The counts are shown in this thread Let us see how quickly we can visualize this data? Step1 : We copy the data and paste into Excel Inside the browser, we select the text, right click and copy the text We then paste … Read more
Previously we built this School District Metrics Dashboard and using more data files from the same Colorado School Framework website we build few more metrics. This one is more interactive than the previous one and it is suppose to be a browsable by School district and school name. The top portion highlights School District metrics … Read more
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
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