🦈 Analyzing Open Data shark attacks with gemini-cli and Quarto 📊

This is a submission for the Built with Google Gemini: Writing Challenge 😂 Spoiler alert :...

This is a submission for the Built with Google Gemini: Writing Challenge

😂 Spoiler alert : what it was not

It was not a straight and peaceful journey

{% twitter 2027947601442836653 %}

❔ What I Built with Google Gemini

I created a Quarto Notebook based on Open data (I maintain since many years now) that reports Shark attacks in New-Caledonia to better understand what happens since many years now.

I used Gemini-cli to :

• Help implement the Notebook that I wanted to look a bit like a newspaper report
• Give me some inspirations during chats
• Ask him to challenge me with questions
• Imagine an interview which gave me the opportunity to better express & share my ideas
• Challenge me with new questions
• Finally produce a journalistic like paper anyone can read and print
• Finally put this pdf as input with other related articles data sources into NotebookLM to produce a video

Pretty fast, I could get first stuning dataviz :

{% twitter 2027632648970223954 %}

🔥 Work planning (brain on fire)

• Saturday 2026-02-28 : 07:00 AM to 18:30 PM
  • First MVP
  • Video demo
  • NotebookLM video production
  • First article version and publication
  • First social posts to share the insights I discovered
• Sunday 2026-03-01 07h00 AM - 10:30 & 13:00 - 15:00 :
  • pdf finetuning, review and little enhancements
  • Section title review
  • Charts title review
  • Take feedbacks and implement them
  • Chase on keyfindings hallucinations with specific data-driven PROMPTs

🍿 Demos

The main output of the project is a pdf.

Yet, here is the full storytelling I'll use for educational purpose:

Long edition with pdf commenting

{% youtube M3iiRXKgz60 %}

Short edition (for educational purposes)

{% youtube 4YQoeajyMHA %}

📑 Resources

• Source code : github.com/adriens/odata-ncl/data/shark-attacks
• Final pdf report
• NotebookLM project
• Python SDK for water quality : adriens/edb-noumea
• Ready to use csv data for water quality : edb-noumea-data, automated with Gh Actions
• Go TUI to browser water quality from any terminal : edb-noumea-tui
• Kaggle dataset : 🦈 Shark Attacks - New Caledonia
• Kaggle Notebook : 🦈 Shark Attacks New-Caledonia for dummies
• Kaggle Notebook : Shark Attacks in New Caledonia - Analysis
• Kaggle Notebook : 🦈 Shark Attacks New-Caledonia KPIs

🧑‍🎓 What I Learned

• Need to very seriouly & carefully review AI generated comment on charts as quite often for example the "Key findings" were wrong :
  • Nor respect for the color code accross the whole document (fatal vs. non fatal attacks)
  • Evaluating 59% as the 2/3 of the attacks
• Put the terminal to a given level of transparency so I coul read the resulting pdf while chating with gemini-cli (I have a small laptop with single screen)
• I could very efficently take other people feedbacks in account which had a huge impact on dataviz and KPIs to avoid bias

💡 Google Gemini Feedback

I only used Gemin-cli :

• I really enjoyed being interviewed by Gemini, it really made me creative, it was the first time I did this, but for sure I will reuse this pattern

📸 Screenshots

Below a collection of the resulting pdf :