Suggestions
benja Sicard
Data Architect & Engineer
Really loving data.Hello everyone, I'm Benjamin, a young man from the lovely city of Paris :-)After studying BI at EISTI (french engineering school), I starter to work at SynerTrade as a Business Intelligence developer and consultant. I'm mastering most...
Highlights
🗺️ Today, I’m sharing some significant updates to my Paris 2024 French athletes and Olympics medalists map!
Previously, my visualization of France, colored by the number of medals from athletes born in each department, was missing an important piece: the French overseas departments and territories (DOM-TOM). I’m happy to announce that they’re now included!
🌍 This was a particularly interesting challenge, as I had to manually add the geojson files to represent the DOM-TOM. I created a separate map for each DOM-TOM, ensuring they are clearly visible without needing to zoom in on a world map. This experience has opened up a world of possibilities for me—working with geojson is fascinating and will allow me to create diverse maps and analyses with various geographic divisions: continents, countries, regions, departments, and even municipalities.
📈 I also added two new data quality indices to the visualization to provide more context around the reliability of the data. The next step will be to improve the quality of the athletes mapping.
Stay tuned for more updates as I continue to refine and expand this project!
The dataviz is accessible here: https://lnkd.in/eRRDFZii
#DataVisualization #Olympics #InteractiveData #Geojson #DataQuality #DataEngineering #Paris2024 #SportsData #dbt #evidencedev #duckdb #dataviz
💡 Interactivity and simplicity can make data more accessible and insightful.
🗺️ Today, I want to compare two visualizations of Paris 2024 Olympic medalists from France.
Libération's infographic maps French departments with bubbles that encode three elements: department number, population size, and medalists per million inhabitants. While visually appealing, I find it overwhelming. Our brains expect the number inside the bubble to represent the main KPI (medals), not department numbers, and it’s difficult to grasp the significance of the bubble size and color simultaneously.
🔄 In contrast, I developed an interactive map focused on a single metric: the number of medals and medalists per department. The entire area of each department is color-coded to represent this value. Unlike the static infographic, my map is interactive—selecting a department reveals a table listing medalists born there, complete with links to their official Olympic profiles.
🔧 However, this approach isn’t without its limitations. The data quality on birthplaces is inconsistent, and the map currently omits athletes from French overseas territories and those born abroad. I’m working on addressing these issues in the next version.
#DataVisualization #Olympics #InteractiveData #DataStorytelling #DataEngineering #Paris2024 #EvidenceDev #dbt #dataviz #olympicgames #sportsdata
