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
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
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
,self service bi
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.
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
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)