Our current install of SharePoint is 2010. Over time we have developed several SQL queries against our nightly backup copy of the database (NOT the production database), which feed SSRS reports.

We have begun to think about upgrading SharePoint and our Network team are very interested in moving 100% to SharePoint Online.

My question is, what options would I have for replicating our current reporting practices if the lists which are currently reported off of are moved into SharePoint Online?

Our two main instances of SharePoint reporting are;

1 - Reporting against three SharePoint lists in one report

2 - Reporting against 1 SharePoint list and joining it to a nightly copy of another applications database