New analysis has revealed how the rediscovered popularity of train travel coupled with investment has transformed the Welsh rail network.