Black Lives Matter. Please consider donating to Black Girls Code today.

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.