Life in lockdown and beyond

Posted on by
2

So this is the abridged version of my lockdown reflections/antics. After 4 full pages I decided it was a little over the top!! So you will be pleased to hear I opted instead for quick snippets…

  • From total sceptic to anxious shopper!
  • Schools closed – one happy 9 year old!
  • McDonalds closed – one devastated 9 year old!
  • Parks and play centres closed – one confused 3 year old!
  • The ‘cough cough’ – only way to explain the lockdown restrictions to my 3 year old (invented by my 9 year old).
  • Sunday dinners at my mum’s on hold – A 20 year routine!
  • Weekly shopping delivered to my mum’s in exchange for her amazing homemade cakes.
  • Virtual fitness sessions with friends – I have been running Monday workouts via Zoom with 3 of my mates to make sure we stay physically and mentally fit! Wasn’t sure it would last beyond a couple of weeks – 15 weeks later still going strong (pardon the pun!)
  • #DrawwithRob – remembering I love to draw! And inspiring my 9 year to pick up a pencil.
  • #PEwithJoe – attempt to get my 9 year old moving! Giving him a score out of 10 based on how much effort he puts in.
  • Family walks – exploring the local countryside with the family that ‘don’t walk’! They do now! Simple joys are finding a stream to throw rocks in – who needs play centres!?!
  • Growing veg – mum buys seeds for the kids to grow…they weren’t interested luckily I embraced the challenge and now eagerly waiting for my first batch of carrots and sweet peppers!
  • Home schooling – 2 weeks of a painful rota replaced by a bit of online learning and virtual math’s lessons from Grandma (thanks Mum!)
  • Family quiz night – 7 houses and lots of technical challenges, rotating the quiz master with my 8 year nephew absolutely bossing it!
  • Losing myself in boxsets – currently binge watching Peaky Blinders (love it!)
  • Clapping for the NHS, carers and keyworkers every Thursday – proud to work for the NHS
  • Working from home:
    • Camping table squeezed into bedroom to create home office space
    • Using old TVs for second monitors
    • Using toy box to raise my laptop for stand-up meetings
    • Hiding in the bedroom every Tuesday when my 3 year old thinks I have gone out to work! Please don’t tell him (oh and don’t worry my other half is looking after him!)
    • Realising after 10 weeks that we should buy an office chair rather than struggle using a dining room chair and lugging it up and down the stairs!
  • Virtual huddles – implementing virtual daily huddles with the team to keep us all connected and engaged.
  • Virtual huddle daily questions – introducing a daily ‘question’ to get everyone talking = positive start to the day; “what superpower would you have?”
  • Virtual meetings – the new norm, new buzz words (“you are on mute!”), regular interruptions (kids, cats and the delivery person)
  • New tech – embracing new tech like never before…Zoom, MS teams, Remo…bring it all on! Finding the best tools to collaborate and connect!
  • New priorities – sudden shift in the priorities to support the response to COVID19 (we need data and we need it now….stepping up to the new challenges)
  • Data driven – supporting the need to use data to help inform the ‘bring back better’ – embracing the opportunity to sit on the Recovery Board
  • Discovering that I quite like working from home!
  • Not missing the daily commutes!!
  • Tableau user groups – successfully transitioning to virtual Tableau users groups (Northwest and UK Healthcare group).
  • Indian Tableau Healthcare user group – opportunity to “attend” and present at other user groups despite them being on the other side of the world!
  • Attending and taking part in Tableau live – Tableau’s first virtual conference (ok so not quite Vegas but still cool!)
  • Presenting on webinars – wondering if this will ever feel ‘normal’
  • 1 virtual roundtable chat with other NHS leaders – sharing our challenges
  • Coaching qualification – lockdown whilst working towards my ILM level 5 meant quickly adapting to virtual coaching! 18 hours of coaching done – 3 pieces of course work to go – wish me luck, deadline looming…!!
  • Being coached – sitting on the other side and challenging myself to dig deep.
  • The weather – so many amazing days of sunshine; grateful for having a lovely garden and countryside on my doorstep
  • Wow…what a list

It’s July and the year is flying by considering how much of life has been paused. This pause has given me lots of time to reflect on life and appreciate the simple things. There are so many things to feel grateful for. I wonder what life will be like in a year from now?!

Thanks for reading. Ella

Stay Safe and keep talking!

  • #drawwithrob
    world record attempt
  • Walk to top of hills behind our house!

Coaching – the power of ‘listening’

Posted on by
1

Last autumn, after having a chat with Claire Bradshaw, I signed up to complete my ILM Level 5 certificate in Coaching and Mentoring with her. I am hugely passionate about effective leadership and I am always reflecting on my performance as a leader. What I really enjoy is helping others develop and maximise their potential, so this qualification seemed like a great opportunity to work on my coaching and mentoring skills. I have been on one day courses for both coaching and mentoring some years ago, and feel like I use some of the skills I learnt but I was keen to develop these further.

I am now nearing the end of the formal training which I will have finished by the end of February and am now working to complete my assignment and my coaching hours. Reflecting back to just before I started the qualification I have to be honest I don’t think I had any major expectation other than to develop skills to be able to effectively coach people individually. I am not embarrassed to say that it has opened my eyes to far more than the ability to coach. One of the most critical skills to coaching is listening, which sounds simple as we all know how to do that don’t we? To be a really effective coach though is about really listening (active to deep listening)! This was something we discussed and practised a lot in the first few days of the course, and I feel have highly underestimated this simple skills my entire life (honestly!).

My new found awareness of listening is probably one of the biggest things I have taken away from the course, not only is it something I am conscious of during my formal coaching sessions with my coachees but also something I am conscious of outside of these sessions too. What I mean by ‘really’ listening is giving people opportunity to talk without interruption, noticing how they are saying things, the types of words they use and also the body language and tone. This can say a lot about what is going on for this person and using this extra understanding can help to make sure the response I make to what they are ‘really’ saying is most effective and supportive. This skill (if you can call it that) has sneaked into my day to day working life, whether it’s conversations with my team or colleagues, or even in meetings it’s really helping me make sure I give people/things the attention they need and really understand what is going on. We have a lot of meetings at work, and sometimes it’s really hard to concentrate (well it is for me…) through the whole meetings, especially ones that last longer than an hour. So I have been challenging myself to see if I can use my listening and noticing skills to help me maintain my concentration, and it definitely seems to be helping (work will be pleased!!).

