Thursday, 13 June 2013

Create a default Tableau Template - now with added 8.1 goodness

One of the things missing from Tableau are workbook themes or stylesheets. Although themes are listed there are only two and you cannot customise and save them to you liking. At #tcceu13 i asked Jock Mackinlay about this and he said he has a team of people looking into it.

Do you spend a long time getting a dashboard looking just right, maybe you have a company colour scheme that you have to adhere to.

Each time you have to create a new colour palate.

Tired of having to format your dashboard again and again each time?

Well good news, heres a way that you can create your template that you can create once and then re-use when ever you need to.
  1. Create a new workbook with one sheet and one dashboard. Name them sheet Default Sheet and Default Dashboard.
  2. If you always use the same datasource then connect to it, but if not just leave that blank.
  3. Change the formatting of your sheet and dashboard to your liking. 
  4. Set the default size of the dashboard , the background colours, the font sizing and colour any default titles you like, background images. Everything that you normally have to do again and again. 
  5. If you want to set up some custom palettes for the colour shelf then follow the instructions here http://wannabedatarockstar.blogspot.co.uk/2013/04/colour-me-right.html
  6. Now save your workbook to something like Tableau_template. If you are going to make several different ones then name them something sensible. 
  7. Here's the really important crucial bit. Find the workbook you have created and right click, select properties and set it to read only. This is the magic bit. 

Next time you have to make a dashboard, simply load up the Template dashboard, connect to your data. Make sure that you make a copy of the sheet and dashboard, don't use the create new button or you will not have the formatting set. By copying the defaults it means you can have multiple sheets and dashboards. Then create the viz and as you build it all of the formatting that you just set-up will be in place. By making the workbook read only you are prompted to save it with a different name, which means you can use the same template again and again. 

Hopefully in the near future this will be part of Tableau, but in the meantime this works really nicely.

Need more info? then tweet me @Matt_Francis

Post Tableau 8.1 Update

One of the things that Tableau lacks, even with shiny new 8.1 is Templates. I wrote a previous post about a method for creating a template sheet and dashboard, saving the workbook as a read only file and then using that as a starting point for all your work.

However this relies on you remembering to open that template workbook in the first place. Now with 8.1 you can copy and past both sheets, but now dashboards between open workbooks.

So now we can use this with out templates in the following way. 

1. Create a workbook with loads of sheets and dashboards, all formated in ways that you like to use eg, light pallete, dark pallete etc,2x2 layout 2x3 layout etc

2. Save this and set it read-only just in case.

3. Now next time you create a viz and when you am ready to create a dashboard from it, you load up the template workbook, select the dashboard layout you want to use, and copy and paste it into the new workbook. The carries all the formatting over so all you have to do it add in the sheets and publish! No mess, no fuss.



Unknown

Author & Editor

Tableau Zen Master, Social Ambassador, Wrangler of Data, Vizzer of Data

