Troubleshooting and outside of the box thinking - can you learn it?

I work at moody's as a data analyst. My work mostly revolves around looking for issues with data. Once an issue is identified, I need to figure out what happened and how to fix it. Thing is, I suck at it. It takes me always so long to find out anything, my peers are able to guess the solution or the issue on the fly.
Are there any resources such as books you can recommend to be better at troubleshooting?