Multiple Metrics...Same Name Different Calcs, SQL, More Audits | Day In The Life of a Data Analyst

Поділитися
Вставка
  • Опубліковано 13 гру 2024

КОМЕНТАРІ • 19

  • @munchingmogul
    @munchingmogul 3 місяці тому

    You have THE BEST videos for DITL 💖✨ Thankyou so insightful

  • @diamondsandlipgloss
    @diamondsandlipgloss 3 місяці тому +1

    1. for the duplicates, does someone filter them out when determining actual sales? if not, wouldn't the duplicar sale inflate that persons sales?
    2. when someone doesn't understand your report, are you required to customize the same report for each stakeholder?
    3. when you switch from one database to the other, would you please tell us which one you're using? ex: did you write your left join in Excel power query?

  • @rumeeburu3648
    @rumeeburu3648 3 місяці тому +6

    Yeah not every project requires a dashboard. I’m a freelance at the moment and what my recent client only needed was a TABLE… a FREAKING TABLE… hehe… nothing more… nothing less

  • @anjucaesar93
    @anjucaesar93 3 місяці тому +2

    This is good, very informative to know what data analysts actually do daily. People always made it sound like rocket science, it really is not. Alot of us are doing data analyst roles buy its worded under a different title 🤦‍♂️

    • @NakyaSherrell
      @NakyaSherrell  3 місяці тому +3

      This is very true, which is why I tell people to look for the skills in job descriptions and not the title as titles can be deceiving. I know many people that have the title Project Manager but they are doing the job of a data analyst.

  • @rumeeburu3648
    @rumeeburu3648 3 місяці тому

    That logic from the Data Scientist makes a lot of sense. That’s so profound.

  • @rumeeburu3648
    @rumeeburu3648 3 місяці тому +1

    Looking forward to you giving us a full data cleaning and dashboard and presentation tutorial video. Thanks Nakya

    • @xOrchid23x
      @xOrchid23x 3 місяці тому

      That would be awesome!

  • @cornelldaniel
    @cornelldaniel 3 місяці тому

    Best of wishes sis🎉🎉🎉🎉

  • @rumeeburu3648
    @rumeeburu3648 3 місяці тому +1

    These things, Vlookups and other excel formulas are bare minimum for me, really. It ought to be basic for any serious data analyst.

  • @rumeeburu3648
    @rumeeburu3648 3 місяці тому

    If only there was a way we could see more of what you’re doing in your excel and SQL… sounds too cool for us to just hear it from you… help us emerging data analysts… hehe

    • @NakyaSherrell
      @NakyaSherrell  3 місяці тому +3

      Unfortunately, I don't believe that I will ever be able to share/show info from my actual job as I'm dealing with employee and customer data.

  • @kimbapslayer1995
    @kimbapslayer1995 3 місяці тому

    Hey, just started your video. Your candle is giving me anxiety lmfao. It looks safe, it looks innocent, it looks accident proof, but it's not. There are random one in a blue moon embers from a whick, and can catch that bust or paper on fire. GYI ;)

    • @NakyaSherrell
      @NakyaSherrell  3 місяці тому +2

      Hello, thanks for your concern.I practice proper candle safety. The candle by the bust has a battery operated candle in it. So hopefully it doesn't catch anything on fire. The one on my dresser that you can see towards the end of the video is a real candle. I never burn a candle for longer than 3hrs at a time and I'm always have an eye on them.

  • @rumeeburu3648
    @rumeeburu3648 3 місяці тому

    How were you able to sort out the duplicate data at the end of the video?

    • @NakyaSherrell
      @NakyaSherrell  3 місяці тому +3

      It wasn't a duplicate data issue. There was an issue where employees had multiple ID's. I eventually found a table that had their ID's tied to a date. So I could differentiate which ID they had during a specific timeframe.

    • @rumeeburu3648
      @rumeeburu3648 3 місяці тому

      @@NakyaSherrell Oh nice. That’s so cool. Thanks so much

  • @YouAREyoubeYou
    @YouAREyoubeYou 2 місяці тому

    I ask Alexa if the US is at War and she just ignored me😂😂 I guess not……😏