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?
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
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 🤦♂️
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.
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
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 ;)
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.
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.
You have THE BEST videos for DITL 💖✨ Thankyou so insightful
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?
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
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 🤦♂️
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.
That logic from the Data Scientist makes a lot of sense. That’s so profound.
Looking forward to you giving us a full data cleaning and dashboard and presentation tutorial video. Thanks Nakya
That would be awesome!
Best of wishes sis🎉🎉🎉🎉
These things, Vlookups and other excel formulas are bare minimum for me, really. It ought to be basic for any serious data analyst.
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
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.
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 ;)
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.
How were you able to sort out the duplicate data at the end of the video?
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.
@@NakyaSherrell Oh nice. That’s so cool. Thanks so much
I ask Alexa if the US is at War and she just ignored me😂😂 I guess not……😏
🤣