Blog of Data

I recently picked up a copy of Tableau Desktop Professional.  The primary reason for wanting it was to be able to do some advanced visualizations like the ones described here.  Mozilla has a few different datacenters in different parts of the world, and we just brought a new one online in Phoenix.  We wanted to [...]

Update: Ken Kovash studied the Firefox 3.6 downloads and found a wonderful reason for them! See here for more details. I was asked this evening if the nightly report was correct in showing that we had a 128% increase in Firefox downloads today.  The answer is a resounding yes that figure is correct, but I [...]

I received a notification from the Linux Counter project that it was time to review my membership. The project is a very simple little thing. You register the fact that you are a Linux user and you register simple information regarding any number of Linux machines that you use or control. You can also run [...]

I have had the chance to improve the bugzilla SQR in many ways. I have improved the overall run time inside of the ETL (both in kettle and in a python script), fixed a few bugs (A major one that was causing problem with the Open Bug Count), added new dimensions, and constructed a few [...]

I was presented with the challenge of answering the question – how many Firefox users have one add-on or more installed on their Firefox. Currently, addons.mozilla.org (AMO) has statistics on the download counts of add-ons but the actual usage of add-ons has been unanswered. The Add-ons manager inside of Firefox will check each add-on for [...]

Recently, I was asked if I could provide a breakdown of Firefox users on the Macintosh platform by whether they were using the Intel or PPC chipset. For anyone who only cares about seeing that data and not the “how” behind it, look no further than this link:
Firefox on Macintosh processor breakdown trends in Many Eyes

For anyone else, what follows is a detailed post about the volume of some of the data we parse, and some helpful AWK scripts that I use to parse it at times.

There is a lot to be said on the above topic, but for the moment, I just wanted to drop a quick note about some ad-hoc work I did today: I ran an analysis on a year and a half of FTP log files, filtering for some specific requests, and filtering out but summarizing uninteresting [...]

The metrics team wants to reach out to the community of Bugzilla users to learn what would benefit them by asking: In Bugzilla, what kind of analytic questions should be answered? We have some analytic questions that we can answer, and we have gathered some questions that people would like to have answered. This blog [...]

Mozilla’s bugzilla database contains approx. 480,000 bugs and approx. 5,000,000 entries in bugs_activity table and is too large for the initial development that I am doing. I want to construct a smaller sample Bugzilla data base that I can use to develop and run tests with for my project in a more efficient manner. To [...]

I am working on a project this summer that analyzes Bugzilla. The basis of this project has been started by Nick Goodman and he entitled it Software Quality Reports (SQR). Software Quality Reports gives product managers, project managers, development managers, and software engineers more information on things like bug burn down rate by product, issues [...]