Day in the Life of a Data Analyst: Stakeholder ➡️ Co-Worker ➡️ SQL ➡️ Python ➡️ Visualizations
Вставка
- Опубліковано 27 чер 2022
- 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.masterschool.com/h7fean
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.
I love how you are able to capture the actual tasks! Definitely a valuable content here in UA-cam! Keep it up, Shashank!
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!
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.
5 minutes into this video and I already love it. Awesome video Shashank.
Love this kind of videos Shashank. So usefull and nicely explained. Thank you!
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.
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 !!!
love these full walkthrough videos, thank you
Dude, this type of video is the one that hooked me up to your channel as subscriber! Loved it!
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 :)
Sub’d! This is EXACTLY the content I’ve been looking for. Thank you so much! More please!
You have no idea how insightful this video is. Thank you.
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'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!
You scared me with the Teams Call audio at the beginning.
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.
Awesome work shashank !
awesome video!! more like this in the future please! so helpful ❤️
Thank you Shashank Kalanith! I like these type of videos where you show the work....wish for more of these videos in the future.
Lovely format! Thanks!
Thanks for the detailed analysis.
Thanks Shashank, that really gives an insight of Data Analyst. appreciate it. much needed one :)
DeepNote seems like a right tool, checking it out tomorrow. thank you!!
Great shashank 👍
The hardwork you put in your videos is amazing
Great video man!Thank you for intresting hour!
You are Amazing I'm subscribing and joining this is exactly what I needed
This was fantastic, thank you! A video of how to navigate with the ambiguity of stakeholders would be super helpful!!
Excellent video!
Great Content
Thanks Shashank
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
Thank you. This video helped me decide my next move.
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
THIS IS AWESOME THANK YOU!!!!
This video is such a gem! Thank you! 🥰
Awesome video Shashank, A+ content as usual
The best DA Channel in yt by far
Thanks a ton!!!!
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!
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.
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.
That was great, if you could do more of these that would be awesome
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?
I got demotivated while learning SQL now this gave me some hope to continue my course and complete ...
You are literally the best data analyst channel on UA-cam
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.
This videos are so helpful. I really say thank you :) (pls more videos from real life tasks)
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.
Great video.. thank you
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
Would love to see more of these types of breakdowns! 👍🏽
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
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
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.
awesome video. ı am looking forward to seeing these kind of videos more
100%, we'll be doing more of these going forward!
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?
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.
you're the best
Nice insight. Do you plan on completing practical statistics for data science playlist?
This is fucking gold!
The only "Day in the life" where the person seems like they actually work at a real corporate job.
I'm a BI data analyst in Consulting, and SQL is a Must. I use it for ALL 😆🔥 (PostgreSQL)❤️
Omggg this is such an underrated vid on internet.
This guy is literally creating content that is actually insightful and informative.
Love your work
really great content! btw Iol after seeing the simplified Chinese comment from the highest vote_helpful player
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
Please make a video of you presenting to a stakeholder.
need a vid of where you present for sure
2:41 "Also, happy hour today?"
The only part of this vid I can wholly relate to lol
Thanks
Soon as I head the zoom call ring I knew this shit was gonna be relatable lmao
I don't suppose have the code book for this data?
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!!!😇
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 🤤
Nice😆
@shashank Kalanithi I would like to know which environment or software were you using that allows you to use sql and Python
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?
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?
Can you please make a video on how to get a job in the US and how you got there.
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
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?
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!!
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
I like how he's slightly sassy with himself.
nice informative video, the audio is really echo-y though
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
The Team's call sound scared me. Phew
The Chinese reviewer around 18:50, not a happy camper lol..Anyway thanks for this video! very interesting
What took were you using the SQL?
But, but.... at what time do you wake up, go to work and hangout after work over?
Wait! You said that you would my dashboard done today?
This is awesome 👏🏾
You misspelled seaborn?
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 :)
What is the name of the ide??
"SQL up together" 😂
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!