There are various answers to that kind of question.
Out of the box you can cover part of the needs by using Catalog Manager reports to find out which analysis (they aren't reports but analysis, a report is a BI Publisher report) reference directly which presentation column.
In the Admintool you can generate a CSV file with the mappings of the RPD (the 3 layers) which include most of things.
These 2 put together can give you answers.
It's important to keep in mind that they miss some cases etc.
You could also script things to have a proper data lineage:
The smart thing is to use Gianni's solution.