narrow down niche

Hello BHW members! I was just wondering, how do you guys find good/profitable niches for an (affiliate) site? Are there any tools you use to research the niche? I used to work with Google keyword planner to get some ideas and see competition, but how to narrow those niches down to some less...