How to make dashboard using PostgreSQL database

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows.

Are you using PostgreSQL for your data marts or data-warehouse? If so, build your Free PostgreSQL performance dashboard software.

Read more at http://www.infocaptor.com/ice-database-connect-dashboard-to-postgresql-sql

Comments Off on How to make dashboard using PostgreSQL database

Creating dashboard with SQL Server Database

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications?which may run either on the same computer or on another computer across a network (including the Internet).

InfoCaptor works with SQL Server using jTDS jdbc driver. http://jtds.sourceforge.net/ 
Some more information on connection issues with SQL server http://www.infocaptor.com/dashboard/jdbc-with-sqlserver-connection-refused-connect

Read more at http://www.infocaptor.com/ice-database-connect-dashboard-to-sqlserver-sql

Comments Off on Creating dashboard with SQL Server Database

Building dashboard with Oracle database

Oracle database is one of the top Enterprise grade RDBMS. Many enterprise applications are built on top of Oracle db. Among the most popular Enterprise apps are Oracle e-business suite, Peoplesoft.

If you are tired with slow and sluggish OBIEE, try building your Oracle Accounts Recievables Dashboard using InfoCaptor. You could easily build your Oracle General Ledger, Oracle Accounts payables and all other ERP related analytics using InfoCaptor.

 

Read more at http://www.infocaptor.com/ice-database-connect-dashboard-to-oracle-sql

Comments Off on Building dashboard with Oracle database

VC Investment Data visualization and analytics

Using the data from pwcmoneytree.com and easy to use dashboard software we perform analytics on a huge dataset that spans 20 years of Venture capital investment data from 1995 onward. Having data that goes far into the history should give us enough to extract the necessary analytical juice out of it.

 

VC investment by industry

Change in investment pattern between 2000 and 2014

The year 2000 was definitely the peak for VC investment craziness. A whopping 105 Billions was pumped into startups and bringing them quickly for IPO. Ever since after the crash of 2000... Continue reading the original article

Comments Off on VC Investment Data visualization and analytics

Bed bugs in Boston – Analysis of Boston 311 public dataset

Digging into the Boston public Dataset can reveal interesting and juicy facts. Even though there is nothing juicy about Bed bugs but the data about Boston open cases for Bed bugs is quite interesting and worth looking at. We uploaded the entire 50 mb data dump which is around 500K rows into the Data Visualizer and filtered the category for Bed Bugs. Splitting the date into its date hierarchy components we then plotted the month on the Y axis. It seems that the City of Boston started collecting this data around 2011 and has only partial data for that year. Interestingly, the number of Bed bug cases seem to rise during the summer months. Now if we break the lines into Quarters (we just add the quarter hierarchy to the mix)
Comments Off on Bed bugs in Boston – Analysis of Boston 311 public dataset