Product(s): SQL Server Reporting Services (SSRS)
Overall Comment:"SSRS is still a great reporting platform, but only if you are still using on-premises SQL servers. If you need anything else it quickly becomes very difficult and complex. As a backend for other BI tools it is great, but don't expect modern reporting output."
Administration and security is fully SQL integrated. This also means it is AD integrated so you don't have much to do here. It is very reliable and has managed to get great performance without disrupting production.
The environment feels outdated compared to modern BI tools. You will often need to revert back to Excel for further work. Data modeling needs to be done with SQL views of stored procedures which can get complex very quickly. There is no option for end users to build or modify reports so without IT they can only get what they can see.