Showing posts with label data. Show all posts
Showing posts with label data. Show all posts

Tuesday, December 21, 2010

links for 2010-12-21: Thoughts on Java stewardship; Losing your automotive anonymity

Tuesday, December 14, 2010

links for 2010-12-14: IBM's Watson to play Jeopardy; FreeBSD on EC2; Data on Hudson/Kohsuke; Open data

Wednesday, October 27, 2010

links for 2010-10-27: Netflix moves to AWS; RedMonk Analytics; Google Docs Charting; Apple alienating their users

Wednesday, October 20, 2010

links for 2010-10-20: SkySQL forking?; IBM, Oracle, and Java; Linux catching Microsoft; Developer Intelligence; Twitter predicts stocks; McNealy at PG West

Thursday, October 7, 2010

links for 2010-10-7: IE market share dips below 50%; Analysis of Google's response to Oracle; SQL and Big Data

Friday, August 20, 2010

links for 2010-08-20: Ellison to hire Hurd?; Laptop reliability survey; Google thwarted by California; Oracle vs Google on Java; Cloud data offers intelligence; Ubuntu advantages over Windows and OS X

Sunday, July 25, 2010

Visualizing your data with Tableau Public

As I've written before, I have a passion for data and oftentimes, particularly with large amounts of data, visualizing it is an extremely important part of understanding it.

As part of my computer ratings, I've created performance charts for awhile now and they are very useful in being able to see how a team has performed and any trends there may be.  You can see examples from my 2010 Superbowl Preview or BCS Championship Preview.

I've created these using Google Charts using a series of scripts to extract the data from my ratings system and format it into the appropriate URLs, but after learning about Tableau Public I've been wanting to give it a shot to see if it was easier or offered other benefits and with summer arriving finally had a chance to.

I created the charts for a few teams from last years college football season and the process was very straight-forward.  All I had to do was to create a CSV file of my data, import it into Tableau Public Desktop, then with a little drag and drop and configuration, create the charts.  It is then simple to publish to the web.  Here it is (click the image to get a full screen version):


This was definitely a lot easier than what I've been doing before.  As the 2010 football seasons start, I'll be trying it out more and seeing what else I can do with it and hopefully automate the generation of the charts as much as I have with Google.  Give it a try yourself!

Tuesday, May 4, 2010

links for 2010-05-04: IBM acquires Cast Iron Systems; Scaling open-source; Browser market share; Software patents are good ... for lawyers; Google's cash; Open Data; Android on your TV

Wednesday, April 21, 2010

links for 2010-04-21: VMware's "database" play; AT&T buoyed by iPhone; 2010 NFL projected records; Adobe giving up on iPhone

  • VMware’s SpringSource Redis and Rabbit acquisitions: A Database Play is Emerging - Just don't call it "database" apparently.  But as Paul Martiz said, "... we are adding to the repertoire of underlying middleware and technologies that we think are going to be needed to generate – to develop a new generation of applications." appears to be a strong plan.
  • AT&T earnings propelled by iPhone activations, connected devices like e-readers, GPS systems - If this causes them to continue to invest more in their network, all good.
  • 2010 NFL projected records - With the draft tomorrow, will your favorite team improve?  These projected records serve as a good baseline of what to expect next year and an interesting use of data from last years performance.
  • Adobe casts Flash lot with Android; Drops iPhone plans - Will this bite Apple in the future?  "The primary goal of Flash has always been to enable cross browser, platform and device development. The cool web game that you build can easily be targeted and deployed to multiple platforms and devices. However, this is the exact opposite of what Apple wants. They want to tie developers down to their platform, and restrict their options to make it difficult for developers to target other platforms."  Note that I've increasingly seen Flash crashing or hogging CPU on a Mac, but that too could be part of the Apple/Adobe battle.

Wednesday, April 14, 2010

links for 2010-04-14: Twitter ads; VMware/SS acquires RabbitMQ; Apps=Fish, Data=Wine

Monday, April 12, 2010

links for 2010-04-12: What Microsoft and Apple can learn from Ubuntu; Who will buy Palm?; Greenplum moves data to Cloud; Calculus explained

Saturday, April 10, 2010

Are the Red Sox and Yankees Slow? Let's look at the data

There has been a bit of hubbub about the pace of play in Yankees and Red Sox games after umpire Joe West call their slow play embarrassing.  Their first 3 games of the year were longish at 3:46, 3:48, and 3:21 but justifications for it include lots of hitting to the importance of the games to being national TV games with longer commercial breaks.

Rather than just throw various arguments around, lets go to the data to take a look at what it tells us.  The length of a game should be roughly determined by the number of innings, number of pitches, number of in inning pitching changes, and duration of the commercial breaks.  With that in mind, I looked at the three Yankess vs Red Sox games and then all the American League games played on 4/9 to compare them.

All the data is in a Google Docs spreadsheet, and includes the game time, innings, pitches, in inning pitching changes, and commercial length based on if it is a national TV game or not.  Using these stats I calculate the average time per pitch, which all things being equal should be pretty consistent from game to game.

DateGameTime per Pitch
4/6Yankees / Red Sox0:35
4/9Yankees / Rays0:33
4/4Yankees / Red Sox0:32
4/9Red Sox / Royals0:31
4/7Yankees / Red Sox0:31
4/9Blue Jays / Orioles0:30
4/9Twins / White Sox0:28
4/9Athletics / Angels0:28
4/9Indians / Tigers0:27
4/9Mariners / Rangers0:26

