• jonne@infosec.pub
    link
    fedilink
    arrow-up
    2
    ·
    11 months ago

    Heh, our company is bigger but I guess we don’t use spreadsheets the way you do. At least on the dev side basic functionality is fine, and our core business runs on real databases and stuff like AWS quicksight.

    • xpinchx@lemmy.world
      link
      fedilink
      arrow-up
      2
      ·
      11 months ago

      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.