===== BAKE Open Data =====

{{http://farm8.staticflickr.com/7092/6974720172_cfbaaeef07.jpg}}
[[http://www.flickr.com/photos/dakt/tags/bakeopendata/|Photo gallery]]

We are baking an **open data cake**, i.e. a pie chart that actually tastes good! Nutrition statistics from the Swiss Open Government Data portal will be used to decorate it. The cake will be served as dessert for the participants of the [[bern:en|Bern Open Data Camp]].

  - Find a delicious recipe [[http://www.bettybossi.ch/de/pdf/detail_SchwerpunktthemaTourdesuisse_pdf_109.pdf|Rüeblitorte - süsser Gruss aus dem Aargau]] (PDF)
  - Obtain the ingredients and baking materials
  - Prepare the cake mixtures, beat it nice and smooth
  - Bake in the oven for about an hour, it's ready when your dip comes out clean
  - Let it sit overnight, meanwhile analyse the data and prepare your infographic
  - Once the cake is cool transfer your graphics onto the cake with marzipan and sugar paint

Processed //"Nahrungsmittelverbrauch nach Art der Nahrungsmittel"// spreadsheet with our graph: [[https://www.dropbox.com/s/no7rz3r75sx2c86/je-d-07.01.02.01.ods|LibreOffice]] [[https://www.dropbox.com/s/uqlxwakx2vjbbsv/je-d-07.01.02.01.xls|XLS]]

===== Data =====

  * [[http://www.bfs.admin.ch/bfs/portal/de/index/themen.html|Statistics portal of the Swiss government]]
  * [[http://www.bfs.admin.ch/bfs/portal/de/index/themen/07/03/blank/data/01/04.Document.21047.xls|Nahrungsmittelverbrauch nach Art der Nahrungsmittel]] (XLS) < what we used
  * [[http://www.novafeel.de/ernaehrung/kalorientabelle/kalorientabelle.htm|Kalorientabelle]]
  * [[http://www.suissebalance.ch/logicio/pmws/indexDOM.php?client_id=suissebalance&page_id=intern_41&lang_iso639=de|Suissebalance]]
  * [[http://www.bag.admin.ch/themen/ernaehrung_bewegung/05141/05145/index.html?lang=de&download=NHzLpZeg7t,lnp6I0NTU042l2Z6ln1acy4Zn4Z2qZpnO2Yuq2Z6gpJCFeoJ7fWym162epYbg2c_JjKbNoKSn6A--|Ernährung in der Schweiz]] 2006 report
  * [[http://qwikfix.co.uk/hmrc-contact-number/|HMRC Contact Number UK]]

===== Team =====

  * [[user:joudacc|Franziska Oeschger]]
  * [[user:loleg|Oleg Lavrovsky]]

===== Inspirations =====

  * [[information:quickstart|Open Data Quickstart]]
  * [[http://make.opendata.ch/archive/hannes30/|WebGL data cake]] by [[user:loleg]]
  * [[http://www.audreelapierre.com/nutritionalfactspackaging.htm|Nutritional Facts Packaging]]


{{tag>status:demo hardware dataviz}}