How To Train Your Tableau Users

Hello there,

More tips coming to help you build that dream Tableau Server setup in your global Enterprise…. This time we focus on training.

Training is a critical subject. It won’t take long before someone asks you about your strategy or what you offer so you’ll need to ensure you have a professional sounding answer. Here’s what I offer my users. Hopefully some of this will be useful.

Screen Shot 2016-01-06 at 16.46.07

Training gets pride of place on our community site

General Considerations

Before I get into the specific offerings there are a few things you need to consider.

 

Branding is Critical!

So before I describe what we offer, you’ll notice that we have snappy names for each of these offerings. It’s not just “Tableau Training”. Much of Tableau’s success is down to stellar marketing and branding – take “Tableau Dr.” for example.

So make sure you think about what you are offering, how it will be perceived and how you can maximise adoption. A memorable and consistent name is key here. Each offering also has a nice-looking one pager in our Sharepoint slide library and an appropriate user-facing page / description on our community site so that we can give people all the info at a moments notice. The more effort you put into branding the better things will be.

You’ll also find that any of these offerings are easily transferable to teams / services that may be related to your area so there are a ton of collaboration opportunities here.

 

Consider the Timezones

If you’re like me then you’ll have users all over the globe. That means timezone aggro. You’ll generally need to double up most of your offerings. We are based in London so we have an early session for Asia/Pacific and an afternoon session for Europe/Africa/USA. Users will really appreciate this extra effort.

 

Don’t Worry About Attendance

It’s important not to get fixated on how many people are attending your sessions. Sometimes we get 3 people, sometimes we get dozens. Don’t worry about it. Training 3 people is better than none. And often the smaller sessions have better engagement.

 

Manage the Schedule, Don’t Let it Manage You!

You’re gonna get a LOT of requests for training. Make sure you control the schedule. Don’t be scared to tell users when the next scheduled session is and that they can join it. Don’t be scheduling things on demand of users or you’ll lose control completely. If training is regular and consistent then users will settle into a pattern and you’ll be able to manage your team’s time much more efficiently.

 

Track your Results

Training gets a lot of focus with senior management. You (or your manager) will get asked plenty about how many people you’re training and from what business area / region they are.

As we are all data people it’s much better to SHOW the execs the data rather than tell them you’re just “doing loads of training”. We have several Tableau vizzes that track the attendance at each of our training offerings. We then blend that with staff / hierarchy data to allow detailed reporting on all of the modules. That makes a much better impression.

For example just checking our viz now I can see that my team has done 545 Tableau Dr. Sessions this year, covering 277 different individuals. That’s almost 550 man hours of training on Dr. Sessions alone. Right there, evidenced and visualised. That makes a much bigger impression with the folks at the top.

unnamed

Tracking our training…

Don’t Get Lazy!

All this training can be a real time-burner. I’m sure some of you are thinking why don’t you just record the sessions and chuck the video online. And we get asked that. But never under-estimate the value of Instructor-Led sessions over videos. Our sessions are interactive, dynamic, enjoyable and make the users feel valued. They can be funny, and go in different directions according to the particular vibe in play. So don’t cave in to laziness, make sure the sessions happen and that they have that human touch.

So those are the general things to be aware of. I’ll now describe the specific options we have for training at my organisation.

 

Specific Training Offerings

Tableau Self-Learning Pipeline

I love self learning. Getting stuck into a manual, book or video. Or just firing up Tableau and seeing where it takes me. And you’ll get a lot of users that are the same. It’s always great to allow the self-learners to flourish, and it has the added benefit of not using your team resources.

You’ll get asked these questions hundreds of times, so make sure that you have all the relevant materials easily accessible on your community page.

  • What is Tableau?
  • How do I get Tableau?
  • How much does Tableau cost?
  • How can I get started with Tableau?

Our 101 page is top of the Community site in a super easy-to-find location. We refer our users to

This is generally more than enough for your average self-learner to get stuck into.

 

Create a Training Hierarchy

Users operate at different levels of ability and interest. So it is important that your training caters for that. It also looks great if you can demonstrate an end to end understanding of training. In addition to the self-learning pipeline, we offer the following.

 

Tableau Desktop Training Syllabus

This is my main training programme for Tableau Desktop users. It consists of 7 modules, each conducted once a month, with a session in the morning to hit APAC users and one in the afternoon to cover EMEA/USA users.

  • Module 1 – Introduction to Tableau
  • Module 2 – Data Visualisation
  • Module 3 – Table Calculations
  • Module 4 – Blending & Joining
  • Module 5 – Creating Effective Dashboards
  • Module 6 – Performance & Troubleshooting
  • Module 7 – Using Tableau at THIS ORGANISATION
Screen Shot 2016-01-06 at 16.41.58

Our training syllabus

Content is self-explanatory from the headings, but module 7 may seem odd. This is actually a pretty important consideration in large organisations where no two Tableau deployments will be the same. There will be organisation-specific nuances or considerations in many aspects of using Tableau and our place is no different. Much of this focuses on purchasing / onboarding, getting started, and change / incident management procedures, often a source of confusion for users.

