Data visualization plugin advice

[ Moved to the Fixing WordPress sub-forum. ]

I could use some advice on automating data visualization.

Here’s the concept:
Once a year, I generate a spreadsheet ranking entities on various criteria – for example, Alpha through Zeta, each ranked on size, value, and a half dozen other things. Not all entities will have data for each criterion.

I’d like to have a post (or page) for each entity, with a variety of graphs drawn from the spreadsheet. For example, a simple ‘progress meter’-type graph for each criterion, and a spider graph containing all criteria.

I’d like the post to draw from the spreadsheet automatically or near automatically (e.g., I insert a shortcode that’s an SQL query based on the entity name or post title).

I’m happy to go through some work once a year (e.g., to load my spreadsheet to a database). I’d be happy either to retain old data (and old posts), or simply replace the data every year (and have only current posts). I’d rather have a solution that relies on a dynamic (editable) source, than one that uses a one time import.

Any thoughts on the best way to go at this (recognizing that I’m willing to dig in a bit, but I’m not a coding or SQL expert)?

My initial thought is some sort of visualization plugin that relies on SQL queries.