• zedcell@lemmygrad.ml
    link
    fedilink
    English
    arrow-up
    1
    ·
    8 hours ago

    Power Query just trivialises so many once annoying tasks I can’t imagine going back to “just a spreadsheet”

    • SocialistVibes01@lemmy.ml
      link
      fedilink
      English
      arrow-up
      1
      ·
      8 hours ago

      I agree. Do you know KNIME? It does a lot of the same transformations. But something like DAX has to be provided by Python.

      • zedcell@lemmygrad.ml
        link
        fedilink
        English
        arrow-up
        1
        ·
        8 hours ago

        No idea about KNIME personally. I find there’s real value in having the Swiss army knife of Excel that every office worker has access to be able to do really in-depth and multi-step transformations without needing access to a scripting language and package manager. Normally corporate IT are a little cagey handing out access to Python to a random admin staff member, but we all have and can share Excel stuff no problem.