In few companies, people prefer to see the data in MS Excel sheet for their reporting needs.
In MS Project Server, we have reporting feature. Sometimes that is not enough to meet the reporting needs of a company. In that case, one can use some of the third party tools available in market. For basic reports one can use MS Excel using a hidden gem in it called MS Query.
If you know Excel then you have unlimited option for reports using MS Query. I’ll suggest the following articles on the topic.
Connect to the Project Server OLAP Cube with Excel 2000
Use MS Query to Treat Excel As a Relational Data Source