none of them seem to have understand what they are working on. There very silo'd in there approach - it all about there project - full stop. It doesn't help us as a business, but when it's raised it's closed off as just 'thats the way we do this'
I don't think this should be the case at all, and I'd like to work my way up and prove that to be the case.
I'm not bothered about the increased pay, the extra responsabilties etc - they don't drive me. But knowing that I am trying to do the right thing and what seem's to be the right way does
This attitude may pose some challenges for you. Fundamentally, most organisations appoint a project manager to deliver a project, not to 'do the right thing' or help the business in general (although that should be an indirect consequence). To be successful many PMs will have to be silo'd on a vertical level, because if they start worrying too much about the bigger picture then it may negatively impact their project in some way (typically deviating too much from planned time/budget). So the approach many PMs will take is influenced by the organisation as much as their personal choice. Essentially it is not the role of the PM to run the wider business, there should be other people taking care of that and conceptually if there is sufficient project governance then the project should help to deliver towards overall business goals anyway.
Going back to the original question, I come from a similar background (Data/BI) and the approach I took was:
1) Studied Project Management at Postgraduate level
2) Stated my desire to my employer to make the transition and run some small projects
3) Took PRINCE2 Practitioner when offered by employer
4) Undertook PM role for a workstream (BI) within a wider project - this basically meant doing all the admin/reporting/planning and client liaison but not quite a full-blown PM role in terms of budgetary responsibility
5) Changed employer and subsequently stated ambitions in PDR
6) Offered PM role on a small-ish project relating to DWBI
I don't think you necessarily need to go via a junior PMO/Admin role, I guess it depends how senior you are currently as to whether that would be too much of a step down. Most people I see going that route are youngsters who went there as pretty much their first IT job.
As for whether PRINCE2 is valuable, it is in the sense that many employers (especially public sector) expect it. The actual material itself is very mixed and the number of organisations who strictly adhere to it is quite limited (in fact PRINCE2 itself suggests that organisations use a tailored approach if appropriate).