Hot Selling Street Finder – France
.-.
Goal : Help real estate agencies to spot the most favourable streets in France with dynamic reports
Goal : spot the most interesting streets for a real estate agent (number of sales, total turnover )
Data available : Open Data
Various GEOJSON files adding up to5 giga-byte and 25 million lines provided by the government listing 9 years of individual sales
Difficulties : all data had to be heavily cleaned as manyAnti notaries did not respect the standards while entering their sales into the system.
Result : success with this Power BI, with one clean single master data database gathering all sales in a place. Easy dynamic report generation allowing any real estate agent to sport the best streets in their zone in a few clicks .
Access : Corporate use – Not publicly available
Anti-Money Laundering / KY
.
.
Global coffee exporter historical race
.
.https://public.flourish.studio/visualisation/12217842/
.
Quick animation for education about the coffee producer race since 1961
Target : social networks
Site : https://public.flourish.studio/visualisation/12217842/
.COFF
.
.
.
Artificial Intelligence : flash car plates and make a database
/.
Goal : capture car plates autonomously with a very light and cheap hardware ( under 200 swiss francs ) to all police or private properties to have a number of them
Hardware : Raspberry 4 and special camera
Internet site : paparazzai.com
.
.
Anti-money laundering tool for financial institutions
.
.
Goal : gather all Sanction lists / Interpol Red Alert to allow the AML department to reduce time spent on searching though the different databases
Data available : public databases provided by different governments and entities
Difficulties : limited access ( Interpol ) and heterogeneous governmental databases
Result : One HTML / AJAX page written on PHP/MySQL allowing staff to simply write the few letters of a name and obtain immediate results. The application works on computers but also on smartphones.
Access : Publicly available at https://swissdove.ch
.
.
Guess the GPS location of properties described in real estate ads
.
.
Goal : automatically provide the exact GPS locations of properties according to the vocabulary and photographies used in real estate advertising on the French Riviera
Data available : government administrative open-data
Difficulties : availability of data, some real estate agents mistaking of lying when writing the property description, the massiveness number of properties.
Success : user became able to guess the exact GPS location of about 90% of the provided ads
Access : Publicly available : https://lapanthererose.com
.
picoGIS,a Javascript mapping, extremely light but powerful mapper
This map can load thousands of GPS points and shapes without the need to go through the steep learning curve of QGIS or arcGIS.
Access : Publicly available : https://picogis.com
.
Skanoo : chase sugar and more scanning supermarket barcodes
Adapted to deaf and children, this free app allows everyone to chase the various rates of sugar, saturated fats, etc… in various languages. Great for children to learn about healthy and less healthy food.
Voice mode for deaf people available.
The database of products is huge ( 4 millions items ).
Publicly available in Google and Apple stores : https://skanoo.com, available on Android and IOS
.
Spot the most power-hungry buildings in your town
.
Pure javascript : game with voice over to learn about body organs in various languages. For windows and Android
Link : https://data-expertise.ch/wp-content/uploads/2025/09/index.html
.
Javascript – Finance (trading ) – Oil straddle simulator
Enter values and visualize the trading risk
Link : https://data-expertise.ch/wp-content/uploads/2025/09/straddles.html
.
Global coffee exporter historical analysis
Goal : as coffee is becoming a scarce commodity, allowing managers to study the rise of emergent coffee exporters allows for a better sourcing diversification, thus decrease the coffee refiners and coffee retailers sourcing risk.
Data available : World Economic Forum
Difficulties : Minimal data cleaning and transforming as data is well formatted at the source.
Success : very effective tool for corporate risk managers
Access : Corporate use. Not publicly available
.
