One of the productive things we did as a team is to give our SQL savvy PM read access to a production BI replica. We'll still get occasional requests for infor

One of the productive things we did as a team is to give our SQL savvy PM read access to a production BI replica. We'll still get occasional requests for information or questions, but by and large he can deal with the day to day. So good on your buddy for wanting to learn how to do it himself. If he's even halfway successful it'll save him and his teammates time in the long run.