# Make your reports faster : Beginner's guide to Tableau Optimization

DevFeed: [Make your reports faster : Beginner's guide to Tableau Optimization](<https://devfeed.tech/articles/make-your-reports-faster-beginner-s-guide-to-tableau-optimization-20090.md>)

Original publisher: [Read original article](<https://lambda.blinkit.com/make-your-reports-faster-beginners-guide-to-tableau-optimization-b94c4a666466?source=rss----42df4a1e8725---4>)

Author: Akash Vishwakarma

Published: 2023-03-07T15:58:04Z

Content type: tutorial

Language: en

Sources: [Grofers](<https://devfeed.tech/sources/grofers.md>)

Topics: [Optimization](<https://devfeed.tech/topics/optimization.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [data](<https://devfeed.tech/topics/data.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Tool](<https://devfeed.tech/topics/tool.md>)

Tags: [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data](<https://devfeed.tech/tags/data.md>), [data-analysis](<https://devfeed.tech/tags/data-analysis.md>), [data-visualization](<https://devfeed.tech/tags/data-visualization.md>), [guide](<https://devfeed.tech/tags/guide.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [reporting](<https://devfeed.tech/tags/reporting.md>), [tableau](<https://devfeed.tech/tags/tableau.md>)

## AI overview

A beginner-oriented guide to improving Tableau dashboard performance. It covers performance recording, filtered or sampled extracts, data-source connections, live versus extract queries, and context filters. The article reports reductions in render or load time, extract time, and improvements in view throughput at Blinkit.

## Source excerpt

Make your reports faster: A beginner's guide to Tableau Optimisation In today's world, given the pace at which data operates, we need a tool that can help us to generate reports faster and bring out insights within milliseconds. In order to solve this challenge, several companies have started utilising a few Business Intelligence (BI) tools such as Tableau/Power BI/Superset/Looker/Qlikview, etc. We at Blinkit have also moved away from the traditional way of reporting via spreadsheets to a more scalable and robust tool -- Tableau. Earlier, we had no single source of truth for metrics; it took a significant amount of manual effort to compile data in spreadsheets, and we were frequently limited by our local memory. Theoretically, Tableau can handle data up to ∞ rows and columns. However, it slowly begins to slow down as it renders calculations, fields, and formulas. At Blinkit, tracking supply and consumer metrics in real-time is the need of the hour. The faster we track, the faster we decide and move forward. Given below are some hacks that enabled us to achieve a significant improvement in the performance of our dashboards. The effects have been noted across various aspects of our operations, including but not limited to: Reduction in the average render/load time by over 50% in the last six months. Over a three-fold improvement in throughput in traffic to views in the last three months. A 50% reduction in the extract time over the last six months. Check performance recording This is the first step in identifying the problem. The performance recording gives information about key events as you interact with a workbook. Further details can be found here. Fig. 1: Start Performance Recording in TableauFig. 2: Events Sorted by TimeGenerating extract To speed up extract generation, consider importing only some data from the original data source by using filters or importing a limited sample of data. Connecting to data sources Slow connections could be due to network issues o