Campus Days 2013 – My abstract did not make the cut ;(

Unfortunately none of my abstracts for Campus Days 2013 were selected, so i’ll just hang in there and submit some more next year.

The speakers selected this year is quite a bunch, there are some of the best people in the business speaking about almost every aspect of BI and SQL. 2 of my collegues will be speaking of Hekaton in SQL 2014 and how to gain performance in the ETL flow by using HEKATON, that will be interesting to listen in on.

It is Jens Vestergaard (Blog|Twitter) and Rasmus Reinholdt Nielsen (LinkedIN|Twitter)


Have a look at the tracks, and other information about Campus days in Copenhagen – Click on the logo

Submitted my abstract for Microsoft Campus Days 2013


Just submitted my abstract for Microsoft på Campus Days 2013, it will be a tour in GeoFlow for Excel 2013.

Level 200, basic introduction to GeoFlow and demo of how easy and fast it has become to visualize data in Excel 2013. And now that more government institutions sets their data free, it is even more interesting.

So cross your fingers, and maybe we’ll see each other in CineMaXx Copenhagen ;o)

Have a look at the tracks, and other information about Campus days in Copenhagen – Click on the logo

Microsoft Geoflow for Excel 2013 – Quick visualization of data

The other night I decided the time was right for some new tools, so I downloaded Geoflow from Microsoft (link here). I tried the few demos found on the site, which is based on data from US, and as I’m a Dane I would like to have some local data to work with.

So I set out to find me some data from Denmark, this was a task that was harder that I imagined, but finally I managed to find a data set from the Police Department. As it would be they have a rather fine database which is open to the public (link here). The only issue in that respect is that there is no geolocation data in their dataset.

That meant that I had to manually add Latitude and Longitude to the dataset, one thing that work in my favor is that Denmark is a rather small country and therefor the police jurisdiction areas is rather low. That meant that I only had to find Latitude and Longitude for 13 police headquarters using, a bit tedious, but I managed.

 After a little work with the data, I ended up with the following dataset.

 When the data is ready, just click on the Map button in the Insert Ribbon.


Then GeoFlow will launch in another window, just as we are used to when working with i.e. PowerPivot, there the first thing at hand is to add the latitude and longitude from the dataset to the map, just point and click ;o)


When that I done, just click the button named Map It, that takes you to the following screen.

Here you have the option to add data to the map, what I did here was add Date, Politikreds (police jurisdiction) and Røveri (robbery) to the map. The result is the the screen below.


When data is mapped in GeoFlow, there you can push the play button in the lower of the screen, then data is visualized over time, and it is easy to spot differences in certain areas, at least way easier than looking at millions of rows in a spreadsheet.

My GeoFlow spreadsheet is available here, and I hope you will have as much fun playing with GeoFlow as I had the other night.

Røverier.xlsx (395.94 kb)