How to start a performance recording in Tableau Desktop: Quick Tip
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- #tableau Performance recordings can help you identify which parts of your workbook are causing slow performance. In this video, I show you how to start one and how to get the results after starting it.
Tableau notes: j.mp/3gcHVwu
To find out what’s slowing it down, you can use a performance recording to evaluate your workbook. This is an especially good idea if you plan to share or publish the workbook.
The Performance Recording feature in Tableau records performance information about key events as you interact with a workbook. You can then view performance metrics in a workbook that Tableau creates to analyze and troubleshoot different events that are known to affect performance:
Query execution
Compiling query
Geocoding
Connections to data sources
Layout computations
Extract generation
Blending data
Server rendering (Tableau Server only)
Tableau support may ask that you create a performance workbook as they work with you to diagnose performance issues. Share feedback and Suggestions: tableautim.can... -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
Thank you for showing this.. Just a thought, I would like to suggest is before clicking Start Performance Recording, better open a blank worksheet and save the workbook. Once you open the workbook again, now the blank sheet opens first and then you have the flexibility to hit the dashboard in the workbook and start performance recording both in parallel giving more accurate performance information
Great suggestion / detail there. Pinned the comment.
Hello, did you make another video where you take deeper dive into this topic?Thank you!
It was really informative Tim.. It was very simple and very clear to understand.Thank you for the walk through.
Hey, thank you, this was very helpful! Do you have another video about "a deeper dive of performance recording and how to optimize performance for werkbooks"?
I created a 401(k) planning tool, and it is extremely slow. For each parameter change it takes about 15 seconds to update. This is a very interactive viz. I sent it to Tableau and the result after working with them for weeks was that the number of dependencies for each calculation is high. I have not seen any sites/videos showing how it can be sped up. Do you have any ideas?
Very informative
Hey Tim, found your video really interesting.. Just wanna ask you that after starting the performance recording do we need to perform some activity before the stop recording ?
Yes you do. Just head tot he same place and hit stop. I covered this in the video.
That’s great Tim. Just one question: Does it work if I want to measure things like Live connection vs using extracts? Or even better custom query vs data model?
Yes try it.
Hey Tim, how long can we leave the performance reporting on? Do you think it would be possible to track clicks and report them as part of a pay per click campaign where people can pay to advertise a product and need to see how many clicks their product received?
Tableaus logs will be the better place to do this but it’s a big dark rabbit hole. Not sure I’m clear what the use case here is. Are you trying to use the click data to figure out engagement on a tableau report?
@@TableauTim thanks for responding. Use case is that I have a dashboard which links out (via actions) to external vendors selling a relevant product. I want to track the action (click to URL) so that I can report to the vendors how many clicks each product is receiving. The products are in a table which has an icon (shape) representing the external link, and then clicking on the link takes you to the vendor website.
Is there a process you follow to then analyze, figure out and remedy the root causes? That would be a helpful video as performance is always and issue with Tableau. And by only watching what query took the longest is most often not sufficient to debug if you have lots of queries and can only see a complex sql statement generated by VizQL
Thanks
yeah this is the video im doing to get that out of the way. Will do a specific one on performance tuning it actually needs several videos. or one video that's about 2 hours long there just so many variables and many usually arent to do with Tableau the product.
Out of interest have you seen this recent white paper? www.tableau.com/sites/default/files/2021-06/Designing-Efficient-Workbooks_2021.pdf
@@TableauTim Thanks I know an older version of this file. And I have tried quite a lot but from my current experience,
everything fancy in Tableau quickly becomes a pain as soon as it is used with bigger datasources.(even published extracts to Server)
And sth like LODs are generally a performance killer.
looking forward to your video
take care and best regards
Speak slow so that we can understan as like other youtubers please work on it🙄
I've never had that feedback in over 200 videos but I'll take it on board. Was there a particular moment in the video I was speaking too fast ?
Common; if Tim's too fast for you, change the playback to 0.5 or so ...
@@PatrickBateman12420 forgot that feature existed. I tried 0.75 and I cant stand myself that slow ahah but its great to know it's there and the audio sounds fine.
It was the right speed for me 👍