Creating weekly/monthly/quarterly sales reports

Hello,

Our company just switched to Monday, and I am tasked with creating sales reports from three different data streams - QBO, and 2 shopify stores. I was going to pull the data using Zapier, but am a little unclear on how to set it up so it is a functional report. Any help would be appreciated!