Now, admittedly it is a small sample size, but it seems pretty clear that there is something common about the 5 slowest games from the selected games.  Given that I've factored in a bunch of stuff, why is this?  It is likely caused by visits to the mound by the manager (which are limited) or fellow players (which aren't) and batters stepping out between pitches, and that is what Joe West was complaining about.

Is it the end of the world if some games are a few seconds per pitch slower than others?  In the grand scheme of things, probably not, but MLB has decided to try to speed things up and from the data above, it appears Joe West singling out the Yankees and Red Sox as the biggest offenders could very well be true.

Friday, April 9, 2010

Further Analysis of Java Platform Survey Results

I wrote about some initial observations and issues with a recent Java platform survey earlier today, but couldn't help myself and downloaded the raw data and did some further analysis myself and came across some additional interesting observations.

First, I dug into the Java EE app server data and like Rich fixed some of the grouping, specifically trying to get proper JBoss and Tomcat numbers.  Our numbers differ a bit as I think he may be double counting a bit for Tomcat and JBoss which I made sure not to do.


I've ignored Jonas/JRun/Jetty/Orion so the other likely represents GlassFish and Geronimo.  My chart shows JBoss behind WebSphere but ahead of WebLogic.

Since multiple answers were allowed though, it is interesting to see which combinations are most common.


Here, Tomcat is clearly the preferred second app server in a dual strategy, but perhaps surprisingly, there is a fair number that have both WebSphere and WebLogic.

Last, I took a closer look at the operating system data.  I first combined the different Linux responses into a single one.


As I mentioned in my earlier entry, Linux usage is nearly surpassing Windows and Solaris is well behind those two.

Next I looked at what operating systems were commonly included in the same response.



Not surprisingly Windows and Linux are the most common combination and the combinations with Solaris fall behind with Linux and Solaris slightly behind.

These results may match what you'd intuitively expect, but it is always good when the data backs up your intuition.

Java Platform Survey Results - Flaws and Observations

I love surveys and analyzing the resulting data from them, so was interested to take a look at Replay Solutions write up from their 2010 Java Platform Survey.  Unfortunately, as is the case with many survey's, the way the data is presented has some issues that could result in folks making the wrong conclusions.

Rich correctly pokes holes in the report pointing out the strange grouping of results, the significant "other", and the egregious omission of GlassFish from the survey (quite possibly the bulk of the 18% "other").  If GlassFish was even only half of the "other" it would be 9% and equal to Jetty and way ahead of Jonas/JRun/Orion (which were grouped together for some reason) and Resin, each at only 2%, which would seem to clearly justify GlassFish being called out on its own.  They do provide the raw data which is fantastic, but re-analyzing the data can't fix not asking the right questions.

But there were a few other items in the report that I found interesting.

The "most important Java IDE in 2010" is, no surprise, Eclipse, but NetBeans is a pretty solid #2 at 17% ahead of JDeveloper at 12%.  This would seem to support Oracle's decision to not kill NetBeans, but it is still unfortunate that it appears to be being relegated to a minor role.

And given all the noise about the Cloud, only 14% of the respondents indicate they will be deploying to the Cloud in 2010 with an astounding 67% having no plans.  Now I'm sure the adoption is still way up from 2009 and 14% is still significant, but the IT industry still appears to be cautious about going hole hog into the Cloud.  For those looking to use the Cloud, Amazon EC2 is still dominant at 13% but with "other" at 14% there seems to again be a missing option in the questions.

As far as operating systems for deployment go, Windows is no surprise leading at 57% but with Red Hat Linux at 35% well ahead of Solaris (18%) and other Linux variants close behind Solaris (SUSE 12%, other Linux 16%), Linux is arguably threatening Windows for the #1 spot.

Last, it is a bit of an odd question on frameworks and services as options to answer included everything from Spring to JMS to ESBs, but it is interesting to see that messaging/integration technologies like JMS and ESB at 29% and 24% are well ahead of Swing and JPA (21% and 15%) and not that far behind Spring and Hibernate (36% and 37%).

As always, data is fun to look at.

Thursday, April 8, 2010

links for 2010-04-08: C overtakes Java; Amazon SNS; Statistics and Data; Oracle and MySQL; iPhone OS 4

Thursday, April 1, 2010

links for 2010-04-01: NoSQL = Manual vs Auto; Automated Journalism; Scatterplots with R; Will the cloud rain cash?; Bing killing OpenOffice?; Logarithms

Thursday, March 18, 2010

links for 2010-03-18: Elastic Caching Platforms; Whole Web; Google Calendar

Friday, March 12, 2010

Data is a Wonderful Thing

The world we live in is generating increasing amounts of data each and every day.  And this is great as when you have the data, you can analyze and graph it in new and interesting ways.  From sports to weather to financials to politics to demographics to who knows what, being able to analyze data, look at trends, and visualize it through graphs, charts, maps, etc. brings tremendous power and insight.

Some examples of interesting data or analysis thereof I've come across in just the past week or so:
Stay tuned, I'll continue to share interesting data and applications of it I come across.

Wednesday, March 10, 2010

links for 2010-03-10: Google Public Data Explorer; iPhone Dev Agreement; Distributed companies