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 (more...)
The following is not something new but something that I have put together this evening, and I mainly make the following available as a note to myself and what I did. If you find it useful or interesting then you are more than welcome to use and share. You will also find lots of similar solutions on the web.
This evening I was playing around the the Text Mining (tm) package in R. So I (more...)
Lot of the entities have already paid the amount back to the government with interest and the government has made profits! Government has also lost money on lot of other organizations/companies that failed to repay back.
Checkout the full Visualization on the profit/loss analysis of Government Bailout money
And Here is the big list of all companies/organizations that made profit/loss and the percentage
Click on the image to see the full list
As 2014 draws to a close I working on finishing off a number of tasks and projects. One of these tasks is an annual one for me. The task is to list all the things I've done as an Oracle ACE Director. If has been a very busy year, not just with ACE activities but also work wise too. That will explain why I have been a bit quiet on the blogging side of things (more...)
If you are downloading the EA1 of SQL Developer that includes Oracle Data Miner (ODMr), and you intend to use Oracle Data Miner then you will need to update the ODMr Repository.
You could do it the hard way and run the upgrade repository sql scripts that are located in the ...sqldeveloper-188.8.131.52.29-no-jresqldeveloperdataminerscripts directory.
Or you could do it the easy way and let the inbuilt functionality in Oracle Data Miner do (more...)
These days Hortonworks with their IPO and Cloudera sitting on $1bn of cash grab all the headlines. However,the real visionary in the field is someone else. Someone blasting the previous world record in TeraSort . A Hadoop distribution on both Amazon Web Services and the Google Compute Engine. A company that Google is invested in. While their competitors have been in skirmishes with each other, MapR has been quietly working away and innovating.
MapR-FS: Features and (more...)
A few days ago the first Early Adaptor release of SQL Developer 4.1 (EA1) was made available. You can go ahead and download it from here and make sure to check out the blog post by Jeff Smith on some install and setup that is required around the latest version of Java.
I've been using SQL Developer since its very first release, so getting my hands on a new release is very exciting. There (more...)
We had a couple of issues reported with the output of the Next Generation Outline Extractor where the exported file did not work properly as a load file. After some investigation, we found that the file encoding was incorrect. We were encoding the files using the Unicode/UTF-8 format. We chose this encoding so that we could write all characters in all languages, but we did not consider that UTF-8 is only valid for loading Unicode (more...)
The UKOUG annual conferences commence on Sunday 7th December and run until Wednesday 10th.
Like previous years there are two conferences, one called TECH15 and the other is called APPS15. You might guess what each conference is about!!.
This year these conferences are being held at the same time and in the same venue. But they are separate conferences!.
This year I've been very lucky (or very unlucky) to have 3 presentations at these conferences. (more...)
How has the interest in Big Data, Hadoop, Business Intelligence, Analytics and Dashboards changed over the years?
One easy way to gauge the interest is to measure how much news is generated for the related term and Google Trends allows you do that very easily.
After plugging all of the above terms in Google trends and further analysis leads to the following visualizations.
Aggregating the results by year
It is very amazing to see (more...)
Quarterly breakup of units sold by manufacturer
View the interactive visualizations
The south and the West consume highest amount of Fruits.
Here is more individual breakdown by Quarterly expenditure on Fruits (figures in 100 million)
Average undergraduate tuition and fees and room and board rates
These figures are inflation adjusted and look how just the tuition fees have increased compared to the Dorm and Board rates
Now comparing the rate increase for 2-year program
So for the 2 year program, the board rates have remained at the same level compared to the dorm rates.
Now check out the interesting graph for 4 year program below
Virginia maintains the summary of Deer kills way back from 1947
The stack bar gives a total view of the killings and how it has grown over the years
By comparing the killings on a line chart we see that the female Deer killings has an uptick from 2008 onwards
iCasualties.org maintains documented list of all fatalities for Iraq and Afghanistan wars.
Analysing the USA dataset, we summarize the results by the year
USA war fatalities by year
We are approaching the levels of 2002 and hope for the best that we don’t have to suffer another wars.
Here is another view by year and month
The dataset contains the age of each (more...)
GitHub maintains a list of all DMCA takedown notices along with counteractions and retractions if any.
Analysing all the notices from 2011, it seems that the takedown notices are on the rise.
Year View : Notice the sharp increase in 2014
Quarterly view : Now looking at the quarterly breakup, seems like the takedowns are cooling off in the later quarters.
So who is issuing these DMCA takedowns?
Here is the complete list (more...)