Tag Archives: Fun

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

Friday is Training Day but …

… Friday night is party night.

Come to the conference venue and register for the SQL Saturday and then spend the rest of the evening with other delegates, speakers and sponsors. We have some great activities lined up for the night and we are offering some prizes for those who join in with our beach / surf style evening. Have you got a loud Hawaiian shirt or maybe board shorts and flip-flops are in your wardrobe just waiting for Summer? Wear them on the Friday night and help us set the tone for a fun and relaxed evening with some great people.

SaltrockTshirtsI mentioned prizes and the local surf clothing company Saltrock (www.saltrock.com | @saltrocksurf) have come up with some of their excellent quality and supremely comfortable T-shirts for us to give away as prizes. Many thanks to them for this but don’t worry if you are not one our lucky winners, they have a store in Exeter within 5 minutes walk of the conference venue. It’s about 4 doors away from the Apple store but ask us for directions if you want to call in there.

We will be announcing some of the plans for the evening as we get closer to the event, be sure you are subscribed to this site and following our twitter account: @SQLSatExeter.

If your name isn’t on the list, you aren’t coming in.

If you are attending a training day session then you wont need to re-register but please do bring your name badge so we can make sure that we let you in!

If you are bringing a partner to Exeter then you are welcome to bring them along to enjoy the party evening with us. If this is the case please email us us with advice of their name so that we can have a name badge made up ready for them.

We are all looking forward to seeing you there on the 21st!