Category Archives: SQL Saturday

For the latest information about SQL Saturday in the South West, follow @SQLSatExeter and #SQLSatExeter on twitter.

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.

03

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

Training Day sessions announced for SQL Saturday 2015

It’s here, we are pleased to announce the sessions for our Training Day are ready for you to select from, we have sessions on SSIS, Performance Tuning, DBA skills, BI techniques and more. For all the details you really will have to see for yourself.

Don’t put this to one side, our Early Bird rate of £150 is only available on bookings made in January. Yep, it’s only £150 for a full day of world class SQL Server training so take a look at the sessions and book your place there as soon as you can. Of course, if you are a member of a UK SQL Server user group then you will get a discount, please contact your user group leader for the code to apply when you book.

If you need help, contact us for more information