PASS BA Visual Data Storytelling precon session with Mico Yuk

CEO of BI Brainz | Author | Global Keynote Speaker | BI Influencer | Trainer | Blogger| BI Executive Advisor *@micoyuk*

I am super excited that Mico Yuk is joining us again at PASS BA Conference!

aaeaaqaaaaaaaasjaaaajdfkmzdiywy2lwizmtktnduxyy05zmfilwy1owyzodgyyjzmzaMico Yuk is well known in the Business Intelligence ecosystem as a community leader, BI influencer, controversial blogger, and the founder of the highly rated BI Coaching Series,
the BI Dashboard Formula (aka BIDF). Headquartered in Atlanta, GA, her team of senior coaches and consultants work with Executives to transform their BI teams to meet the challenges in the new era of BI through a series of coaching, training, and consulting services.Mico’s most recent accomplishments include being named one of the Top 50 Analytics Bloggers by SAP and being rated a #1 global keynote speaker at a number of global BI conferences.

A computer engineer by degree, she has been designing and implementing enterprise dashboards for major corporate clients since 2006 and is considered to be one of the top data visualization experts in the world.

First as a consultant and now through her company, she has helped to implement executive dashboard and reporting using the SAP BusinessObjects platform for customers such as Allstate, Pfizer, Aviva Canada, McKesson, Ryder Logistics, Digicel Jamaica, QatarGas, St. Jude Medical, Walgreens, Chiquita, LG, the US Airforce, Medtronics, SAP Global Marketing, Amtrak, Fresh Direct, Bank of America, and Nestle, to name a few.

To find out more about Mico, please visit http://micoyuk.com.

Visual Storytelling – How to Tell a “Compelling” Data Story That Matters to Your Users

This business-oriented, hands-on session will provide the foundation necessary to make your data visualizations more intelligent, actionable, and useful! Whether you are a beginner or a data visualization veteran, this session will guide you on telling more compelling stories with your data, from storyboarding fundamentals to more advanced techniques such as how to add smart context and visual cues. Attendees will learn:

• how to create a simple four-part visual storyboard on paper in minutes, not weeks
why visual storytelling is more effective than traditional reporting
• the one element 98% of data visualizations are missing and how it is negatively affecting user adoption

Format: Half-Day Classroom (Afternoon)

Register here

 

PASS BA Header Mico

 

Online Calendars of Global SQLFamily events

Further to my rather sad post yesterday about SQLSaturday Edinburgh, it was clear to me that the community needs a community events calendar that is open and available to everyone to use. There is a need to facilitate community communication about events in the Microsoft Data Platform community in Europe. This Calendar is a way of facilitating and organising the busy Microsoft Data Platform events calendar around Europe.

So, the obvious thing was for me to do a model in PowerBI, so that folks can go and play with it, work out dates and locations for their events, and so on.