Tableau Dr. Sessions

images

The Doc is in!

Ok so you all know these. The famous one-on-one consultancy time that Tableau offer at conferences. That’s all this really is, but we find that our users love the dedicated time to discuss whatever Tableau related topics they want. Many often come back for repeated sessions and some are almost data hypochondriacs!

The Dr. Sessions have been a real success. People at high-pressure organisations like Investment Banks, especially senior folk, really understand and appreciate the importance of that dedicated, individual, focused consultancy time. Time is the most precious commodity in such an organisation and you’ll find that you get some serious kudos for these.

When you’re at conference and see people gagging for Tableau Dr. Sessions, imagine what that would be like at your own organisation. Super-cool aint it?

 

Tableau In Focus

This offering is really cool. These are monthly Webinar sessions, again one for APAC timezone and one for EMEA/USA timezone. They are conducted by experts from Tableau, tailored to UBS requirements.

Subjects have included

  • Five Ways to Improve Dashboard Performance
  • Data Blending & Joining
  • Table Calculations
  • Deep Dive into LOD Expressions
  • Advanced Mapping
Screen Shot 2016-01-06 at 16.43.15

Tableau In Focus

Again, the fact Tableau are prepared to conduct these for us not only gives us valuable extra learning offerings but makes my users feel even more special than I know they are! We get great feedback, with users thrilled that we have such a good relationship with Tableau. That all gives them confidence in our service, and that is critical.

 

Tableau Executive Track

OK so this is an interesting one. We get a lot of senior folk asking for Tableau training. That’s very encouraging, obviously, but your average MD isn’t gonna sit through an hour Webex on LOD calcs.

So – what we do is our “Tableau Executive Track”. That’s a 1hr session, ideally in person with my laptop where we plan to cover the following.

  • Overview of the Tableau Service
  • Introduction to the Tableau Server
  • Showcase of current use across the business
  • Demo of custom admin views & introspection
  • How to build basic views in Desktop

In reality we often don’t get 30 seconds into this agenda before it is taken somewhere else, at the subject’s discretion. That’s cool – it’s what senior folk do and you need to be prepared for it. But it’s also important to come armed with an agenda to show you have a plan. Don’t just rock up and say “whadda you wanna know?” – you’ll get eaten alive.

Screen Shot 2016-01-06 at 16.43.24

Tableau Sr. Management Training

This is a really popular training offering, with many seniors having attended or planning to attend. It shows we are putting a great deal of thought into our training and that we are flexible enough to adapt to the variety of users we have.

 

Content Specific Training

Sometimes we get asked, “I’ve been sent this dashboard but I have no idea how to use it”. Well that’s NOT something we assist with. Our service is totally self-serve and it’s the responsibility of the dashboard author to

  • Ensure they have followed best practice
  • Include clear instructions for dashboard use or a link to a page that has such information
  • Ensure that their audience is briefed and aware of the dashboard usage

This is NOT down to us. We spend a lot of time policing content to make sure that authors are mindful of this as a dashboard that is hard to understand can adversely affect perception of the tool / service as a whole.

 

Wrap Up

So that’s what we offer. Aint it a lot? And boy is it important to the success of your service. Training can make or break a service and between you, me and the whole Internet – a lack of training can be used as an excuse for not engaging, or not performing. It’s rare but it happens.

Training your users should be enjoyable. If you find that it is becoming a pain then take a step back, consult some of your power users and modify your offerings.

In the time I was proof-reading this post the excellent Carl Allchin, who implemented much of our training when on site with us, posted some of his own thoughts on the Information Lab blog. Check them out. Also a big thanks to Andy Pick who has delivered dozens of sessions for our users.

As always I’m happy to jump on a call and discuss any of this. Now if you’ll excuse me I have a training session to deliver…

Cheers, Paul

Advertisements

How to PROPERLY Back Up Your Tableau Server

Hello there,

Whadda ya mean you didn't take a backup?

Whadda ya mean you didn’t take a backup?

Time for another post about Tableau Server and how to get the best out of it in a large-scale, enterprise deployment situation.

Today we are focusing on how to PROPERLY back up your Tableau Server installation.

Like many aspects of enterprise services, this is a simple concept, but one that if you get wrong, can spell disaster. It always amazes me how many people / organisations don’t do this properly or even at all.

You know how annoyed you get when your mum tells you she isn’t backing up all her family photos – well that’s what I get like when I see IT systems neglecting backups.

Note this post refers to a standalone Tableau installation with a manual failover to DR. We don’t yet have a clustered environment. I’ll update the post with considerations when we implement that.

 

What’s a backup?

Seems a simple question, and there are a number of different types of backups that you can take, each useful in different situations. Here’s what I’ve got in place:

 

 

Full System Backup

This is a complete dump of the server filesystems to disk (or tape – there’s still plenty of tape backup infra out there). Most likely it will be one of the big vendor products that look like the mothership from Close Encounters of the Third Kind.

