You can create a dashboard and let people view the dashboard as you (or anyone else who can see all opportunities).
Resources:
Dynamic Dashboards in Lightning Experience - https://help.salesforce.com/articleView?id=dashboards_view_as_overview.htm&type=5
Choose a Running User in Salesforce Classic - https://help.salesforce.com/articleView?id=dashboards_select_running_user.htm&type=5
You can set automatic dashboard refreshes and receive refreshed dashboard results by email on a schedule that you set.
Resource:
Subscribe to or Schedule Dashboards - https://help.salesforce.com/articleView?id=dashboards_subscribe_overview.htm&type=5
In this lesson, I add a dashboard to a Home page. We then specify that page as the org default Home tab as well as the default for all profiles for the Sales app. We also further specify this same page as the Home tab default for the Knowledge application for System Administrators only. We discov...
In the previous lesson, after adding a dashboard to a Home tab and specifying it as the default Home tab for the Knowledge app for System Administrators, we discovered that the Home tab was missing from the app. We go into the Lightning Experience App Manager in this lesson and add the Home tab t...