I have already put a Google Calendar below. However, it isn’t very interactive, so that’s when my PowerBI workbook came into play. You can download the PowerBI workbook here. When the Power BI allows people to upload workbooks like Tableau Gallery does (#SubtleHint) then I will put it up there.

Note: This Calendar does not include user groups. This refers to day events, weekend events only. I am maintaining it myself, and please email me at jen.stirrup@datarelish.com if your event is missing or incorrect.

Note that I am happy to include paid events, precons and paid workshops as well. Please email me at jen.stirrup@datarelish.com to get your event included in the Calendar.

Note: the twitterjam for Europe SQL people will be held on the first Monday of the month at 5pm. The next one will be held on 7th March at 5pm GMT. And yes, it is in the calendar!

Also, I am happy to ‘share’ the Google calendar as well as the Power BI workbook.

HTML – Please use the following address to access your calendar in any web browser.

https://calendar.google.com/calendar/embed?src=6vmbcuhnno5t8gsj46u5mbqvlo%40group.calendar.google.com&ctz=Europe/London

ICAL – Please use the following address to access your calendar from other applications. You can copy and paste this into any calendar product that supports the iCal format.

https://calendar.google.com/calendar/ical/6vmbcuhnno5t8gsj46u5mbqvlo%40group.calendar.google.com/public/basic.ics
Please email me at jen.stirrup@datarelish.com if you have any other questions.

Jen’s PASS Diary: So what happened to SQLSaturday Edinburgh?

As always, I don’t officially represent PASS on this post (or any other).

I have been working on a lot of things, including attending a PASS Board Meeting, and doing a lot on the Business Analytics Portfolio. However, the focus of attention here is my failed SQLSaturday Edinburgh event. So what happened? The outcome is as follows:

  • SQLSaturday Edinburgh is cancelled
  • Edinburgh Power BI is cancelled
  • Three precons out of four have been cancelled.
  • I lost a few thousand pounds
  • My own precon is still going on; see previous point. I am trying to stem some of the losses

This has meant:

  • Cancelling the University of Edinburgh venue
  • Cancelling precon venue rooms
  • Many disappointed attendees – 51 people in all
  • Many disappointed potential speakers, who submitted 98 submissions from every continent in the world.

Why did Edinburgh fail?

Note that I’ve successfully gained sponsorships for the three past SQLSaturday Edinburgh events, SQLRelay, I’ve sent companies to SQLBits who eventually sponsored, and I’ve helped with sponsorships for PASS BA Analytics. Despite this wealth of experience, the stars were not aligned for Edinburgh.

I didn’t get sponsorship, apart from the fantastic CozyRoc. The CozyRoc team have been wonderfully supportive in my hour of need, and they have said that this won’t stop them supporting future events in Edinburgh, or me individually. I am hugely grateful for their support and I’d like to publicly thank them here.

Why didn’t I get sponsorship? Let’s look at the landscape of events:

There are also a bunch of other European SQLSaturdays which are in the lead up to my event. In one rejection email, one would-be sponsor pointed out to me that there are four SQLSaturdays in my area before my event, and explained that they couldn’t support Edinburgh because of the concentration of events around that time.

  • Kiev – event being held in 20th May
  • Plovdiv – event being held at 28th May
  • Krasnodar –  4th June
  • Rheinland – 11th June

If you look at the list, you can see that there are 7 SQL events between 2nd May and 11th June. This doesn’t include my failed Edinburgh event, which would take the total to 8 events in 47 days. That’s a lot, by anyone’s standards.

Further, this does not include the other events which take place after 11th June – Dublin, on 18th June, and Paris, on June 25th. This means that the total goes up to ten SQL events in the space of 9 weeks, three of which are major events – SQLBits, SQLNexus and SQLDay Poland.

I have been criticised for a number of things, and I will lay them out here:

– not responding to sponsor feedback . This simply isn’t true. I negotiated and offered to cut prices whilst giving more benefits. I bent and shifted and adapted to get cashflow in – hell, any cash flow. However, even offering sponsorship at rock bottom prices wasn’t enough. The answer was no, no and no again, and the same reasons given were the ones that I couldn’t do anything about – too many SQL events concentrated geographically and temporally. This wasn’t in my control.

– I am on the PASS Board, and apparently it’s a mark of my failure as an individual that I couldn’t organise a SQLSaturday. This isn’t true. I’ve organized a ton of events, and I do a lot for the community. Note the following points:

It does show integrity that I didn’t ‘pull strings’ to make being a Board member an advantage in some way, and I am clearly lost out in many ways, including financially.

I have seen, felt, and paid for, the ‘hard edge’ of being part of the SQL Server / Data Platform community. I have war wounds. This makes me a better Board member, I think, because I can speak for the ‘little guy’ and I am struggling and suffering due to this issue, and I think it can help me to empathise. I think I won votes because I ran successful events, partly. however, I think that the fact I have been there when an event fails, means that I can work to make sure that it doesn’t happen again.

– I’ve been told that I shouldn’t have organised my event temporally and geographically near the behemoth SQLBits event. Liverpool is about 200 miles away from Edinburgh, give or take. The events were six weeks apart.  I did not know the dates of SQLBits until the last moment, and I acted without being given the data. I had been given reassurances that the SQLBits dates wouldn’t impact PASS BA; however, it then turned out that they are in the same week. Be very clear; If I had known the SQLBits dates, I would have postponed Edinburgh. Full stop. I wasn’t told, so I didn’t know. The reasons for the communication failure are still a mystery to me, but I do wish that someone had said something. They would have helped me a lot in many ways by speaking/emailing me to forewarn me. I would have postponed Edinburgh so that it took place later year. Happy everyone.

To summarise, the main reason for the failure of Edinburgh was the lack of sponsorship; one repeated message given to me that there are simply too many SQL / Data events and the growth of events is outpacing sponsors’ ability to keep up and they are having to make difficult choices.

I would hate it if another volunteer went through this again in the future, and I’d like to think strategically to prevent it from happening to anyone else. So what’s the call to action?

  • If you consider yourself a European Data Platform technical leader, please get in touch. I am working with Microsoft to set up a Yammer group that I will invite you to. We can swap ideas, event dates, and basically facilitate communication.My email is jen dot stirrup at datarelish dot com. I am findable! Find me.
  • I’d like to set up a European Twitter chat on the first Monday of every month. This will take place at 5pm UK time, 6pm CET. The hashtag will be #EUSQL. Let’s talk about anything and everything European and SQL. I will be ‘chair’ but I will need volunteer ‘chairs’ too. If this is you, get in touch.
  • I will set up a European Linked In Group for European SQL leaders and participants. I will release details in due course. I’d like help with this; if this is you, please email me.

I want to thank the following people for offering to help, in no order:

Brent Ozar

Andrew Brust

Mike Hillwig

Neil Hambly

Stephanie Locke

Jonathan and Annette Allen

Satya Janyanty

Niko Neugebauer

PASS team – Sonya, Vicki, Angie, Teresa

PASS Board – everyone 🙂  Adam, Tom, Denise, Wendy, Tim, Craig, Argenis, Ryan, Allen

my family – Andrew S (my brother)

Microsoft – particularly Jen M and Jonathan W

Let’s work together so that nobody else is in this same situation. Please help me – to help YOU – avoid this situation.

[ Update: original comment was removed. I believed that someone was having a go at me. I will just leave that here.]