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…
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…
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 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…
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 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 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…
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 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 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…