Recently I had a meeting with a few members of my team and like most meetings with a group of people some people talk more than others. For this meeting though, after discussing it with one of the people on my course, I thought I would try one of the exercises we learnt from the course about ‘thinking about thinking’. Like the course I split the team into pairs, and gave them the topic we were meeting about. They each had 90 seconds to talk about that topic. Again by allowing someone to speak without interruption would ideally give them all a chance to talk and share their thoughts on the topic, but also allowed time to see whether what they were thinking would change once they heard what the other person had to say. We then got back into a group and gave each person a chance to share what they were thinking now. Again they took it in turns without interruption! As I hoped the thoughts of individuals grew as they heard other people talk and we had a well-rounded discussion with lots of different ideas about the topic. I can’t remember the last time we had a meeting where everyone talked equally and all were heard. I think they will agree it was probably one of the most effective meetings we have had for a long time, and we walked out with our next steps and all understanding each other’s view points (or at least I think they did!). For me it was great, as I chair the meetings generally in this situation I jump in my ideas and I am conscious that sometimes I may dominate the conversation with my giddiness and therefore I don’t always give everyone the opportunity to speak and encourage their ideas and thoughts. For once I talked the least and listened the most!

As I write this I am thinking that the common thread here has to be listening although as I planned my blog I thought it maybe more. Yes there are lots of tools and techniques that I am picking up from the course that are fab, and I have used loads of them in different situations but at the heart of all these is listening. And therefore really hearing what is said so your response and your actions are based on what you actually heard rather than what you thought you heard.

I can’t write a blog about my coaching course without mentioning Claire, but I will try not to embarrass her too much. The last few months on this course have been great, as you will have heard it has had a profound effect on me. I have been on the course alongside 7 amazing people too, most of whom I hadn’t met before and I couldn’t have asked for a greater group of people and I am pretty sure we will all be friends for life (cheesy but true!). What makes Claire special and therefore has made this course special is her ability to listen too. Claire’s positive attitude makes you always feels good about yourself; she gets to know you and adapts the course to make sure it works for us all. Thank you Claire for giving me a nudge to do the course!! 

Thanks for reading my blog. Feedback always welcome!

Ella

2019 – my year in numbers

Posted on by
Reply

I have been meaning to write a blog reflecting on 2019 since the end of 2019! I can’t believe it’s taken me nearly 8 weeks of 2020 to sit down and get this done…. When I started to plan my blog about 2019 I realised I was counting significant events and milestones, The numbers added up and I thought rather than write about my year I would create a viz!!

Click on the link below to view the interactive version on Tableau Public which allows you to hover over each number and get more information! If you wish to know more…

https://public.tableau.com/profile/ella.worsdale#!/vizhome/2019-myyearinnumbers/2019innumbers

With a viz now built it is important for me to reflect on 2019 in words in too, but only briefly as my blogs do tend to be quite lengthy once I get started! I can’t quite believe how much I squeezed into one year, and this doesn’t include lots of personal events and loads more day to day work. 2019 was an amazing year for me with loads great opportunities for me to do new things; webinars, opportunity to sit on a judging panel and speak at loads of different events and meet loads of new people. I had some very proud moments over the year too with the two significant milestones that I am most proud of and humbled by. Becoming a Tableau Ambassador was the highlight of my summer, and then to be awarded the Tableau Community Founder Award was the icing on the cake. To be given the opportunity to travel to Las Vegas for the Tableau conference was unreal!! These opportunities rarely come along when you work in the public sector so I totally acknowledge and appreciated this. I still can’t quite believe I went, and still buzzing about it 4 months later.

Looking forward to seeing what 2020 will bring!

Thanks for reading my blog and hopefully checking out my numbers viz.

Feedback always welcome!

#data19 – Tableau Conference (Las Vegas – Nov 2019)

Posted on by
1

It’s been a seriously crazy month!!!

On 29th October I had a catch up call with Amanda Boyle from Tableau and Simon Beaumont (Zen Master and Tableau Ambassador), they told me that I had been awarded the Tableau Community Founders Award! They went on to explain that this meant that I would be given an all-expenses paid trip to the Tableau Conference in Las Vegas!! After briefly stunned into silence, followed by a series of shock responses. Wow…seriously…wow….OMG….you are joking….etc etc.. I then had to check that they meant the conference that was 2 weeks away!?!

Obviously I was absolutely over the moon; working in the public sector of the NHS in the UK doesn’t generally come with the opportunity to attend conferences in America!! To win this award means so much to me, and truly humbling. Discovering Tableau 5 years ago and then discovering the Tableau community a couple of years later has definitely changed my life! I love being part of the Tableau community, and love running two user groups in the UK.  It may take a little effort to fit this in alongside work and family life, but I get so much out of running them that it is genuinely worth it and never feels like a chore. It was so amazing to be recognised for what I do.

https://www.tableau.com/about/blog/2019/9/tableau-community-founders-award-nominations-open

So after the phone call on the 29th October I had less than 2 weeks to sort out how I was going to make this happen! Fortunately I have an amazingly supportive family who were almost as excited as me. My partner thought it would be great if he could tag along (he’d never been to the US before), and my mum said she would be more than happy to have the kids recognising what an amazing opportunity this would be. What an absolute star she is, we are so lucky to have her in our lives! Work was also equally supportive, and thrilled for me. With both these things sorted, I quickly booked flights and accommodations and started to juggle my diary so that I could take an unexpected week out of my work schedule.

I have attended the Tableau conference in Europe for the last 5 years, but have always had to watch the US conference from afar. Always wondering what it would be like to attend!

