Creating an Enterprise Template for Tableau Dashboards

Data

Creating an Enterprise Template for Tableau Dashboards

by Kathryn Bridges

At many organizations, Tableau opens the door for creativity that didn’t exist before. Often, it’s awesome because folks get to see and understand their data. However, sometimes, our marketing and communications department would probably prefer some major dashboard components stick to brand (I’m looking at you, five-years-ago self, and your rainbow dashboard).

So, organized people that we are, when it comes to creating a dashboard, we set up a meeting with our communications team and get their sign-off on the color schemes and use of the company logo. We drop them on a dashboard, and we’d like to get everyone in the company to use this set-up.

Previously, I’ve seen companies share this new “template” on a platform like Box or a shared drive, and then when folks go through Tableau training, they’re given access to this secret folder and can download it.

Building a Dashboard from the Ground up

Now, while this in theory is a good idea, let me give you scenarios that I’m all too familiar with from personal experience:

  • I open the template workbook, build what I want, publish and press Save As. Now my template is no longer a template. If I want to use it again, I then need to go back to my Shared Folder and re-download.
  • Err … where did that file exist? Let me call someone and see if they can find it.

I cycled between these two options for the first dozen dashboards I built. Then one day, when I was feeling especially impatient:

  • Eh, I’m just going to mock something up really quickly. I don’t want to go look for that template wherever it is. I’ll just start blank.

And so, good intentions quickly tumble into inconvenience and bad habits. So, how can we make this easier? Well, when you open Tableau, notice that there are Sample Workbooks on the homepage:

sample workbook templates in Tableau

What if I could make my template a sample workbook, so it would just always be available to everyone? Well … you can!

How to Create Your Dashboard Template

While anyone with Admin access to their computer can do this, if you want this to be default when anyone in your organization downloads Tableau and not have individuals manage it, you’ll need to work with your IT team to ensure the Program Files discussed in this post are customized for your template.

Now, let’s get going. First, where do these sample workbooks live? On your computer, find Program Files and navigate to Tableau > your version help > Workbooks > your language:

creating a template for Tableau

Now, the sample workbooks have several components to them, but the two you’ll definitely want are the workbook template saved as a .twbx and a .png image of that workbook, so your users can see what it looks like on the home page. Paste both of these items in the folder. This is the first place you’ll want to make sure you have admin access—when you go to paste, you’ll likely get an error similar to this:

creating a template for Tableau

Go ahead and click Continue and either use Admin credentials or contact your help desk. Make sure to keep them on the phone because you’re going to need the help desk again in just a minute.

Editing the Manifest File

All right, so we’ve added “Template. twbx” and “templatescreenshot.png” to our en_US Workbooks folder, but now we also need to edit the manifest file so Tableau knows to pull them in. If you’re asking, “What’s a manifest file?!”, check out Debbie Yu’s blog post where she answers that.

In the folder, you’ll see a file called samples.manifest. Right-click on that, and choose to open in a text-editing program; I’m using Notepad++:

text-editing when creating Tableau dashboard template

When you open it, you’ll notice it’s Read-Only. If you right-click on the title, you’ll see the option to Clear Read-Only Flag (again, this is where you’ll likely get prompted to enter Admin credentials and reasonably so because these manifest files are important to programs running):

text-editing when creating Tableau dashboard template

So, with the flag cleared, you’ll want to add a fourth line to this manifest file, with the name of your .twbx template and thumbnail .png image:

adding your details to a manifest file

<sample file=’Template.twbx’ thumbnail=’templatescreenshot.png’ caption=’My Template’ tooltip=’Template’ sheet-thumbnail-format=’worldindicators-%1@2x.png’ sheet-thumbnail-count=’8’/>

You can change the thumbnail format and count if you’d like as well, but for now, I’m keeping them the same as the World Indicators. Go ahead and save this. Be careful because if you Save As, it will try to save it as an .XML file, and you’ll want to make sure you’re saving to overwrite the current samples.manifest file. You may get one more error telling you the file can’t save. If so, reopen the program in Administrator mode and it will let you save:

administrator mode when creating a dashboard template

Whew! Now for our reward:

custom enterprise template in Tableau

No more chasing down that pesky template in shared drives. It’s there by default for me all the time. Comms team celebration!

Across the organization, if your IT time can change this manifest file and add in this .twbx and .png to their standard Program Files in the installation package, everyone in your organization with Tableau will automatically have your template!

More About the Author

Kathryn Bridges

Analytics Consultant
Matillion 101: Completing My First Job in Matillion If you’ve been following along in this Matillion series, you’ve already set up and logged into Matillion. From here, I’m going to talk ...
Time Travel with Snowflake A couple years ago, as I was trying to teach myself programming, I managed to wipe out my computer. It was a silly mistake—all I was ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072