xpinchx,

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.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • lemmyshitpost@lemmy.world
  • localhost
  • All magazines
  • Loading…
    Loading the web debug toolbar…
    Attempt #