Prebuilt QlikView Script for Mozilla’s Open Data Visualization Contest

By Barry Harmsen

Mozilla Test PilotA few days ago I became aware of the Mozilla Open Data Visualization Contest that is being organized by Mozilla Labs and the Mozilla Metrics Team. The goal of this contest is to creatively visualize answers to the question “How do people use Firefox?”. For example by creating visualizations that investigate interesting usage patterns, reveal interesting user behavior, or explore browser performance.

I figured this would be a nice challenge, so I decided to download the data and load it into QlikView. Since I am always curious to see what other people can do with QlikView (it can be very educational) I have shared my load script and data cloud here, so that other developers interested in joining the competition can get a running start.

You can download my project file by clicking here (2.8MB). This zip file contains 3 files:

  • a qvw file preloaded with 100.000 records that contains the script to load the entire “A Week in the Life of a Browser – Version 2” data set into QlikView;
  • a text file with the script that you can paste into a new load script (for Personal Edition users) ;
  • an Excel worksheet that adds some additional data that is not in the base data set: country & language lookups, survey questions and answers and event descriptions.

As the source data set is pretty big I have not included it in the zip file, instead you can download the csv files separately from here. Be sure to place the files in the same directory as the qvw.

Please be warned that you will need a fairly hefty computer to load this data set into QlikView as the events table contains over 64 million rows.

Once the data has been loaded into QlikView you will have the following data cloud available to create your visualizations.

QlikView Data Cloud for the Mozilla Open Data Visualization Contest

The submission deadline for the competition is December 17th. Hopefully there will be many QlikView submissions.

Update 2010/12/21: QlikTech has put their visualization of the Mozilla data online on their demo site.

About The Author

Barry Harmsen

Hi there, I'm Barry and I'm a Business Intelligence Consultant at Bitmetric and based in the Netherlands. Originally from a background of 'traditional' Data Warehousing, Business Intelligence and Performance Management, for the past 10 years I have been specializing in Qlik and a more user-centric form of BI. I have done numerous QlikView and Qlik Sense implementations in many different roles and industries. In 2012 I co-authored the book QlikView 11 for Developers. You can follow me on Twitter at @meneerharmsen.

7 Comments

  • 1
    Brian
    November 22, 2010 - 22:24 | Permalink

    “you will need a fairly hefty computer”

    Do you have an estimate on this? Is a 64-bit Windows Server 2008 with 8GB RAM enough?

    • 2
      November 22, 2010 - 22:57 | Permalink

      The entire data cloud is around 6 GB when loaded into memory, so a 8 GB 64-bit server should be enough.

  • 3
    Jochem
    November 24, 2010 - 15:04 | Permalink

    Hé Barry,

    How to get those straight lines between the tables??
    Mine are allways diagonal.

    reg. Jochem

    • 4
      November 24, 2010 - 15:22 | Permalink

      Jochem,

      I just drag the tables until the lines are straight, maybe someone else knows an easier way.

      Kind regards,

      Barry

  • 5
    December 10, 2010 - 00:18 | Permalink

    Barry,

    Do you have any details about how a QlikView solution could be submitted for this contest? I’m interested in giving it a shot, but I’m not sure how the folks over at Mozilla will be able to work with / view my solution, since QlikView is a licensed application. It looks like they are interested in up to three views, so would I send them screenshots? Is there any other way to share a solution with Mozilla besides screenshots of my QlikView solution?

    Thank you,

    Jared

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    Read previous post:
    Options for geographical analysis in QlikView

    With over 80% of data* having a spatial component, geographical analysis can add a powerful new dimension to almost any...

    Close