Depending on how deep you want to go I would recommend Microsoft PowerBI Desktop, its free. Very easy to get up and running and you can export to excel for action. https://powerbi.microsoft.com/en-us/desktop/
Also depending on how old your AS400 is getting data out of it to any other platform might be your biggest challenge.