Once my travel plans were arranged I immediately downloaded the conference app and started to plan my conference! Still feeling unreal! In fact now I am back and writing this it still feels a little bit like a dream, but I am absolutely buzzing from the experience and it’s currently never far from my thoughts!

My #Data19 highlights

On arrival at the Luxor (our hotel of choice for the conference) we immediately started spotting the very distinctive conference lanyards. My partner couldn’t believe that everywhere he looked there were data people, but I was immediately in my element and was super excited to get myself into the data village!

The welcome party was my first view of the colossal data village! This was my opportunity to catch up with the Tableau community, those I already know plus I got the chance to meet loads of the #datafam that I had only ever admired and talked to through social media! Amazing to meet so many new people!! Plus who knew my photo would be hanging in a tree in the centre of the Tableau community area of the data village alongside some of my data heroes!

The first notable moment of the conference was getting a high five from one of the Tableau people on the way into the keynote! People generally don’t really high five in the UK especially not at a conference! Loved it!!

Keynote sessions:

The keynote sessions of Tableau conferences are always one of the biggest highlights for me. Data19 keynotes didn’t let me down! The size of the arena for the keynote blew me away….seating 8000 people it felt more like a concert than a conference.

In the opening keynote we met the CEO of Salesforce, Mark Benioff, interesting guy and whilst the presentation about the data culture at Nissan was really interesting and gave me some ideas, I couldn’t get over the fact that I have obviously been saying it wrong for years.  Who knew it was pronounced ‘Neeess on’ – I thought it was ‘Niss An’ (please read in your best impression of a Manchester accent). The highlight of the keynote being the story about the American women code breakers of the World War 2 and a standing ovation for Liza Mundy who wrote Code Girls who was sitting in the front row.

The first day ended with IronViz! It couldn’t end in a better way. This time it did actually feel like a concert, we were given lightsabres to wave around as the lights dimmed to welcome on stage the 3 contestants. I was in absolute awe of the contestants and their final food vizzes after 20 minutes their work was incredible. It was so difficult to pick a winner! It’s hard to explain how exciting the IronViz is even to the most passionate data people I know, but if you are going to only watch one thing from the conference then this is definitely worth checking out!

The conference just kept on giving! Day two kicked off with Devs on Stage. My absolute favourite part of Tableau conference. This bit started with a ‘tune’ made especially for me…I mean the conference!!! Now I was in my absolute element……’we are data people’! 10 days on I have still got this going round my head, it’s more catchy than ‘Baby Shark’!! Seriously – could the conference get any better!?! Everyone was loving it, people were on their feet dancing at the front!!

So as well as the ‘tune’! the Devs on stage killed it! The Devs share the updates about Tableau in such an entertaining way. I love hearing about the new features despite being on a much older version of Tableau. It always sparks ideas in my head! Can’t wait for PDF subscriptions, animations and dynamic parameters!!!!

Breakout sessions

As I was a bit late to the ‘party’ loads of the sessions I would have loved to attend were fully booked up so I am busy trying to catch up on the ones I would have attended since I got back. I still managed to attend a few really useful sessions though. Tableau blueprint and updating our data strategy, interesting session around extensions and workforce analytics but my favourite had to be Collaborative Vizzes by Tableau Ambassadors Kevin Flerlage and Lindsay Betzendahl. I love hearing about people working together in such a collaborative way. I am now inspired to build a collaborative viz, and already have a conversation with a colleague about doing this.

I also got to attend the live Workout Wednesday session. This was my first ever Workout Wednesday so I was a bit daunted by vizzing under pressure. It didn’t help when my computer didn’t work! But luckily Lorna Eden was on hand to lend me hers, I didn’t get very far but I enjoyed taking part and enjoyed meeting another workout Wednesday newbie who was sitting on my table! And my new mantra…I must do more Workout Wednesdays! Such a great way of testing out your Tableau skills and pushing yourself to learn more.

Braindates

Braindates – What an amazing idea! This was such a brilliant opportunity to connect with people in a different way. Basically you could post a topic and people could join a group Braindate if they were also interested to talk about the said topic. Alternatively you could create one to one Braindates again on a subject that you were interested to share your ideas on. I had 5 Braindates which were all really useful! Simon Beaumont encouraged me to share my experience of Agile project management so that I set this up and got the chance to have 3 Braindates with others interested in sharing ideas around implementing Agile which was fab. I agreed to keep in touch with all of them to continue to share ideas and see how they are getting on. I had one Braindate around board reporting and one around mental health outcomes with Stephanie Augustine from Orange County, California. I really enjoyed the braindates concept, it gave me chance to meet new people with similar interests and challenges. Fingers crossed they run these at the European conference next year! Such a great way of meeting new people and expanding my network!

In between braindating, breakout sessions and the keynotes I managed to make sure I got my fill of the data village. Checked out the vendors (got some freebies for the kids!), had a quick look in the Tableau store and chatted to lots of different people in the data village. Always on a mission to share ideas to take back to the office. Oh and I might have tried out the slide into the ball pit!

My conference ended with the Data Night out on the Thursday as we had to get back early for the kids. Probably couldn’t be a better way to end my time in Las Vegas. The party was pretty amazing; with a massive neon sign shining above the Palm Casino telling Vegas the data people were in town! And the night ended with the new data anthem ‘We are Data People…we are data people…’!

It has been really hard to write this blog, and in fact it’s less of a blog and more the ramblings of someone who can’t believe they were in Vegas two weeks ago attending the mother of all conferences! It wasn’t hard because I had nothing to say, it’s because I had too much to say and struggled to put into words how much attending the Tableau conference meant to me. I am so touched to be nominated for the community founders award let alone win it. I have had such a good year and this has been the icing on the cake. It doesn’t go without saying that I recognise how lucky I am to be given this opportunity. Thank you #datafam.

Big shout out to Simon Beaumont for his continued support, and to Amanda Boyle and Jordan Scott for making sure I got to Vegas and always taking great care of the Tableau community!

If you made it to the end my blog post, thank you for reading my ramblings!

Northwest Tableau User Group – 30th Sept 2019

Posted on by
Reply

