Tag Archives: Community

Pirate BI Data Competition Sponsored by Pyramid Analytics at SQL Saturday Exeter

Pirate BI Data Competition  Sponsored by Pyramid Analytics

Can you make our data tell a story?

We have a challenge for anyone who thinks they can take a data and make it interesting and engaging. We have teamed up with Pyramid Analytics to create a BI competition with a superb prize for the winner to be announced during our Friday party evening.

Our Pirate Incident Dataset can be downloaded here http://1drv.ms/1GoXjgM 

The dataset is presented as an Excel File or CSV with the following headers :-

Date, Ship Name, Ship Type, IMO No., Area, Boarded?, Latitude, Longitude, Incident details, Consequences for crew etc, Action taken by master/crew, Reported?, Reported to, Reporting State, Coastal State,  Action Taken, MSC/Circ

Use the dataset as the basis of your entry to our panel of judges on the night*. Use the BI tool(s) of your choice to lift the data from a flat csv file to something that is pleasing to the eye and brings out the interesting facts to your audience.

You will see that the dataset fits with our Pirate Party theme, tell us all about the facts and figures of the Pirating Past. You might choose to engage with our judges by giving a presentation or you can create some infographics in advance that bring out the information in the data and simply send it to us. We are going to be judging entries on the visualisation of the data, not the presenter’s skills.

* In order to be eligible the main prize you need to be at the party however, if you want to join in but can’t make it we will also award a prize to the best ‘postal’ entry so send us your work and you can still get involved.


SQL Saturday Exeter 2015 – BI Competition rules

  1. You can use the visualisation and analysis tools or platforms of your choice but, if you are presenting on the night, you will need to be able to show your work – bring the right software with you on your own laptop/pc.
  2. Your presentation time must not exceed five minutes.
  3. Postal entries must reach us before 24/04/2015.
  4. Postal entries must be in a format that can be viewed on a laptop with no special software installed. We will have a selection of browsers and software to play mp4 video files but nothing else. If your presentation won’t run then we can’t judge it. If you are concerned about it, send us a preview in advance and we will advise you if there are any problems.
  5. Postal entries should be sent to jonathan@sqlsouthwest.co.uk, please mark in your email if you want confirmation that the entry has been received.
  6. You must use the dataset provided. However, you may add additional data to support your analysis and visualisation.
  7. The prizes and prizes winners will be announced on the evening of Friday 24th April 2015 after all presentations have been considered.
  8. Our judges decision will be final in reference to both prizes and no negotiation will be possible. They will be pleased to talk with all entrants to discuss their own entry if there are requests for feedback or questions about how to improve or alter the work for better impact.
  9. Any enquiries about the competition should be addressed to jonathan@sqlsouthwest.co.uk with a subject line of “Pirate Data Competition”

With Many Thanks to Pyramid Analytics for sponsoring the competition and providing the prize

SQL Saturday Exeter 2014 – over for another year

Thanks to all those who came to SQL Saturday Exeter on Friday and Saturday, we really hope you enjoyed your time with us and learned a lot.

If you didn’t make it along, here’s some of what you missed:

Friday was a pre-con training day, with 8 all day sessions each giving in-depth knowledge on a specific area of SQL Server. Emil Glownia started the review ball rolling, with this post on Friday following the pre-con training day.

The Friday night party was Surf themed, and many entered into the spirit of things. We had a surfing simulator going, and fierce competition ensued for top position.


The following morning, SQL Saturday itself started in earnest. We had a great turnout, and many full sessions.  For some speakers the demo gods were kind, for others, not so – an ever present reminder that typing in a demo can be dangerous!

Sometimes though, it was necessary to resort to the somewhat older technology of the flipchart!

(We ask speakers to upload session materials to our schedule page, or their own blog – which should be linked to from the schedule page – and tweet about them #SQLSatExeter)


It’s great to see speakers learning from their experiences at the event too – for example James Skipwith has written a blog post on what he’s learnt

For some, all this learning wasn’t enough, and so a party of 40 select people (well, O.K., the first 40 to put their names down after the shout went out) headed off for a curry!

Throughout the event there was great conversation from the SQL Community on twitter, using the hashtag  #SQLSatExeter

Some who attended have already shared their thoughts on the event – here’s a blog from Al Eardley.

Thanks to everyone for making the event what it was; we really couldn’t have done it without you – whether you were sponsoring, speaking, attending or just spreading the word.


We look forward to seeing you again soon.

The SQL Saturday Exeter #269 Committee.



(with apologies to @thomasrushton who missed out on being in this photo as he was doing something far more sensible at the time)