Tableau

TPC-H benchmark of DuckDB and Hyper on native files

TPC-H benchmark of DuckDB and Hyper on native files In this blog post, we examine the performance of two popular SQL engines for querying large files: Tableau Hyper / Proprietary License DuckDB / MIT License These engines have gained popularity due…


DBEngines Dashboard

Database Engines Trends Dashboard

Database Engines Trends DashboardDB-Engines.com is a website that reference and rank hundreds of database engines, threw the most famous ones likes Oracle, MySQL, SQL Server, PostGreSQL, MongoDB, Redis to omes more confidential like Hazelcast…


INSEE FiLoSoFi revenus medians version Tableau

Cartographie FiLoSoFi : données sur les revenus médians en France

Comme indiqué sur son site, l’INSEE fournit des informations socio-économiques sur près de 30 millions de ménages. Il diffuse ces informations à différentes échelles dont la plus petite est celle d’un carreau de 200 mètres de côté. Ces…


Using DuckDB with Tableau Desktop on Windows

DuckDB is an in-process SQL OLAP database management system. These database is very fast for OLAP queries and have several advantages : it can read and write Parquet files very efficiently, it use parallelism and SIMD for impressive performance.…


Loading data from CSV files into a Tableau Hyper extract

Loading data from CSV files into a Tableau Hyper extract Hyper is Tableau’s in-memory data engine technology, designed for fast data ingest and analytical query processing on large or complex data sets. In the present notebook, we are going to…


Using Tableau to detect outlying trends and ruptures

Tableau Tableau detects outlying trends using Tabpy. To do that, we are going to get the outliers of a dataset, the change points and a piecewise approximation. For detailled information about the source code, you can look at this article : Outlier…


Tableau 2022 Optimize Workbook Feature : first test

Tableau« Optimize Workbook » is a new feature of Tableau 2022.1. The idea behind this feature is to provide and checks good/bad practices on your workbooks before publication. BI tools can be complex to optimized when many calculated fields, sheets…


Tableau Custom Group

Tableau Performance Tips #8 : Avoid using Tableau Groups

Tableau Tableau Custom Groups : a really cool and useful feature ! Tableau allow users to build their own custom groups very easily. This is a convenient way to regroup data on elements that users want to see regrouped. When you have small data you…


Tooltips to display static metadata informations

Tableau Performance Tips #7 : Prefer to use a one row datasource to display static metadata informations

TableauA problem of choice Tableau does not have really customisable buttons. I mean you can put image on your dashboard but you cannot display the text you want with the formatting you want like that. One easy wait to put static metadata…


Tableau Performance Tips #6 : Avoid using NOW() for filtering or selecting against a fact datasource

TableauDid you heard about database result cache ?Some databases implement a result cache (or query cache depending the name), it is a cache for the results of some queries. Oracle, Exasol, HANA implement a result/query cache.  MySQL &…


Tableau Performance Bad Practice : use a sort on an element not in the view

Tableau Performance Tips #5 : Sort only with element(s) in the view

TableauYou want to sort data ? using a field ? Avoid to use a sort field that is not in the view !A performance issue that is not well known is that Tableau sorts is not done by the datasource but by tableau itself. And this even if you ask a sort…


Tableau Performance Recording for NOW() function

Tableau Performance Tip #4 : Avoid using a big datasource to display semi-constant informations

TableauTableau performance and constant calculated fieldMore than often you will want to display semi-constant information like the current timestamp, the Tableau Username, a chosen currency or a simple single information. For that the easy way is…


Performance record with LoV in the context

Tableau Performance Tips #3 : Avoid small list of values to be in the context

TableauThe issue of using list of values that are context's linked Let’s begin with a definition of what a list of values is. A list of values is linked to a filter. The filter can be in the context or not. Hum… May i should…


Tableau Performance and Sub-Totals

Tableau Performance Tips #2 : Avoid total and sub-totals when using a count distinct metric aggregate

TableauThe problem : Computing-Totals is done sequentiallyIf you use a total (or worse) sub-totals when you have metric(s) that is count distinct, this will lead to a second (or several) sequential pass for each subtotal level to retrieve data. The…


tableau performance recording dashboard

Tableau Performance Tips #1 : Tableau Performance Recording

TableauIn this article we will discover how to diagnose your performances with the Tableau performance recording. Both Tableau Desktop and Tableau Server can use the performance recorder. We will learn : what performance informations can be…


Tableau Server performance impacted by version history depth of datasources and workbooks

Tableau Server Performance impacted by the revision/version history depth of objects After several tests on real word tableau production environment (+1000 workbooks , +100 shared datasource) we discover that object version history have an…