I run a raspberry pi that identifies birds by their song, and records time, date, and species etc in an SQLite3 database.

The rpi app comes with some basic reports, but I'm wanting to expand on them, so that I can show monthly/yearly trends etc.

On windows at work, I'd use something like Power BI, but a) it's windows and b) it's overkill for my current needs.

I've only recently moved entirely to linux, so I'm not really sure of what the linux alternatives are, and I'm looking for suggestions :)