Dataviz
Evolution des prix de l'immobilier en France - DVF à l'iris
En croisant les données DVF (Demandes de Valeurs Foncières) maintenant disponibles en open data, nous avons construit ce dashboard. Il vous permettra de déterminer le prix médian au m² suivant le type de local (appartement ou maison), la région, le…
Le Tour de France History Dashboard
After scraping historical data from the « Tour de France » website, we will leverage this data to build a beautiful dashboard. Latest version of webscrapping notebook can be found here :…
Gender Equality Indexes : 2023 Edition
Gender equality index is an indicator created by EIGE. It measures the progress of gender equality in the European union countries. The index ranges from 0 to 100. The equality is 100. Six domains are studied: Health, Knowledge, Money, Power, Time,…
SQL Server Features Comparison and Evolution
Let’s concentrate on the last 3 versions to see features evolution and comparison between edition. Clic, Ctrl+Clic, or mouse maintain and select area to filter others on th dashboard. Click elsewhere to release filter or change it. On the…
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…
Tour de France des revenus des français
A partir des données Fiscales (FiLoSoFi) fournies par l’INSEE en open data, nous avons voulus étudier les revenus médians des français au travers un cartographie nationale et faire le Tour de France des revenus. L’INSEE mets à…
Download some benchmark road networks for Shortest Paths algorithms
Updated September 26, 2022 bugfix The goal of this Python notebook is to download and prepare a suite of benchmark networks for some shortest path algorithms. We would like to experiment with some simple directed graphs with non-negative weights. We…
Using Tableau to detect outlying trends and ruptures
Dataviz 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
Dataviz« 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
Dataviz 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…
Gartner Magic Quadrant BI 15 years History
DatavizBusiness Intelligence (BI) tools are competing for years. Gartner Magic Quadrant is one of the famous benchmark that classify mainstream BI tools. We have retrieved old MQBI (Magic Quandrant Business Intelligence) benchmarks and compiled them…
Tableau Performance Tips #7 : Prefer to use a one row datasource to display static metadata informations
DatavizA 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…
Plotting population density with datashader
In this short post, we are using the Global Human Settlement Layer from the European Commission: This spatial raster dataset depicts the distribution of population, expressed as the number of people per cell. The downloaded file has a worldwide…
Tableau Performance Tips #6 : Avoid using NOW() for filtering or selecting against a fact datasource
DatavizDid 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
DatavizYou 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
DatavizTableau 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
DatavizThe 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…
8 mars 2022 : Journée internationale des droits des femmes
8 mars 2022 : Journée internationale des droits des femmes Après quelques semaines à étudier de l’open data sur le thème des inégalités homme/femme, voici une visualisation sur l’index d’egalité de genre de l’EIGE (European…
Tableau Performance Tips #2 : Avoid total and sub-totals when using a count distinct metric aggregate
DatavizThe 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
DatavizIn 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…
COVID Deaths Worldwide Evolution Dashboard
This dashboard show main key figures for COVID deaths wordwide and the evolution of number of deaths. Filtering data using continent/area and country map to see the evolution of number of deaths and letality for the whole area selected For the…
Tests, incidence, hospitalisations, réanimations et décès du au COVID en France par départements et par Régions
Filtrage via les cartes régions et département montrant l’incidence (hebdomadaire) du COVID en France pour la dernière semaine pleine (mise à jour le jeudi soir) En cliquant sur une région (ou plusieurs) ou sur un département dans la carte de…
Incidence COVID en France par départements et par tranches d'âge dernière semaine
Grâce aux données fournies par le SidDep voici une analyse de Incidence COVID en France par départements et par tranches d’age pour la dernière semaine pleine (mise à jour le jeudi soir) : l’analyse détaille l’état des lieux par…
Impact of food on CO2 production : Eat Better - Eat Local
A viz showing the Impact of food on CO2 production by showing how much Kg of CO2 is produced for 1 Kg of foods. Data source : https://ghgprotocol.org/product-standard The viz detailled where in the supply chain the CO2 et produced. Click on the top…
COVID Hospitalisations, Réanimations et Décès en France par départements
Afin de produire la visualisation montrant pour le COVID, les hospitalisations, réanimations et décès en France par départements, j’ai utilisé un web data connector (basic-csv-wdc) sur tableau permettant de sourcer un fichier csv disponible…
Part des personnes testées positives au COVID en France
Après l’analyse des données COVID par régions et tranches d’âge, j’ai produit une nouvelle visualisation toujours basée sur les données Sidep sur data.gouv.fr pour visualiser dynamiquement la part des personnes positives au COVID…
Stack Overflow Trends
How i built a Stack overflow trends dashboard Starting using Brent Ozar Stack Overflow database extract i tried to build a dashboard that show evolution of Tags Trends over time and if possible compare trends of several tags between them. I first…
Incidence COVID en France par départements et par tranches d'âge
Après l’analyse des données COVID par régions et tranches d’âge, j’ai récupéré les dernières données (mise à jour une fois par semaine) et détaillé l’analyse aux départements et tranches d’âge. En cliquant sur une…
Incidence COVID en France par région et par tranche d'age
Après l’analyse des données COVID France-Départements et tranches d’âge initiée par François j’ai décidée de relever le challenge et de faire un dashboard dynamique avec Tableau. En cliquant sur une région (ou plusieurs) dans la…
Quick data exploration with pandas, matplotlib and seaborn
In this JupyterLab Python notebook we are going to look at the rate of coronavirus [COVID-19] cases in french departments [administrative divisions of France]. The data source is the french government's open data. We are going to perform a few…
Gartner analytics and Business Intelligence tools comparator
As promised here is an article on the Gartner® analytics and Business Intelligence tools comparator based on the capabilities and use cases of the tools. There are interesting differences on the final scores compared to the Magic Quadrant which…
Lunch break, ridge plots with Bokeh
Bokeh is a great visualization Python library. In this short post, we are going to use it to create a ridge plot. For that purpose, we use the COVID-19 death data from Johns Hopkins University, and plot the daily normalized death rate (100000 *…
Lunch break, plotting excess death in french department zones with Python
Daily deaths data are provided by INSEE - the national institute of statistics and economic studies. Here is the link of the page displaying these data, and here is a short description: During the Covid-19 pandemic, INSEE is reporting the number of…
Lunch break: plotting traffic injuries with datashader
Well I love the datashader Python package and I am always happy to use it on some interesting datasets. I recently came across a traffic injury database for french roads, which happens to have some geographical coordinates. This comes from the…
Gartner MQBI (Magic Quadrant BI) History
We had compiled Gartner BI Magic Quadrant data since 2007 in several dashboards that show the evolution of the Gartner MQBI history with BI vendors benchmarks over 14 years.
Nighttime Lights with Rasterio and Datashader
daIn this post, we are going to plot some satellite GeoTIFF data in Python. The data is provided by NOAA (single GeoTIFF: F16_20100111-20110731_rad_v4.avg_vis.tif): The Operational Linescan System (OLS) flown on the Defense Meteorological Satellite…
Symmetric Chaos with Datashader and Numba
Map equation and coefficient values are taken from here. Some mathematical explainations can be found here, by Mike Field and Martin Golubitsky. import numpy as np import pandas as pd import datashader as ds from datashader import transfer_functions…
Plotting Hopalong attractor with Datashader and Numba
What is an attractor? Definition from wikipedia: In the mathematical field of dynamical systems, an attractor is a set of numerical values toward which a system tends to evolve, for a wide variety of starting conditions of the system. System values…