Yeah most of our ERP dumps data into an Azure database, but we frequently pull queries for ad hoc reporting/analysis into Excel as well as maintained BI reports.
The real issue is a lot of our SaaS isn’t fully integrated like that so we have to csv dump data that loads into other queries and we pull from that 🙃 But those csv dumps are set with automations so it’s mostly hands-off, just a little janky lol.
Yeah most of our ERP dumps data into an Azure database, but we frequently pull queries for ad hoc reporting/analysis into Excel as well as maintained BI reports.
The real issue is a lot of our SaaS isn’t fully integrated like that so we have to csv dump data that loads into other queries and we pull from that 🙃 But those csv dumps are set with automations so it’s mostly hands-off, just a little janky lol.