Your full system backup should be set up by your server team when you get your machine. However, the principle of “trust no-one” applies here as always and it’s up to you to check the following:

  • Have the backups been set up at all?
  • Are they backing up all the filesystems? – Many times I’ve seen that only operating system partition backups have been set up, and I’ve had to request the application partitions be included.
  • Have the backups been succeeding? – Get your backup team to send you a report every month of backup completion. They don’t always succeed and you probably won’t be told that there has been a failure.
  • If you need to perform a restore, do you know the process and how long does it take?

If you get the okay on that then you’re good. But only as an insurance policy. Full system backups can take a long time to restore, and may only be weekly so you could end up losing data even if these are in place. It’s up to you to ensure you’re covered rather than rely on other teams doing things correctly.

 

 

Nightly Tableau Backup

There’s no excuse for not having this in place. It’s easy to set up and it is a case of when rather than if it saves your ass.

The tabadmin backup command gets Tableau Server to dump all content & configuration to a single .tsbak file. You don’t have to stop the server to do this and it doesn’t seem to impact performance too much while it is running so this should be the first backup you configure.

A simple script like this will do the job.

@echo OFF
set Binpath="D:\Program Files\Tableau\Tableau Server\9.0\bin"
set Backuppath="D:\Program Files\Tableau\Backups\nightly"
echo %date% %time%: *** Housekeeping started ***

tabadmin backup %Backuppath%\ts_backup_ -d
timeout 5

tabadmin cleanup

move "D:\Program Files\Tableau\Backups\nightly\*" \\\tableau_shr\backups\nightly\
echo %date% %time%: *** Housekeeping completed ***

The tabadmin backup command does the actual work here, dumping everything to a file. Always a good idea to run tabadmin cleanup afterwards to remove logs etc.

We run this script at a quiet time for the server (not that there is one in my global environment). We use the Windows Scheduler on the server but I’d recommend using a decent scheduler like Autosys or whatever your enterprise standard is as WTS is pretty poor.

IMPORTANT: You may have noticed the move command at the end there. That takes our newly created backup file and moves it OFF THE SERVER to a share drive accessible by my backup server. Why? Well what happens if you lose the server and your backup file is on it? You may as well have no backup. So move it somewhere else.

Update – this tip actually saved my ass this week when we lost our entire VM cluster (er.. hardware team – *cough* – what’s going on??) . We were able to failover to the backup server successfully. Going forward we will be soon implementing Tableau’s High Availability capability.

Do make sure you rotate your backup files with a script that deletes the old files or your share drive will fill up. I keep 4 days worth, just in case the current file is somehow corrupted – rare but can happen.

 

 

Weekly Restart

You may know I’m not a fan of running enterprise apps on Windows. I prefer Linux for a number of reasons that I’m not going to go into here. I know many users want Tableau Server on Linux, and the amazing Tamas Foldi has only gone and written it himself – so one day we may see it.

Anyway, with Windows apps I always build in a weekly application restart. In our case every Saturday morning. That involves a server reboot (to clean out any OS related temp stuff), application restart and a tabadmin cleanup. The tabadmin cleanup with the server stopped has the added bonus of clearing out the temp files (doesn’t happen when the server is running). These files can get pretty big so worth clearing out.

 

 

Virtual Machine Snapshots

If you’re running on a VM then you may be able to utilise the VM snapshot facility. Contact your VM admins for details. I’ve not needed to implement this but I know some that do. VM snapshots are super handy.

Do be aware that Tableau don’t seem to support this though..

Screen Shot 2015-11-11 at 19.11.48

 

 

Config File Backup

Sometimes it’s handy to just back up your Tableau Server config. I’ve got a script that grabs all the .yml and template files in my Server directory, zips them up and moves them off the server. Pretty useful to refer back to old config settings if you need to. Make sure you include workgroup.yml.

If you’re being really good then you’ll be checking your config files into a revision control repo like SVN.

 

Site Specific Backups

Tableau Server allows you to backup per site. This doesn’t give me much extra but I know in orgs that have lots of sites, or a site per team / business unit it can be very handy.

One thing that isn’t great about exporting a site is that the site is locked and inaccessible as the export is taking place. See Toby Erkson’s blog for more info on exporting a site.

 

 

Backup File Size & Duration

As your environment grows you’ll need to be mindful of the size of your backup file. Mine is around 16GB and takes well over an hour to write. Takes about 25 mins to restore. You’ll need to understand those numbers as your system matures.

unnamed

Backup files can get pretty big

Another variable that can affect backup time is the specification of your primary server. If your primary is low spec then you’re gonna get a longer time to write a backup. I don’t have any stats on that but I know it is true. Contact Jeff Mills of Tableau if you want more info on Weak Primaries & backup times.

 

 

Backup Your Logs

Less important this, but handy to do on a weekly basis is to zip up your logs. We have a much better solution for logfile management using Splunk – you’ll see a blog about that in the future.

 

 

The Most Important Bit – TEST YOUR BACKUPS

OK so you’re backing up like a man / woman possessed? Fine. You’re only as good as your last restore. So TEST your backups periodically. Files get corrupted and you don’t want to be discovering that your only backup is broken when you need it.

OK that’s it. Backups can save your life – don’t ignore them. Paranoia is king in IT!

Cheers, Paul