Day in the Life of a Data Analyst: Stakeholder âž¡ï¸ Co-Worker âž¡ï¸ SQL âž¡ï¸ Python âž¡ï¸ Visualizations
Vložit
- Äas pÅ™idán 7. 09. 2024
- Sign up for Deepnote here! deepnote.com/?...
Follow along using this link: bit.ly/3xROkFr
Watch me reenact a REAL day in the life of a Data Analyst. From interviewing the Stakeholder for requirements to asking a coworker for the location of a table, to creating a SQL query, and analyzing the data in Python, you'll get to really FEEL like a Data Analyst.
If you want to pick up the skills I show in this video, check out my Bootcamp: goto.mastersch...
My FREE Courses:
📊 Tableau📊 : • Tableau Beginner Cours...
⌠SQL ⌠: • SQL for Data Analysts ...
ðŸ Python ðŸ. : • Python for Data Analys...
📈 Statistics 📈 : • Practical Statistics f...
🤖 Machine Learning 🤖 : • Machine Learning for B...
Patreon: / shashankkalanithi
MX Master 3 amzn.to/3sTroBW
LG 35in Curved Monitor: amzn.to/39pPzR3
USB-C Hub: amzn.to/31Ip8Sl
MacBook Pro Retina 16 Inch: amzn.to/2PSwZde
Twitter: / kalamari95
LinkedIn: / shashankkalanithi
Check out Deepnote using this link: deepnote.com/?
By him almost alienating the "One hit wonders" I feel he committed a kind of western problem solving tactic of "Throwing out the baby with the bath water". (Similar to how certain American state governments shut down stimulus checks and aid for everyone when a few people were scamming the system. Many people were living check to check and their lives depended on government aid)
The company, in this example, wants to INCENTIVIZE reviewers who clearly at 1 point had the "sauce" to influence others who read their review. Anecdotally, I personally was a one hit wonder on Google Guides back in like 2016 until they sent me an email to make me feel special about a photo I took of a Las Vegas bus depot I was waiting at lol
From then on, I felt empowered to take more photos from my travels and now I'm a top google guide. I know I might be the exception and not the the rule, but you miss out on the potential of a very impactful influencer when you omit about 800k+ reviewers just because they have1 review... even though a couple of them may have a very impactful way of reviewing . They may just need that jumpstart like I did.
P.S At the end of the day a company values a "helpful" reviewer because they can influence others to go to a place, or buy a product. Just because a reviewer comments a lot , doesn't mean he can write a compelling review to convince people to make a decision based on what he/she wrote.
We need more of this 'real-life' problems type of video. No other Data Analysis creators are doing this. You seem to be demonstrating that business stakeholders can be vague in their requirements. How do Data Analysts steer/lead/structure these requirements gathering conversations to make them productive?
for real !!!
This this this!!!
This ! My first analyst internship was horrible because I truly had a hard time narrowing down exactly what my stakeholders wanted because they were vague but always acting like they were happy during the process. It was confusing for me at 19
you have to be direct. its the only way in my experience. narrow down the vagueness best you can and explain to them why the clarification is needed. analyst jobs require assertion imo
Yeah, I keep seeing day in the life videos and it is about their meeting times and lunch breaks...🤦
In grad school, none of the data I needed was ever available for me in a SQL database. Honestly, wrapping my head on what work in SQL is and why it’s so important has been hard for me. This was incredibly helpful though for contextualizing what SQL work looks like in this industry though
I’m super happy to hear that! That’s the exact point of these videos
I agree when I started learning SQL I thought it was a little overkill because all the data I have ever worked with at school or on the job (gov't 10+ yrs) could easily fit in to excel. Also most SQL tutorials only show small databases for demo purposes. So, it's kind of nice seeing actual huge datasets out in the wild and having a practical purpose/example of what you want to get out of it which is refreshing.
i’m in grad school right now for analytics and none of the curriculum goes in-depth with SQL so i feel ya
I gained a lot of confidence by watching this daily life experience...i had doubts regarding my current direction as someone shifting to data analytics career, thanx a lot!!
Keep up the good work.
This was the most useful ‘day in the life’ video I’ve seen thus far. Thank you for all you do for our benefit. I look forward to more useful and practical, authentic content like this.
Love the very realistic a day in life video! 🙌 And the intro is so much fun. Great job!
I love how you are able to capture the actual tasks! Definitely a valuable content here in CZcams! Keep it up, Shashank!
A viewer from France : I love your videos man !
Everything is clear, I know exactly what data analysts are supposed to do thanks to your videos.
I’m learning python, SQL (I’ve already a good level on excel and powerBI).
Those videos are so helpful because we know exactly what skills we need to learn in order to become better !!!
You are literally the best data analyst channel on CZcams
I love how you show what you do
This video just made me realize I've been doing well with my projects
Yes you are right. I was also glad that i can relate my projects with the actual tasks in job.
5 minutes into this video and I already love it. Awesome video Shashank.
Loved this, so used to seeing the day in the life which involved breakfast, office your and gym, so happy I get to see someone doing actual work, great work aswell :)
And those videos usually only show them sitting in meetings and checking email in between all the food and gym.
This was fantastic, thank you! A video of how to navigate with the ambiguity of stakeholders would be super helpful!!
You scared me with the Teams Call audio at the beginning.
You will be my instructor in master school this coming 2 weeks, very excited and ready to start a new career!
Super excited to have you on!
Just found your channel. Actual hands on is what I’m looking for and now here we are. I am looking to pivot into data analytics and this is super interesting. Thank you.
Honestly, what you're doing is amazing! There are many people who are interested in getting into the field of data science and analytics but don't really know what the career is really like, so having a regular day in the life on full display like this is really refreshing and insightful!
Also, learning a lot of tips and tricks from your videos.
Dude, this type of video is the one that hooked me up to your channel as subscriber! Loved it!
After delivering a report I often get a reply like “That is exactly what I asked for, but it’s not what I wantâ€
Then you end up creating a new report
So as a data analyst you have to anticipate and include other data that will be of value
So what's your point? Ask more questions to understand the requests better?
I am trying to get a job as a Data Analyst. I have learn SQL but I still can not wrap up the pictures of how can SQL work with real practice. This video is showing me everything in reality works. It is very helpful.
Hey Shashank would like to know if you could make a video on a way where we could query the data and send it to Google sheet with automation
Thank you...that is exactly what I was looking for...I wanted examples of what I would be doing as a data scientist in relation to other team members and you gave a concise explanation of it...
Its was great to see real work presented. Please share a video on how you would pressent to stake holder. Thanks a million
Thank you so much sharing this kind of video.
It is of great use for anyone asking himself what it is to be a data analyst. Still wondering if i'll jump off my actual job and you'r doing great material to think on.
Keep up please :)
You have no idea how insightful this video is. Thank you.
Hey Shashank ... You are really awesome man... I watch all your videos and learn alot ... I am a customer experience analyst ... I sometimes struggle with the verbal analysis using the customer comments in multiple nps and after order or chat survey data.. Can you make a video on that as well?
Excellent video!!
Would you also talk about "Deepnote" and the setup. For example, how can you access the company's data in the first place? Is SQL embedded already? Etc.
Thank you for your awesome work Shashank!!
i also had to do some searching and i found out that on the far right side of the 'deepnote' screen there is an option to add the files. add the 4 files and on one of the filenames when its done importing, right click and there is an option to "Query with SQL". i think thats how he got the data into 'Deepnote'.
This "Deepnote" tool seems very powerful and convenient 🤤
Very cool video. I like the real-time commentary/explanation. I'm just getting started and still basically don't understand much of what you're doing but very entertaining and useful nonetheless
You're awesome!
As a way of saying my thank you, i did not skip a single ad, that is to somehow contribute to you.
Thank you very much for sharing your knowledge, skill and experience! Much appreciated!
DeepNote seems like a right tool, checking it out tomorrow. thank you!!
Thank you Shashank Kalanith! I like these type of videos where you show the work....wish for more of these videos in the future.
Great video mate. I hope you make more similar like this one. Showing ways to solve problems and how to overcome them with small steps. Well done :)
You are Amazing I'm subscribing and joining this is exactly what I needed
Thank you. This video helped me decide my next move.
Ah not sure how I never saw this video but thanks for the actual insight to a potential day of a Data Analyst. I think too many videos show this very limited time working without the actuality of a day; of course not leaking a company's info is key but most videos seem a bit fairytail. Great work
I got demotivated while learning SQL now this gave me some hope to continue my course and complete ...
The only "Day in the life" where the person seems like they actually work at a real corporate job.
Love this kind of videos Shashank. So usefull and nicely explained. Thank you!
shashank you have done a great job !!! this really helps. i know you have very good set up but iam not sure why your audio is low or not so clear or may be its just because of room there is echo,. i couldn't hear you properly. just a small suggestion you may take care in the next videos.
The hardwork you put in your videos is amazing
Thanks Shashank, that really gives an insight of Data Analyst. appreciate it. much needed one :)
Sub’d! This is EXACTLY the content I’ve been looking for. Thank you so much! More please!
love these full walkthrough videos, thank you
Awesome video Shashank, A+ content as usual
The best DA Channel in yt by far
Thanks a ton!!!!
Omggg this is such an underrated vid on internet.
This guy is literally creating content that is actually insightful and informative.
Love your work
Thanks for the detailed analysis.
Would love to see more of these types of breakdowns! ðŸ‘ðŸ½
Doesn't character count introduce bias? eg 100 words in Chinese uses far fewer characters than 100 words of Spanish
Great consideration! We should segment it by language next time
awesome video!! more like this in the future please! so helpful â¤ï¸
Great content as alwaysðŸ‘ðŸ¼, I’m a super fan.
Btw, I think you’re the one who really deserve to give the incentives to by judging how much time and effort you’re putting into this, much appreciated.
See ya in the next live session.
Awesome video! But for the next video, please use some compression on the audio because it's vary a lot in volume! ;)
By later thought it was only in the intro, but it's a nice tip for later production
I'm a BI data analyst in Consulting, and SQL is a Must. I use it for ALL 😆🔥 (PostgreSQL)â¤ï¸
Great shashank ðŸ‘
Awesome work shashank !
really great content! btw Iol after seeing the simplified Chinese comment from the highest vote_helpful player
Soon as I head the zoom call ring I knew this shit was gonna be relatable lmao
Great video man!Thank you for intresting hour!
This videos are so helpful. I really say thank you :) (pls more videos from real life tasks)
That was great, if you could do more of these that would be awesome
THIS IS AWESOME THANK YOU!!!!
New to the channel here. I use Excel and reduce most of the coding reuqured for analysis. Sounds different but Ezcel has tools that I can use for analysis with just few clicks. As for visualizations I transfer it to PowerBI.
This video is such a gem! Thank you! 🥰
Want more of this kind of videos where we can follow along with you and get a chance work on some real world problems please!!!😇
Lovely format! Thanks!
Great Content
Thanks Shashank
But, but.... at what time do you wake up, go to work and hangout after work over?
Excellent video!
Please make a video of you presenting to a stakeholder.
awesome video. ı am looking forward to seeing these kind of videos more
100%, we'll be doing more of these going forward!
Excellent! Thank you Shashank.
Please could you tell me how are you using sql script and results displayed directly in the ipynb notebook without import pyodbc or other similar module?
This will be helpful for my work :-)
+1
2:41 "Also, happy hour today?"
The only part of this vid I can wholly relate to lol
Hi Shashank
Very interesting video!
I have been looking to make widgets and implement them on my website but have gotten a bit stuck.
It seems Deepnote is similar to Chart studio. I'd prefer though to go through my standard local Jupyter Notebook or Jupyter labs.
Another video suggested using HvPlot and Panels, but I don't see how to go from local implementation to using it on a webserver.
I think part of this stems from the fact that most tutorials stop before that step unfortunately and from me not really understanding how it works fundamentally - I'm not quite sure which part is made in HTML, java, and python.
I'm pretty sure HvPlot turns everything into Java though and from there I just need a way to go from the widget in the notebook to a website.
Nice insight. Do you plan on completing practical statistics for data science playlist?
@shashank Kalanithi I would like to know which environment or software were you using that allows you to use sql and Python
Can you please make a video on how to get a job in the US and how you got there.
I like how he's slightly sassy with himself.
Hey Shashank. Great work as always! The work that you just demonstrated here, would that be a mid-senior type of work or? Do you have any examples of what would have been an starting point data analyst type of work? Kind regards
need a vid of where you present for sure
nice informative video, the audio is really echo-y though
Great video!
All those coding you did in Python to manipulate the tables you pulled out from an SQL, can that not be done in Power Query and Power BI?
Python is faster for larger datasets
Hey, I love your videos, keep it up!
Quick question, what was the software you used at the beginning to type in your sql script snd have it displayed right under? It looks like Jupyter notebook?
Deepnote! There's a link to the notebook in the description
@@ShashankData thank you!!
I don't suppose have the code book for this data?
The Team's call sound scared me. Phew
Thank you for not showing videos of you eating and brushing your teeth! This has clarified a lot!
What is the shortcut to add quotation marks on a selection of text?
In most IDEs you just highlight the text and hit [SHIFT + ' ]. Most IDEs add pairs of brackets, or parentheses, or quotation marks
@@ShashankData Awesome, thank you!
Great video.. thank you
Hi Shashank....Could you please clarify the part....where in the dataframe num_games_owned .....you are using already filtered dataframe called top_reviewers_dataframe....and you are using group by steam_id and Selecting max of num_games_owned.....Is the use of max() function correct in this scenario?
Is there a link to the database for this? Would like to try it myself but the pinned comment link isn't working for me, just directs me to my own deepnote?
you're the best
hey
shashank
i miss your teaching tutorial
you're a very good teacher...starting teaching us again 😊
I'll have an R tutorial coming up soon :)
This is fucking gold!
The Chinese reviewer around 18:50, not a happy camper lol..Anyway thanks for this video! very interesting
Hey shashank! Amazing video like always. I am an entry level Machine Learning engineer. I wanted to know how I can practice this because I don't really know any source from where I can pull data out of a database and work with it.
Deepnote is how I practice generally. You can perform SQL on Pandas DataFrames so instead of using Python, I'll use SQL. Check out the pinned comment
This was amazing! What online courses do you recommend/ projects one can take on to learn more python? Currently I'm doing Google data analytics cert and got exposure to R. And I have some basic knowledge of python. Not enough to be dangerous tho
Thank you! That's awesome! Have you checked out the Python course I have on this channel?
Thanks
Only if all “bossmen†could articulate as well as yours.
Most Bossmen: here’s a shit ton of data, show me insights.
Me: uhhhhhhhh, question
"SQL up together" 😂
Wait! You said that you would my dashboard done today?
Nice😆
at 18:00 437 hours is not a lot of hours played!? What! LOL that's a lot of hours espcially if they be playing other games. That's 24/7 playing for 54 days straight.
What is the name of the ide??