Bit of a write up about our user group in September! #NWTUG

2 weeks on from our 6th official Tableau Northwest User Group and I am still buzzing from the fact that we had just over 100 #tableau enthusiasts in attendance! What’s probably more impressive is that we had 148 people register their interest to attend, the northwest community is certainly growing!

I have already written a blog about how much I love running the user groups so I will try not to repeat myself. But I can’t write this blog without saying how much I love these events. It’s great to get the opportunity to set these up with Lorna and Colin. My biggest love is bringing people together; watching people, with similar interests and views, connect is just brilliant.

We alternate between evening groups and day time groups in order to suit everyone’s preferences, we understand that not everyone can make the evening ones and we can fit so much more into a full day session. The user group on the 30th was no exception to this, we had a rammed pack agenda. Despite some unexpected changes in the line up a few days before the event Lorna (#absolutelegend) managed to work her magic and fill a couple of spots with some great people.

So after squeezing everyone into the room in the Tech Incubator (great venue!) on Oxford Road in Manchester we introduced ourselves and the day. First up we had Carl Allchin (@datajedininja) from the Information Lab talking about Tableau Prep, great to hear this new (ish) Tableau functionality explained so well. Did you know there is a Tableau prep weekly challenge run by Carl and Jonathan Allenby, which is really useful for honing your prep skills? Check it out; the site has challenges and blogs to help you: www.preppindata.blogspot.com

After Carl we welcomed Lucy Tiffany (@lucytiffany) who I am proud to say is one of my amazing colleagues from Pennine Care NHS Foundation Trust. This was Lucy’s first time presenting at a user group, and she absolutely smashed it, demonstrating some really useful top tips for beginners and beyond. Lucy has had loads of great feedback from the attendees, so reckon you will be seeing her at other user groups soon! Lucy has published her top tips to her Tableau public site: https://public.tableau.com/profile/lucy.tiffany#!/vizhome/TopTipsforBeginners-NWTUG30092019/Dashboard1

Carl Slifer from Interworks was up next talking about user experience, which I think sometimes does get overlooked when us data people are busy concentrating on the data visualisation. He talked about making sure that you make the Tableau Server work to help our data consumers navigate and view the data they want. It is really key to keeping them engaged! Lots of food for the thought from Carl.

After some real practical Tableau talks we next heard from Amy Rider of Jaguar Land Rover (JLR) presenting on JLR’s Tableau journey and how she is helping to grow their data driven culture. Amy talked about the challenges that seem to be common in all sectors and businesses, so easy to relate to wherever you are from. Amy also talked about using the server admin stats to really understand her data consumers, and make sure they are delivering what people want and need! It is always brilliant to have a mixture of presentations to play to the different preferences of our attendees. I love this type of presentation as someone who is leading on the data culture for Pennine Care, so got some great ideas from Amy’s talk to take back to work! Thanks Amy!!

After 4 presentations it was definitely time for lunch! As more people turned up than we quite expected (not that we thought no one would turn up to the party but we will always be anxious about this!) we didn’t quite order enough food, but luckily Caroline Yam from Tableau was on hand to sort this out and stock us up!! Thanks Caroline – you are an absolute star…nothing worse than hungry data people!!

I kicked off the afternoon with my second favourite thing to Tableau a Kahoot quiz! We had two rounds, a data themed quiz and then because we were in Manchester I designed a Manchester quiz (who knew that Manchester was the birth place of Vegetarianism!). This gave us opportunity to give away some Tableau swag to the lucky quiz winners. Who knew that a data cap would be so sought after!!

Craig Bloodworth (@craigbloodworth) from the Information Lab then led a session on the new features of Tableau. He kicked off his presentation by finding out what version of Tableau everyone was on! He got everyone standing up, and only let them sit down when he said their current Tableau version. I am afraid to say that myself and Lorna and a few others were left standing when he got to 10.4! Oh how we dream of the later versions!! Amongst other things Craig used York Housing prices to demonstrate the new spacial features in Tableau. So impressive! And interesting to find out that Craig’s number one criteria for choosing a new house is that it must be within a mile of his favourite restaurant! Craig also mentioned the new tagging functionality in Tableau Public to allow users to tag who inspired them and include # so that when people are searching for specific initiatives or themes they can easily find them! Craig’s session was rammed packed with loads of useful information about the new features, which was excellent.

I think the highlight of the day has to be our final session from the dataviz legend Andy Kirk (@visualisingdata)! So whilst the attendees had been nicely watching from their seats all day (apart from a little finger exercise doing Kahoot), Andy wasn’t going to let them get away with not taking part in the day. Andy’s session definitely woke everyone up. His session was about thinking about thinking. Andy picked teams with help from his lovely assistant Lorna to take on a number of challenges including getting teams to analyse a receipt (who knew there was so much to look at, and that Andy’s favourite chocolate bar is a Mars bar?!). His mission was to get people really thinking about the things they need to consider when truly analysing data. After 3 challenges we had the finalists! The final teams had to come up with ways to classify Randoms (yes the soft and chewy yummy sweets!). The most unusual classification would win! The competitors took this very seriously, huddling over the sweets debating all the things they could about the sweets! Genius activity!!

The winning team won because they came up with a classification of whether the sweet was something they could drive in?! Yes its ‘random’! What a brilliant way to end a brilliant day!

Oh it would be wrong of me not to promote Andy’s new book – available I am sure in all good book retailers! www.visualisingdata.com

After a swift post TUG drink with a few of the hard core attendees, I headed home buzzing about another amazing TUG, thinking about how we can make the next one even better! Myself, Lorna and Colin are now busy planning the next one, likely to be an evening event at end of November! Watch this space!!

If you fancy speaking at a future group then please let one of us know! It can be any Tableau/data related topic that you think others may find useful. We would love to hear your data story!!

Hope you enjoyed my blog and hopefully we’ll see you at a future TUG!

Learning through teaching

Posted on by
3

I am not sure ‘teach’ is the right word, probably it should be skills sharing but anyway let’s call it teaching for ease. I was keen to talk about how teaching others has helped to improve my own skills and understanding.  Since I discovered the magic of Tableau and then went on to implement Tableau in my organisation, part of the journey was getting my team trained.

After purchasing my first Tableau desktop license I had a little bit of training to get me started but then went on to teach myself. I then built the first dashboards for our pilot site which all worked and did the job they were intended to do so I felt pretty confident I could teach my team how to use Tableau desktop. Despite coming from a family of educators I wouldn’t say I am a natural teacher but I did my best to get everyone going with Tableau.

I created a small syllabus of things that the team needed to get them started and we blocked out Wednesday mornings for sessions. The team quickly picked up the skills they needed, and started to teach themselves, helping each other learn new tricks and use Google for the rest. Just after implementing Tableau I went off on maternity leave for 8 months so left them to it! On my return Tableau was firmly embedded in the team and their skills had rocketed, leaving me to catch up. We then all topped up our Tableau skills with some formal training through Interworks which really helped us to push further on with our dashboard developments for the organisation. 

The internal introduction to Tableau followed up by formal training once people have got to grips with the basics seems to work well, so we have continued in this way for the last few years. I have continued to teach my new staff and colleagues the basics of Tableau ever since. I passed my Tableau Desktop Associate Certification last September and although I had been using Tableau for a few years I had to do a lot of revision to get me through it. There was lots of functionality in Tableau that I simply hadn’t ever used, and I was also doing things in Tableau but didn’t necessarily know why.  I am definitely no Tableau Zen master by any stretch of the imagination and actually through training some of my team again I realised I was still doing stuff in Tableau with results but couldn’t explain why! So I have been trying to make sure I do understand what I am doing so that when I show others I can explain why, and encourage them to understand why certain actions result in certain outputs. Therefore learning through teaching!

I have implemented a Tableau competency framework within our organisation for people who are responsible for building dashboards. This framework is based on Fi Gordon’s Tableau Quest (thanks Fi – https://www.vizchic.com/tableauquest/). I have named one of the challenges ‘train the dragon’ which basically requires them to present/train a specific Tableau functionality to others. On a mission currently to encourage my team to take on this element of the framework so their skills continue to grow.

I have also started running workshops on Agile project management this year, and so far have run two workshops with another couple planned in September and October. Again I am no Agile project management expert, and I have no certificates to back up my skills. But what I do have is a few years under my belt using Agile project management within my team and seeing my team use it with good results. The external courses some of my team have attended recently had been poor (all theory and no practical!) so I thought I would try do this myself with help from my colleague Lucy based on our experience and knowledge. The workshops have gone pretty well, with positive feedback and people putting their learning into practice since; which is great! As I said I am no Agile project management guru, but by having to teach some of the theory it has forced me to really understand the theories and methodologies that underpin Agile. After each workshop we have run I have come away more confident about using Agile within the organisation and our team, simply by actually understanding it more through teaching others.

I would encourage everyone to ‘teach’! It will make you more confident in your own ability; you know more than you think you do! You will learn why, because when you share your skills with others they will ask ‘why?’, and you need to know the answer or be able to find out (even if it’s together!). It doesn’t matter how big or small, it doesn’t need to be a whole workshop or a full training session just start sharing what you do know!

Hope you enjoyed reading my blog!

Dude, where’s my dashboard?!

Posted on by
Reply

One of the most useful things we have ever implemented in our Information Team is unique identifiers for our ad-hoc data requests, routine reports and statutory returns. I can’t take the credit for this. An Analyst who joined my team about ten years ago (and has since moved on) brought this from his previous job. It was so obvious when he suggested it!

It helps so much when people are talking about a certain report. We can make sure we are all talking about the same report. It makes our ad-hoc reporting process easier too. If someone wants a refresh of an ad-hoc that has been requested 6 months earlier we will ask them for the ad-hoc ID and we can quickly find the report they are referring to plus the query that had been written to support it. This has massively streamlined the ad-hoc process, and reduced the need to recreate something from scratch. We have different prefixes depending on the type of report (ad-hoc, statutory report etc), and it made our folder structure more organised too.

Over the last decade pretty much everything we do has been given a unique reference identifier; datasets, data warehouse fact and dimension tables, key performance indicators, procedures etc. It make things so much easier to find, and ensures that we are always talking about the same thing!

Moving forward to the implementation of Tableau in 2016, although we have a Tableau report log which allocates each workbook with a unique reference identifier (TABxxxx) I wasn’t keen to put these IDs on the Tableau server for our consumers to see. I wanted it to seem less formal for our dashboard consumers, and I never thought there would be that many dashboards in each area that would mean we would get confused about what dashboards we were referring to! During the implementation a few of my team disagreed with me, and kept pushing for IDs being published in the names of our dashboards. I finally lost this battle which was made easier to lose as I was soon off on maternity leave and had other things to worry about!

3 years on and I still get reminded of my bad decision by at least one of my team! I will admit that I was wrong (and this is rare occasion for anyone who knows me…). There are now over a 1000 dashboards across our Tableau server site, and most of the dashboards have their unique ID in the title of the workbook. The ones that don’t are generally the ones that I published during implementation (sorry!). We will definitely be fixing these in our next upgrade.

Like everything else we did prior to this, the IDs make it so much easier to support our Tableau consumers. When someone contacts us with issues or changes to a dashboard we can simply ask them to tell us the ID, and we can make sure we respond to their request quickly and effectively. For those that don’t have IDs we have to ask for a link, or try and find it, which isn’t as effective especially if the request has been emailed over. Plus it is then not as easy to record the info about the issue on our Information request database for someone to action later. We don’t use Tags on Tableau (though it is something we are thinking about), but the search area of Tableau works really well with the IDs.

I have learnt my lesson about IDs, and recently created some new committee reports which contained a lot of key performance indicators (40+). Whilst creating these I decided to add an ID next to each indicator, and page number on each tab of the report so that when the committee were talking about a certain key performance indicator they could reference the page and ID allowing everyone to turn to that indicator quickly. It went down well, and will really help when changes are needed too.

So if you are just about to implement Tableau server (or re-looking at the way you navigate around Tableau or in fact navigating anything similar) I would absolutely recommend adding unique reference identifiers to each of your workbooks. It makes life so much easier – it’s a real no brainer!

Hope you enjoyed reading my blog!

Why Agile Project Management could work for you!

Posted on by
5

About 6 years ago I started to hear a lot about Agile Project Management, Scrum and Kanban, and was keen to understand what these things were all about and whether we could use these methodologies in my team. One of the team went on an Agile Project Management course and came back really enthused. So we took one of our big development projects and tried to run it using the principles of Agile Project Management. Whilst we got some positive results, it didn’t really take off. I think the biggest problem was that we hadn’t considered how this could work alongside our day to day work, and which developments would suit this approach.

About a year later we had a major issue with one of our statutory submissions. The main cause of this was a reliance on a key individual who was juggling lots of different work, supporting other staff plus constantly responding to day to day queries. Juggling competing demands was a real challenge for the team and one that is common in most workplaces. I needed to find a solution to the problem relating to this submission which included removing the reliance on one individual, and ensuring we had a quality assured and robust process in place for this submission. I decided that we would re-look at using Agile project management methodologies to get this sorted. I spoke to senior management in the organisation and asked them to support us solving this issue through using Agile Management. It was really important that I got this support so that senior management could help me make sure people understood the impact this could have on our other workload.

We set up one of our offices as a ‘sprint office’ and identified key stakeholders, a product owner, scrum master and the development team with a mixed skill set. We sat down and agreed a clear Product Backlog; this then allowed us to agree the Sprint Backlog and the timescales that these could be delivered in. We agreed that the development team would work on this project from 10am to 4pm for 2 weeks allowing time at the beginning and end of the day to catch up on emails, pick up any other work and support the wider team. Between 10 and 4 they would turn off emails and phones, and no one was allowed to disturb them unless it was something urgent. Even then they had to come via me so I could understand why they needed to interrupt them. In practice no one actually needed to disturb the development team and everyone was happy to wait to talk them before 10 or after 4 without a detriment to the wider team and our other workload.

At the end of the two weeks we had got the products that we had agreed to during our Sprint Planning Session. During the Review and Retrospective we agreed to have an extra week to improve them even further. Everyone was keen that we didn’t wait to do this so we started the final sprint the following week. The project/sprint was a great success; at the end of the 3 weeks, knowledge had been shared, the process had been completely re-built, the process had been tested with a quality assurance element incorporated, and procedures had been written and tested by the development team and by others in the wider team. This meant that we had now removed a reliance on one individual; we had a quality assured process and could assure the wider organisation and senior managers that there was very little chance that we would have any further issues. With this new approach having such great results we were able to get support from the wider organisation to use this methodology in the future.

I had always worried that if I took a few people out of the team to work on something in protected time that we wouldn’t be able to manage the demand and priorities outside of this. It was great to see that this wasn’t the case and I was able to challenge our priorities and manage our workload alongside using this methodology. This was mainly because people could see how many benefits Agile was delivering and they only had to wait slightly longer for other work.

Since then we have continued to identify and run projects using elements and principles of Agile project management with varying success. The varying successes are generally down to having the wrong mix of skills in the team, not always having a clear Product/Sprint Backlog and not always having engagement from key stakeholders. Despite this we have learnt from both those that have gone well and those that haven’t,  and worked out what recipe is required to make these a success, and  the results are always an improvement on what we would have previously been able to do.

It is also brilliant to get positive feedback from those who have been part of these projects, they have really welcomed having focussed time on something so they can do a really good job on this and they always learn something new. It is great to see the team motivated to run sprints and I love seeing real collaboration in action.

I also try to embed the principles of Agile project management into our approach to managing all our workload. It’s not always possible to have sprints to do everything as there is not always enough resource and capacity to work in this way. However one of the main principles of Agile is time management so these can definitely be applied without having a formal project.

I recently organised a one day ‘hackathon’ for my team.  I was reluctant to call it a sprint because it was one day and we weren’t going to be using kanbans or have scrum meeting plus there was 17 of us. During a previous away day we had all agreed that due to the staffing changes over the last 18 months we really needed to revisit our processes within the team. So we hired a room big enough for the 17 of us, I organised the day into sections and split the team into 4 groups. We had 16 processes to re-write so each group took 4 processes and had about an hour to write their four. During this first hour the group discussed the processes and debated how these were constructed. Then we circulated the processes round the groups giving them 40 minutes for the following sets of processes so they had 10 minutes per process to review it and add to it. By the end of the day we had 16 processes drafted which everyone in the team had had chance to review and add their ideas to. So not only did we have processes that we could now take back into the office and test out, everyone had been involved in writing them, and everyone had learnt about other processes from other work areas in the team.

If we had tried to write these processes alongside our usual work they would have been written probably in isolation with little input from others in the team. It would have also taken weeks to get them done and embedding these processes into practice would have been more challenging. The processes are now more efficient and all have a similar structure. By taking just one day out of the office (less than 7 and half hours) we have progressed a very important piece of work, and we have only delayed our wider workload by a day. No different to having an extra bank holiday thrown into our working week!

I would highly recommend finding out more about Agile Project Management and thinking about how this could be embedded in your work place. These project management methodologies are primarily used for software development but I definitely think they can be used in most business settings. It is also worth noting that if it doesn’t work then you haven’t lost much time to try things a different way, you may have lost a day or a week but you haven’t lost months trying something that literally doesn’t work. Fail fast and learn quick!!

My favourite things about Agile Project Management:

Kanban charts – I love using a Kanban chart to manage a scrum. All you need is post it notes and a board to stick them to. There is something so nice about picking up your action on a post it note and moving it through “to do”, “in progress”, “testing” and “done”! Take photos each day to see how the board changes during the sprint, and how all the “to dos” end up (hopefully) in the “done” column!

Time-boxing – this is such an obvious thing but we all lose time doing certain tasks and trying to perfect elements of your work and end up working late. Be strict on the time and then you will get through the actions that you had planned.

Clear Product Backlogs and Sprint Backlogs – It is so important to have a clear project scope. Don’t over promise, agree what can be achieved during the time you have with the product owner, scrum master and development team. And allow time for problem solving! This will all help to reduce the chance of scope creep and ensure you complete everything you had agreed to complete.

Focussed time – this is one of the best things. How nice to be able to concentrate on one specific job at a time without interruptions. Guaranteed to give you a better output!

Collaboration – working in this way means real team working and collaboration! It gives you opportunity to share ideas, problem solve together and learn together.

Scrum Master – having a Scrum Master coming in and keeping you on track is just brilliant. They also take away any impediments so the development team can concentrate on the things they can get through without been pulled off the project to liaise with people outside of the project and solve problems that are probably too big for the time allowed.

Engagement and Product Owners – having engagement from key stakeholders during the sprints means that they are involved all the way through the process, they can give feedback along the way, and there are no surprises at the end so they end up with something that they have helped to shape.

Iterative development – much better than getting to the end of a build and finding out that it isn’t quite what the customer wanted. Keep sharing and tweaking until it does the job it’s intended to do. Think of it like having a renovation to your house, you would constantly be checking in with the builder to see what they are doing and changing your mind along the way!

Top tips for making this a success:

Go on a course – classroom courses for Agile are much better than online. You need to feel how this works not read about it. Make sure the course includes a practical exercise to test out the theory.

Sort out the space you are planning on working in – make sure it has the right equipment, lots of whiteboards and a door you can shut. Remove all interruptions (divert those phones and put your out of office on your emails)!

Get a good Scrum Master – make sure you have someone who is able to make decisions, lead a team, and take away impediments and get them sorted.

Make sure to have a development team with good mix of skills and knowledge – they need enough knowledge and the right skills to progress the task, and are able to organise themselves to get through the work.

Time-box like a ninja – be strict! If you say you will finish at 4 then finish at 4. Rest time is as important as focused time! If you say you will give a task 20 minutes then stick to it (you will learn by trying, so this may come with experience). Check out the Pomodoro Technique!

Make sure your product owner and other key stakeholders are available during the identified sprint time – This is critical to make sure the end product delivers the agreed objective and you are not guessing what you think they might want. The time allowed is strict so engagement needs to be the same.

Hope you enjoyed reading my blog.

If you want to chat more about Agile and time management then drop me a line!

Have you heard the one about a pie chart?

Posted on by
Reply

It’s been almost four years since I attended my first Tableau conference in London and just over 4 years since I discovered Tableau.  I remember sitting in a few of the customer speaker sessions at the conference and I clearly remember one of the speakers joking about using Pie Charts. I smiled thinking I didn’t want to seem like I didn’t get the joke as everyone laughed along!  Then it happened again, another speaker and another pie chart joke!! Fast forward to today and now I’m the one doing presentations for various reasons and I can never resist sneaking in a really bad pie chart to highlight the need for good data visualisation.

So what is the deal with pie charts then? Why are they the ‘in joke’ of the data viz world?! If they are so bad why do they even exist and why is it one of the first types of charts you learn at school?

Most data visualisation books will talk about the use of pie charts and the reason why they get such a bad rep in the data viz world is because the human brain struggles to compare angles. Data visualisation is about making data more accessible and enabling understanding. If pie charts aren’t easy to interpret then they are simply not a good choice of data visualisation.

One of the dangers of pie charts is the use of colour, if you have more than a few slices in your pie then suddenly you have a multitude of colours that might not work together. I have seen so many where there are also similar colours being used and you don’t know which category is which.  I tend to discourage anyone from using pie charts at all especially if they are new to the data visualisation as it is easy to get it wrong. I usually tell people if it’s got more than 3 slices then don’t use pie charts, and if they are still keen to use them to maybe consider using a donut chart instead. The angles in a donut chart are easier to read and you can utilise the space in the centre for extra info, it’s still best to avoid too many slices though.

When I am training new analysts how to use Tableau or running a workshop on data literacy I do tend to talk a lot about pie charts, and I have loads of examples of really really bad pie charts. I personally think it helps to get people to understand what data visualisation is all about.  Rather than just joking about pie charts, I show them why they don’t always work and what other charts work much better.

I haven’t included a pie chart in any dashboard I have built since attending my first Tableau conference. I really struggle with choosing colours that work for my dashboards so I think it’s just better to stick with minimal colour selection and no pie charts!!

So let’s have a quick demo so I can briefly show you what I mean…

Let’s take some little league data using a pie chart to break down the number of runs by 5 different teams:

It is hard to see from the pie chart how much difference there is between the different home team’s runs, the slices all seem fairly similar. You can just about make out which team had the most runs, but you would struggle to see second place.

Now let’s use the same data but presented in a simple bar chart and one colour:

As you can see presenting this same data in a bar chart you can now quickly see that Bears are quite a bit ahead of the other teams, this wasn’t so obvious in the pie chart. If I then sort the bar chart into size order you now easily see which team is in second and third place. That isn’t possible with the pie chart, even if the pie chart had labels on it, it would still take some time to interpret.

I could give you loads of examples to labour my point, and show you alternative charts that work better than pie charts, but I will leave it there! There are lots of great data visualisation books and websites that will explain all this much better than I can. Go check them out!

Thanks for reading my latest blog.

Ella

Reflections of a Tableau User Group Leader

Posted on by
4

Why I love being a TUG leader!

I set myself some objectives for 2019 to give me a big nudge to keep developing myself. I even popped them up on my white board in my office at work to remind me of them and see if others would also make sure I had achieved them. It’s April already and I can honestly say that I am struggling to get going with most of them. Like everyone, life gets in the way, but one of them was about starting to blog so here goes!

Last week I helped to run the fourth UK Northwest Tableau User group (#NWTUG), afterwards I was absolutely buzzing after having such a good day and already thinking about the next one. With this in mind I came away thinking I need to blog about why I enjoy leading a user group so much. I am hoping this would inspire others to get involved in similar forums or even create them. So my first official blog will be about this…and I need to do it now before more time passes and I forget how that day felt!!

It had never really entered my head to create a user group, but when I was approached by Rory Heath from Tableau and Vicky Lockett from Interworks Europe about creating a Tableau user group in the Northwest I thought why not. This was almost two years ago and in December 2017 I ran the first Northwest Tableau user group.

I spent loads of time preparing for the first event; who might present, working out how long it would last, how I would get people to attend etc. I reached out to people I knew from the Tableau world to come along and present, and got loads of help and support from my first official Tableau buddy Simon Beaumont (and now Tableau Zen Master!). Simon had just starting running the UK healthcare user group so his experience with this kind of thing was invaluable.

I have to be honest on the morning of the first user group I was a bag of nerves, despite over 100 people registering to attend I was worried that no one would turn up. I think on the day we had over 90 people attend, all looking on me to make sure the day was a success and that they went away with their objectives met. So standing in front of 90+ tableau and data enthusiasts I had to get over my nerves and crack on. The day was a success with loads of great speakers, all the attendees seemed to be enjoying themselves and loads of people approached me afterwards about getting involved in future ones.

Leading on this kind of event on my own wasn’t easy and I quickly realised that I wasn’t going to be able to keep setting these up alone. Luckily Lorna Eden (a graduate of London’s data school) got in touch with me just before the first user group to say she had just moved back up north and was keen to get involved in the leading the Northwest group with me. Unfortunately she wasn’t around for the first event but I did pick her brains before the day to get ideas about what she thought should be included. Lorna was actually in Australia at the time, but whilst running a live poll using SLIDO to get to know the attendees she joined in from Oz!! I also got chatting to one of the presenters on the day (Colin Wojtowycz aka Datawoj), about whether he wanted to help run future user groups, we seemed to get on well so thought he would be great to get involved alongside me and Lorna.

Since the inaugural user group 18 months ago the three of us have now run three successful (we believe!) user groups, couple of evening events and then a full day event at Manchester Metropolitan University last week. It is so much more fun being part of a little team with Lorna and Colin, and I have really enjoyed getting to know them both. The three of us have very different ‘data jobs’ and I think this helps us to understand what different people may want from these types of gatherings. We have got together a few times between the users groups to talk about future user groups and also more recently we attended an event in Manchester where myself and Lorna presented about Tableau whilst others talked about PowerBI and QLIK. It was nice to attend this without having to do the organising, and despite hearing how good the other products are, Tableau is still the best in our eyes…!

I also help to run the UK Healthcare User Group too now! When Simon Beaumont asked if I would help him run the UK Healthcare TUG too, I couldn’t resist. I had attended a few of the users groups and always really enjoyed going to them. The fact that it also in healthcare I felt that this would be great to help meet other fellow healthcare analysts and leaders, and share ideas that would specifically support my work as NHS leader.

Ok so I have talked about my user group journey but why do I like doing these so much?!

It may be hard to believe if you have seen me present or if you have worked with me, but I can be shy and my shyness in my youth was crippling. I have always however tried to push myself out of this innate shyness and challenge myself. When I was 18 I travelled alone to Australia for my gap year and then had to force myself talk to people I didn’t know, but if I am being really honest with myself and think back (way back!) about that time I generally waited for people to make the first move and start chatting to me first.  I have always recognised how beneficial networking for work is but again struggled in large groups to talk to new people and always struggled to find forums to reach out to.

Over the last couple of years I have done a lot of presentations external to work which has really helped to grow my confidence in public speaking. My discovery and experience through using and implementing Tableau have given me something I am now really passionate to speak about to whoever will listen. The more you present the easier it is, but don’t get me wrong I still get nervous. One of the great things about user groups is the opportunity to network with new and different people, sharing ideas and experiences is a great way to develop yourself and your work. I watched the attendees on Monday to see how many people reached out to speak to new people, but noted that generally people end up talking to people they know. This is exactly what my preference is too and we are after all ‘data’ people, and being one of the organisers means that more people approach me to talk. I however tried my best to talk to new people because I know like myself that not everyone is comfortable to do so. On reflection, I will definitely talk to Lorna and Colin about how we can get people talking to each other more. We have done similar things at work so I do have ideas, but I won’t share them just yet. Don’t want to scare future attendees off ha ha.

As I have said presenting about things I am passionate about gives me the confidence to talk, and presenting in these safe environments is a great way to get that experience.

We had about 70 people attending our Northwest group last week, with a few other Tableau user groups leaders also attending from other parts of the country (London/Yorkshire/Midlands) which was great. Another opportunity to share ideas for future events with fellow leaders! We actually had nearly 100 people registered for the event, I was impressed with the turnout despite the attendance rate but actually felt sorry for those who didn’t end up attending as they totally missed out on so much learning and networking opportunities. Hopefully we will see them at the next event!

As I said I came away from Monday loving the user group, the attendees seemed to get loads out of the day. We followed the day with a trip to a local pub and a lot more people joined us than I would have imagined, which again I think is a good sign of a successful day more than the lure of free drinks?! Well maybe…

One of my favourite things about running a user group is bringing people together. It is also great to create a fun environment for these kinds of events, I love a game! Work doesn’t always have to be dull, you can’t underestimate how much better people work if you motivate them in the right way. Happy workers and all that! We had loads of the attendees last week come over and say how much they enjoyed the day, if this isn’t reason enough to set up the next one then what is?!

My 5 top reasons for attending a user group:

  • Ideas gathering to take back and explore
  • Learning new tricks
  • Meeting new people
  • Break away from your usual day to enable reflection…
  • They’re fun!

My 5 top reasons for leading a user group:

  • All of the above plus…
  • Working with new people
  • Helping others by sharing experiences and ideas
  • Bringing people together
  • Ability to motivate people to learn

I am sure there are rules over the length of blogs…but it is my first after all, so I will learn and improve I am sure. I have really enjoyed writing this, it is really good to look back and reflect!

Hope you have enjoyed reading my first blog. Feedback welcome!