UrbanPro
true

Learn Tableau from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Data Analytics with Tableau Best Practices

Aravind Navaneetha Krishnan
15/07/2023 0 0

Best Practises

  1. Keep analysis simple. Work with a subset of your data. Extract a sample if needed.
  2. Bring in only the data needed for analysis. Consider adding a data source filter or using an extract. If using a join, minimize the number of joined tables.
  3. Use ‘Describe’ to explore dimensions in new data sets without having to load them into visualization.
  4. Remove unused columns (measures/dimensions) in order to minimize extract refresh time or custom SQL query time.
  5. Create a published TDS file for your business team to use rather than each analyst creating their own data source. This includes all metadata associated with dimensions, measures, calculated fields, hierarchies, sets, parameters and naming conventions.
  6. Use extracts wherever possible to accelerate performance. Hide unused and confidential fields. Roll up data granularity by pre-aggregating or filtering. Break hierarchies to only visible dimensions.
  7. Minimize the number of quick filters. Use dashboard filter actions where possible.
  8. Avoid selecting ‘Only relevant values’ for your quick filters. This requires sequential queries. Do not use this when not needed.
  9. Replace quick filters showing ‘Only Relevant Values’ and high count of quick filters with dashboard filter actions. They will cascade as your user interacts, and they perform faster.
  10. Avoid multi-select or drop-down lists in Quick filters which are slow to load and render.
  11. Avoid quick filters or actions that drive context filters. These require reloading the context table and should be avoided wherever possible.
  12. Keep range quick filters simple. The more complex the range, the slower the query.
  13. Limit custom SQL in live connections as they can be inefficient. Where possible, create a view on the database server to implement your custom SQL and connect Tableau to your view.
  14. Avoid parameters in custom SQL in Tableau. Tableau wraps the custom SQL in a sub query that many databases don’t handle well. Consider building a view in the database or use a multi-table join with filters
  15. Watch for useless clauses, e.g. ORDER BY. Tableau is going to re-sort the data once loaded anyway.
  16. Use calculated fields carefully. Think about the data type as you code the calculation. Number and Boolean > date > string calculations when it comes to performance.
  17. Limit blended calculations. They require sequentially querying multiple data sources and can be time-consuming. Where possible, create a view on the database server.
  18. Avoid row-level calculations involving parameters
  19. Avoid high mark counts. More marks = longer rendering time.
  20. Limit the use of detailed text tables with lots of marks.
  21. Minimize the file size of any images or custom shapes where possible. As a general rule of thumb, keep images under 50kb
  22. Even if a workbook is published to Tableau Server, local computations still impact performance. Leverage the power of Tableau Server whenever possible by limiting local computations such as groups, hierarchies, reference lines, table calculations and blending
  23. Table calculations are powerful, but they can be slow. They are dependent on the local computation engine and can require substantial memory
  24. Limit the number of worksheets on a dashboard. If you have more than four visualizations on a dashboard, strongly reconsider
  25. Fix dashboard size relative to end-user consumption. Automatic sizing is less efficient than specifying dashboard size
0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

Data Warehousing - End to End
Data warehouse - An Idea Subject Oriented - A data warehouse is subject oriented because it provides information around a subject rather than the organization's ongoing operations. These subjects can...

Donut Chart
G

Gagan G.

0 0
0

Tableau is a Good tool for Visualisation
Tableau is one of the best BI Tool we use to show the Data in a Visualization Mode. Tableau is a very Powerful & Fastly growing data visualization tool used in the field of Data Analytics. It will...

What Is Tableau ?
About Tableau: Tableau is a business intelligence (BI) tool that can help you concept attractive and visually-appealing reports, charts, graphs and dashboards using the given data. These reports can easily...

Funnel chart in Tableau
G

Gagan G.

0 0
0
X

Looking for Tableau Classes?

The best tutors for Tableau Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Tableau with the Best Tutors

The best Tutors for Tableau Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more