Day in the Life of a Data Analyst: Stakeholder ➡️ Co-Worker ➡️ SQL ➡️ Python ➡️ Visualizations

[@ShashankData]

Check out Deepnote using this link: deepnote.com/?

[@analyticalmindset]

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.

[@Redneck2020]

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?

[@waeeeezeeeee]

for real !!!

[@zulkhaireesulaiman8575]

This this this!!!

[@analyticalmindset]

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

[@IQuickscopeCA]

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

[@BabyfaceGaming101]

Yeah, I keep seeing day in the life videos and it is about their meeting times and lunch breaks...🤦

[@bl8413]

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

[@ShashankData]

I’m super happy to hear that! That’s the exact point of these videos

[@Limestarz]

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.

[@briskwinterair]

i’m in grad school right now for analytics and none of the curriculum goes in-depth with SQL so i feel ya

[@anaskhan4405]

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.

[@jojox6145]

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.

[@joycegemcanete7217]

I love how you are able to capture the actual tasks! Definitely a valuable content here in KZbin! Keep it up, Shashank!

[@Boomk27]

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 !!!

[@ahmedmohiuddin1866]

5 minutes into this video and I already love it. Awesome video Shashank.

[@specialbeamz]

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.

[@javierbustamante393]

This was fantastic, thank you! A video of how to navigate with the ambiguity of stakeholders would be super helpful!!

[@Dancostin1990]

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 :)

[@Trazynn]

And those videos usually only show them sitting in meetings and checking email in between all the food and gym.

[@adityaariewijaya9284]

Dude, this type of video is the one that hooked me up to your channel as subscriber! Loved it!

[@j192002]

You will be my instructor in master school this coming 2 weeks, very excited and ready to start a new career!

[@ShashankData]

Super excited to have you on!

[@lilromain101]

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.

[@akashaman7]

You have no idea how insightful this video is. Thank you.

[@BabyfaceGaming101]

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...

[@wendy_113]

You are Amazing I'm subscribing and joining this is exactly what I needed

[@RunOs3]

Thank you. This video helped me decide my next move.

[@SophiaYangDS]

Love the very realistic a day in life video! 🙌 And the intro is so much fun. Great job!

[@bcak611]

DeepNote seems like a right tool, checking it out tomorrow. thank you!!

[@shaktibiswal5761]

Thanks for the detailed analysis.

[@PicklePops]

THIS IS AWESOME THANK YOU!!!!

[@saichander4337]

Thanks Shashank, that really gives an insight of Data Analyst. appreciate it. much needed one :)

[@irvingpurata2939]

Its was great to see real work presented. Please share a video on how you would pressent to stake holder. Thanks a million

[@nationhlohlomi9333]

The hardwork you put in your videos is amazing

[@SabongHobbyist01]

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!

[@yashadmuthe9285]

Awesome work shashank !

[@Codemanlex]

You are literally the best data analyst channel on KZbin I love how you show what you do This video just made me realize I've been doing well with my projects

[@shashank7260]

Yes you are right. I was also glad that i can relate my projects with the actual tasks in job.

[@Gozgozia]

Love this kind of videos Shashank. So usefull and nicely explained. Thank you!

[@gama218]

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 :)

[@beautyofthailand7393]

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

[@keylanoslokj1806]

So what's your point? Ask more questions to understand the requests better?

[@paulbuono5088]

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

[@kevidimitrisceci8096]

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 :)

[@RS-chino]

Sub’d! This is EXACTLY the content I’ve been looking for. Thank you so much! More please!

[@debayandas1128]

You scared me with the Teams Call audio at the beginning.

[@HobbitFamily]

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.

[@Arqade8]

Thank you Shashank Kalanith! I like these type of videos where you show the work....wish for more of these videos in the future.

[@deeppatel0927]

Great shashank 👍

[@N3v3rm1nd91]

The only "Day in the life" where the person seems like they actually work at a real corporate job.

[@yashvarshney8651]

Lovely format! Thanks!

[@daniii6169]

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?

[@ramaraju4621]

I got demotivated while learning SQL now this gave me some hope to continue my course and complete ...

[@sinnersandsapphics]

love these full walkthrough videos, thank you

[@alainj1]

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

[@aakritichoudhary2211]

This video is such a gem! Thank you! 🥰

[@badisheffey4550]

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!!

[@DanielAbeka]

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'.

[@nicbajito]

This "Deepnote" tool seems very powerful and convenient 🤤

[@notta3d]

Excellent video!

[@viniciusguedes6715]

