How to avoid or reduce SOQLs in Salesforce?
1. Do not use SOQL inside the for a loop. 2. User UserInfo wherever possible - https://www.infallibletechie.com/2016/01/how-to-get-username-of-user-using-apex.html. 3. Use Custom Settings for hard coding Report Folder or Dashboard Folder ids, ....