Output Data direct from API or Download to local Database First?

I’m building my first ever dashboard and decided to use Dash! My question is a rather elementary but I would appreciate some feedback.

I’m building a marketing dashboard for my ecommerce site. It’s going to call the Google API, Facebook API, and Microsoft Bing API and out put a few advertising KPI’s such as Daily Ad Spend.

A daily line chart would be nice too (30 day and quarterly).

1 Like

I’ve built a few similar dashboards and always used separate worker processes to get the data from the APIs into a database first. That said, it depends on how much data you need to retrieve from the APIs.