Awesome video Shashank, A+ content as usual The best DA Channel in yt by far

[@ShashankData]

Thanks a ton!!!!

Great video man!Thank you for intresting hour!

[@nomad__raj]

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

[@michieem21]

awesome video!! more like this in the future please! so helpful ❤️

[@KG-lr2qw]

Doesn't character count introduce bias? eg 100 words in Chinese uses far fewer characters than 100 words of Spanish

[@ShashankData]

Great consideration! We should segment it by language next time

[@kronic254]

That was great, if you could do more of these that would be awesome

[@YavuzDurden]

This videos are so helpful. I really say thank you :) (pls more videos from real life tasks)

[@eyyupyavuz2769]

awesome video. ı am looking forward to seeing these kind of videos more

[@ShashankData]

100%, we'll be doing more of these going forward!

[@rahulrd2713]

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.

[@AkshayKumar-vd5wn]

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.

[@nellypokam6737]

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 :-)

[@muhammedhashir8157]

+1

[@parkshermoso1012]

Soon as I head the zoom call ring I knew this shit was gonna be relatable lmao

[@evedickson2496]

Great video.. thank you

[@halowaffles]

2:41 "Also, happy hour today?" The only part of this vid I can wholly relate to lol

[@osmaryguevara9604]

I'm a BI data analyst in Consulting, and SQL is a Must. I use it for ALL 😆🔥 (PostgreSQL)❤️

[@MrComa119]

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?

[@ShashankData]

Deepnote! There's a link to the notebook in the description

[@MrComa119]

@@ShashankData thank you!!

[@zhengyanlin2844]

really great content! btw Iol after seeing the simplified Chinese comment from the highest vote_helpful player

[@Griffindor21]

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?

[@ixternal9295]

Python is faster for larger datasets

[@simenandreasknudsen9272]

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

[@CaribouDataScience]

I don't suppose have the code book for this data?

[@pyg9466]

Please make a video of you presenting to a stakeholder.

[@lynju_]

need a vid of where you present for sure

[@Millio_4_reallio]

Would love to see more of these types of breakdowns! 👍🏽

[@_nic_senpai]

@shashank Kalanithi I would like to know which environment or software were you using that allows you to use sql and Python

[@SenorJonathan14]

What is the shortcut to add quotation marks on a selection of text?

[@ShashankData]

In most IDEs you just highlight the text and hit [SHIFT + ' ]. Most IDEs add pairs of brackets, or parentheses, or quotation marks

[@SenorJonathan14]

@@ShashankData Awesome, thank you!

[@Levy957]

you're the best

[@Try_Hard_Dad]

I like how he's slightly sassy with himself.

[@Josh.Edwards]

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?

[@nayeem3905]

Nice insight. Do you plan on completing practical statistics for data science playlist?

[@jacobhenry9028]

This is fucking gold!

[@suyashghadi2014]

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?

[@luduvugla]

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

[@heemoad474]

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.

[@ushnakhan198]

Omggg this is such an underrated vid on internet. This guy is literally creating content that is actually insightful and informative. Love your work

[@errolm8313]

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

[@ShashankData]

Thank you! That's awesome! Have you checked out the Python course I have on this channel?

[@Limestarz]

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.

[@AashishKumar-wq2bw]

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!!!😇

[@mustafakamal8608]

But, but.... at what time do you wake up, go to work and hangout after work over?

[@utica2burn]

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.

[@robinjerry5592]

Nice😆

[@davidlopez-fe2lb]

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

[@ishandandekar1808]

"SQL up together" 😂

[@k.kavinbarathi9773]

Can you please make a video on how to get a job in the US and how you got there.

[@christopherlo9446]

nice informative video, the audio is really echo-y though

[@MambaM3ntality]

Thanks

[@riya-7771]

hey shashank i miss your teaching tutorial you're a very good teacher...starting teaching us again 😊

[@ShashankData]

I'll have an R tutorial coming up soon :)

[@amankumarjaiswar7321]

What is the name of the ide??

[@neelabhsomani5129]

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.

[@ShashankData]

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

[@DJ_Gallow]

The Chinese reviewer around 18:50, not a happy camper lol..Anyway thanks for this video! very interesting

[@hellfire8535]

The Team's call sound scared me. Phew

[@dendrite44]

Thank you for not showing videos of you eating and brushing your teeth! This has clarified a lot!

[@have2148]

44:56 One of the simplified Chinese comments says that he is attracted by 2B's butt from Nier LOL

[@AlanTheAnalyst]

“SQL it up for me” 😂😂