The data presentation graphic at right, and many of those sprinkled throughout this article (click them for better resolutions), are highlights from a gallery which have been produced by the R statistical software package. R is an open-source programming language and environment which has gained much popularity among academics who want to apply statistical methods
This gallery contains 10 photos.
May 4, 2013 12:10 PM / Leave a Comment
March 31, 2013 2:02 PM / Leave a Comment
If you have some experience, the topic of deleting consequential data automatically brings to mind optional safety measures in case things go wrong. The recent article concerning data deduplication is a good example. What if — I didn’t test my DELETE code enough and a snafu occurs? What if — I have to retrieve some or all of the deleted rows after the fact? What if — I want to keep the deleted rows (or partial rows) available on the side for inspection for awhile? Continue…
March 11, 2013 4:00 PM / Leave a Comment
The premise is as follows: You’ve got useful data lying in an Excel or Google spreadsheet which you’d like translated into relational table(s). This is likely going to involve normalizing the denormalized spreadsheet data on the way into the database; you are going to end up with (and want) more rows in your table than the corresponding quantity within the spreadsheet. The SQL tool for this is the UNPIVOT keyword. Continue…
Just a roundup of some recent takes on what people are up to in the area of data visualization. Also, some interesting places to look for more and a few notable blogs where you can keep posted about related topics.
This gallery contains 6 photos.
March 3, 2013 2:27 AM / Leave a Comment
February 20, 2013 1:09 PM / Leave a Comment
soybean gene mapping
February 16, 2013 5:19 PM / Leave a Comment
dedup these hay-bogarting heffers for me!
February 6, 2013 10:23 AM / Leave a Comment
E.F. ‘Ted’ Codd
February 1, 2013 1:03 PM / Leave a Comment
Netflix has been open and unrepentant about publicizing it’s strategy for cultivating value from all the event data at it’s fingertips due to it’s streaming service user base. Their data miners have been taking things far beyond the level of Amazon’s ‘smart’ book recommendations. This new drama, premiering tonight, has been statistically vetted regarding timeslot, programming, script, and even cast with heavy input from their S3/Hadoop cloud (they use AWS for their platform) of user preference and activity data. Continue…
January 27, 2013 5:00 PM / 1 Comment
Gartner Hype Cycle graphic cited by Sicular
January 23, 2013 11:24 AM / Leave a Comment
Lake Malawi
The premise is as follows: You’ve got useful data lying in an Excel or Google spreadsheet which you’d like translated into relational table(s). This is likely going to involve normalizing the denormalized spreadsheet data on the way into the database; you are going to end up with (and want) more rows in your table than the corresponding quantity within the spreadsheet. The SQL tool for this is the UNPIVOT keyword. Continue…
Netflix has been open and unrepentant about publicizing it’s strategy for cultivating value from all the event data at it’s fingertips due to it’s streaming service user base. Their data miners have been taking things far beyond the level of Amazon’s ‘smart’ book recommendations. This new drama, premiering tonight, has been statistically vetted regarding timeslot, programming, script, and even cast with heavy input from their S3/Hadoop cloud (they use AWS for their platform) of user preference and activity data. Continue…
