Comment on Who is the enemy?

djmikeale@feddit.dk ⁨3⁩ ⁨weeks⁩ ago

• MajorasTerribleFate@lemmy.zip ⁨3⁩ ⁨weeks⁩ ago

  As someone who used to work with “large” (to normal people; 10k-60k rows up to maybe 70 columns) datasets in Excel exclusively, I also hate Excel.

  source

  • blindsight@beehaw.org ⁨3⁩ ⁨weeks⁩ ago

    Me too!

    I hate working with other people’s spreadsheets.

    Or my old spreadsheets.

    The worst is “can you just add a small feature” to a huge, sprawling, mission-critical, often reused spreadsheet.

    But I love how quick and powerful it is to spin up a new spreadsheet to analyze something or clean up messy data!

    source
• MissJinx@lemmy.world ⁨3⁩ ⁨weeks⁩ ago

  dude you can hate but 80% of “data” still.on excel. I’m in my third global company and people still control things on excel. and 5% power bi (some from excel) hahahahaha

  source

  • djmikeale@feddit.dk ⁨3⁩ ⁨weeks⁩ ago

    Yep, that’s true haha.

    It’s perhaps not so much Excel, as much as it’s just the symptom of a lot of bigger issues: working without version control, without column validation or access control, limited documentation (not necessarily better in data warehouse but at least the functionality is easily accessible), limited automated testing, etc etc.

    If only they could keep their data for themselves, then ok. but no no, we have to ingest it, and do work on top of it in dwh, and it just breaks so often due to a variety of different stuff.

    source
  • Trainguyrom@reddthat.com ⁨3⁩ ⁨weeks⁩ ago

    Wait you mean your organization doesn’t use some ludicrously expensive hosted database solution or 3 to aggregate data then instead of natively working with the data in that database it gets exported and transformed on a local machine which may or may not havd backups then ask the database people about weird data quirks coming from the local transformations performed on the data

    source

    • MissJinx@lemmy.world ⁨3⁩ ⁨weeks⁩ ago

      they do but they export it to excel 🤣 not joking, some people export the entire data base of something and just use it on excel because “it’s very easy”

      source
    • djmikeale@feddit.dk ⁨3⁩ ⁨weeks⁩ ago

      That hit a bit too close to home. 😂

      source