36 comments :

  1. Tableau online training| Tableau training| call us+ ...
    www.21cssindia.com/courses/tableau-online-training-226.html
    tableau online training, tableau training, tableau course contents, tableau, tableau enquiry, tableau training institute india, andhra pradesh, visakhapatnam, call ...

    ReplyDelete
  2. Hello Matt, Thanks for sharing your ideas about Tableau 8.1 with us.Trhis version brings capabilities that helps access and analyze data with more power and sophistication than ever before. This release contains a critical security fix to Tableau Desktop, Tableau Server, and Tableau Reader that reduces exposure to man-in-the-middle and denial of service vulnerabilities. To address these vulnerabilities, the OpenSSL library used by the affected Tableau products has been upgraded. For the newbies who are seeking more info they can visit this link-https://intellipaat.com/tableau-training/

    ReplyDelete
  3. Hi Matt,
    Thanks for this post! I was wondering if you have any advice about setting up formatting on worksheets and dashboards if your workbook is not connected to a data connection (as I don't usually use the same data connection across workbooks). So far I've been able to set up my tooltip, set the size of my dashboard, and format my worksheet title. I'd like to be able to do other things, like setting the color palette, formatting numbers, changing the dashboard default to add things as floating rather than tiled, and make all worksheets show-up on the dashboard as "entire view." Do you happen to know if it is possible to do any of these things without being connected to a datasource?

    Thanks!

    ReplyDelete
    Replies
    1. Hi Natalie.
      You should be able to do this yes. I have the same situation where I rarely use the same dataset. What I have done is set up my template dashboard with all the formatting, font size, colours, backgrounds, dashboard sizes etc and saved that as my template file. Then when i do some work i use copy and paste to add the template dashboard to my current workbook. Then when i add the work sheets to the dashboard all my formatting is already there. You can set up this without being connected to a data source, or, connect to a datasource, create the layout you like, then remove the datasource and it should still remembe the formatting. The only thing is that it will not remember formatting for certain data types, like changing default aggregations as those are tied to the datasource not the workbook itself.

      Hope that helps.

      Delete
    2. How do you set up fonts without a datasource? As Natalie mentions, tooltip is the only one that I can find a way to set the font. I'm a newbie to Tableau so maybe I'm missing something obvious...

      Delete
  4. Nice information. I was searching for the same. It helped me alot and saved my time. Thanks alot. , devops training in hyderabad

    ReplyDelete
  5. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon
    tableau desktop server training in Bangalore

    ReplyDelete
  6. When we create a template and set features as read only, and others use it for their dashboards.... everything is fine so far. But when the admin makes a change to the template, how does that information flows to other dashboards users have created? Is this possible?

    ReplyDelete
  7. Matt, This is great info. Now that version 10 is out, is there any better way to create a dashboard template? I've been working on multiple dashboard projects the last few months and really want to standardize a team template with a standard header and multiple empty containers that will allow my team to present a consistent appearance. We have just added a couple new team resources and want to make their lives easier by providing several dashboard templates. Thanks!

    ReplyDelete
  8. ​​A1Trainings Offers Tableau Online Training in india by real-time experts for more details visit:a1trainings.com Phone: +91 7680813158 Email: contact@a1trainings.com​





    ReplyDelete
  9. May be you are in require of our Service to listen any commerce assembly or communal celebration, yes certain you can acquire one of our good-looking Delhi Escort as a girlfriend to those feeling alone parties, She will stroke you with the bodily touches. You will absolutely twist into a star as you have a most beautiful girl with you Delhi Escorts. Visit Us: Delhi Escorts
    Escorts in Delhi
    Independent Delhi Escorts
    Delhi Escorts Service
    Delhi Escorts Agency
    Female Delhi Escorts
    Delhi Escort
    http://www.delhiescorts9.com/

    ReplyDelete

  10. the blog is about Another Step in tableau o nline training it is useful for students and tableau Developers for more updates on tableau follow the link
    tableau online training hyderabad

    For more info on other technologies go with below links

    tableau online training hyderabad

    ServiceNow Online Training

    mulesoft Online Training

    Python Online Training

    ReplyDelete
  11. Hey
    Thanks for article, unfortunately I am not able to follow the steps, and I got confused if we should do these steps on Tableau Desktop or Server, because in neither of them I don't have option to make the view read only

    ReplyDelete
  12. Thanks for your informative article.Its very helpful to my business intelliegence.thanks a lot. Tableau Training in velachery

    ReplyDelete
  13. Roughly different that makes Heaven in Bangalore stand cranium and accepts overhead the struggle is the detail that we have more reviews Independent Escorts Bangalore than any other site, and if you revenue a look through, we take in our high profile clients as well as the positive comments and not negative comments Independent Bangalore Escorts.

    ReplyDelete
  14. I Am all grown to hold your body and plug male ports in mine to feel exchanging love together. So, Please come forward and love me as drag queen wants from his lover to pouring best times in your life as best you would like to remember Mumbai Escorts.

    ReplyDelete
  15. It is amazing and wonderful to visit your siteTableau Online Training

    ReplyDelete
  16. Thank you for sharing beneficial information nice post learn mulesoft online

    ReplyDelete
  17. I appreciate what you folks are as a rule up as well. This kind of astute work and scope! Keep up the brilliant works folks I've added you all to my blog roll.

    Tableau online training in Hyderabad

    ReplyDelete
  18. Its really an Excellent post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog. Thanks for sharing....


    Best Tableau online training in Hyderabad


    Tableau online training in Hyderabad


    Tableau training in Hyderabad

    ReplyDelete
  19. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
    Selenium testing training in chennai
    Selenium Courses in Chennai
    Selenium training Chennai
    Selenium Institutes in Bangalore
    Selenium Testing Institutes in Bangalore
    Selenium Testing Course in Bangalore

    ReplyDelete
  20. Here we provide sexy and genuine Mumbai Escorts who not only ready to give you immense love but also ready to give you reliable facilities and service which will definitely change your mood. if you to more about us. visit herE
    Mumbai Escorts Service

    ReplyDelete
  21. Hey guys, my name is Ankita Varma. I am waiting very eagerly to make your evening colorful. So, just call me at Call Girls for my best Mumbai Escorts Services. Find Mumbai call girls and escorts online today at Ankita Varma! India's # 1 escort website
    Mumbai Escorts Agency

    ReplyDelete
  22. We always remain prepared to supply greater than expected benefits to our customers. The best colors of life are Delhi and thus you have to observe the evenings here this ardent season. Help to create a secure payment only once you meet our escort. 100% confidentiality assurance can be found from our conclusion.
    Delhi escorts
    Pune escorts
    Mumbai escorts
    Jaipur escorts
    Goa escorts service
    Nainital escorts
    Dehradun escorts
    Haldwani escorts
    Haldwani escorts
    Gurgaon escorts

    ReplyDelete
  23. Hi guys! If you are alone and want female companionship, then please follow me on the links given below. I like to have sexual relationship daily with different persons. If you are interested in me
    Mumbai Escorts

    ReplyDelete

  24. Nice blog..! I really loved reading through this article... Thanks for sharing such an amazing post with us and keep blogging...
    Tableau online training
    best Tableau online training
    Tableau online training in Hyderabad
    Tableau online training in india

    ReplyDelete
  25. Hey Nice Blog!! Thanks For Sharing!!!Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging!
    SEO company in coimbatore
    SEO Service in Coimbatore
    web design company in coimbatore

    ReplyDelete
  26. Hello,
    Nice article… very useful
    thanks for sharing the information.
    servicenow project management

    ReplyDelete
  27. Thanks For Create Such Kind Of Informative Website. It Is Really Useful According Your Current Topic. Please Keep This Continue To Help The People Who Are Looking For This Topic. After See Your Niche I Have Recommended Your Website With My Friends Also.
    My name is Neha Gupta. I run my independent Mumbai Escorts Service
    . I am an independent Mumbai escort girl. My service charge is low according the market price. My service is super, because I know very well the personal need of my each customer. I am comfortable to provide my Mumbai Escorts Service at your home or in Hotel. 24X7 I am available. Visit- http://www.nehagupta.biz/ Call- +91 9OO4458359

    Mumbai Escorts
    Mumbai Call Girls
    Escort Service In Mumbai
    Mumbai Escort Girls
    Bandra Escorts
    Juhu Escorts
    Andheri Escorts


    ReplyDelete
  28. I Saw Your Website Carefully. Thanks For Create Such Kind Of Informative Website. Your All Content Is Relevant To Your Subject. I Say Keep It Continue, Because Your Website And Subject Is Meaningful For The Users. I Have Recommended Your Website With My Friends Also. I Am Ritu Sharma. I Am An Independent Mumbai Escort Girl. I Deal In Mumbai Escorts service. I Am Very Hot And Sexy. Being A Mumbai Escort Girl I Have Five Years’ Experience. That’s Why I Understand The Each Personal Needs Of My Every Client. My Service Charge Is Low And Service Is Super. You Can Avail My VIP Mumbai Escorts Service At Your Home Or In Hotel. I Am Comfortable To Provide Mumbai Escorts Service In Local And Outside Also. Visit www.escortservicemumbai.net Call +91- 9OO4OO9481
    Visit The Links Below And Have A Look At My Various Mumbai Escort Services-
    Mumbai Escorts
    Mumbai Call Girls
    Mumbai Escorts In Vile
    Parle

    Bandra Escorts
    Juhu Escorts
    Andheri Escorts

    Mumbai Escorts In Colaba



    ReplyDelete
  29. Thanks For Create Such Kind Of Informative Website. All Content Is Relevant To Your Subject. Keep It Continue, Because Your Website And Subject Is Meaningful For The Users. After See Your Niche I Have Recommended Your Website With My Friends Also.
    My Name Is Priya Singh. I Run My Own Mumbai Escorts Service. I Am An Independent Mumbai Escort Girl. I Am Beautiful And Hot. My Service Charge Is Low And Service Is Super. Being Professional I Have Seven Years’ Experience As An Escort Girl. So I Understand And Feel The Real Needs And Requirement Of My Each Client. You Can Taste Me Any Time. According The Convenience You Can Avail My VIP Escort Service At Your Home Or In Hotel Also. To Book My VIP Mumbai Escort Service Call +91 9987215552. Visit http://www.escortagencyinmumbai.com/
    Visit The Links Below And Have A Look At My Various Mumbai Escort Services-
    Mumbai Escorts
    Mumbai Call Girls
    Mumbai Escorts In Vile Parle
    Bandra Escorts
    Juhu Escorts
    Andheri Escorts
    Mumbai Escorts In Colaba

    ReplyDelete
  30. Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
    Thanks & Regards,
    VRIT Professionals,
    No.1 Leading Web Designing Training Institute In Chennai.

    And also those who are looking for
    Web Designing Training Institute in Chennai
    SEO Training Institute in Chennai
    Photoshop Training Institute in Chennai
    PHP & Mysql Training Institute in Chennai
    Android Training Institute in Chennai

    ReplyDelete
  31. Nice article, interesting to read…
    Thanks for sharing the useful information
    java certification course

    ReplyDelete

 
biz.