Excel, excel VBA, SQL, ETL tools, Python.
The important thing in data analysis is data thinking. The above is just a tool, similar to a wrench that you use to turn a screw.
Data analysis includes but is not limited to statistical knowledge. If you really want to elaborate, it may be a hodgepodge of everything.
It's never too late to enter the business, but if you really want to change careers, you must be prepared for a protracted war. Doing skills is always learning.
I don't know much about training institutions. A friend of mine has been to Chanz to do a podcast, saying it's good to learn JAVA there, but I don't know how to analyze the data. I have never experienced it, and it is for reference only.