• SocialistVibes01@lemmy.ml
    link
    fedilink
    English
    arrow-up
    1
    ·
    7 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
      ·
      7 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.