Step by step process of thinking like a data analyst | How a data analyst thinks
Вставка
- Опубліковано 5 сер 2024
- In this video I will explain a step by step process of thinking like a data analyst. I and my friend Hemanand who is a data analyst manager did a little skit where I played a role of an owner of a software services company who is facing issues prioritizing clients and Hemanand played a role of a data analyst who is helping this company build a BI dashboard in power BI.
Do you want to learn technology from me? Check codebasics.io/ for my affordable video courses.
Hemanand's linkedin: / hemanand-vadivel-0b34aab5
🌎 Website: codebasics.io/
🎥 Codebasics Hindi channel: / @codebasicshindi
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.com/codebasics?fa...
❗❗ DISCLAIMER: All opinions expressed in this video are of my own and not that of my employers'.
Do you want to learn technology from me? Check codebasics.io/ for my affordable video courses.
Raw and basic conversations like these gives us so much idea, what actually goes through the data analyst thought process. Lectures are easily forgotten, but practicals are always remembered. Thanks a lot for sharing this video.
Thank to you I successfully switch from chemical engineering to data analyst just now I got offer from one compny based in banglore
Share Your Skillset and Portfolio details
Share your LinkedIn profile
What all skills you acquired for this ?
Which company bro?
@@rakeshb7378 Insure pro 2.0
Hi, Could you make a Part 2 and part 3 for this video. Part 2 - Data Analysis report making. Part 3 - Presentation discussion final result with the owner / stakeholder.
This is one of the Best Sir that you know the really business basics and you go really really deep into it..
One Thing Customer Pain Index you can call it Customer Denscity Index this is what I feel..
Key Points:-
Revenue
Profitibilty
Customer Pain Index/ Customer Dencity Index
Customer Retaintion Index
Customer vs Time in Comparion of Revenue/ Client Growth Rate
Employee Satifacation Index vs Customer Expectation Index Something LIke That you can indculed too...
Thanks for such a helpful video! So important to clearly understand our client's requirements and break down each of the tasks to get a good understanding of the problem. Afterwards, we can look at their database and all the data sources involved. Once everything is connected to Power BI, we can develop the dashboards.
What an amazingly insightful video! 👌. It's great to see the way he came up with the solutions step by step, breaking down the problem into manageable chunks!
great way to deal with client & understand business..
basically i like that logic of giving weight to perticular columns like profitability & revenue..
2 : your business depends on customer business /revenue hence considering the customer business / revenue status aslo good idea..
3 : also knowing the preference of client wrt sliver , golden & diamond Also important whoch will help us to set classification matrix..
( i think we can use precision/sensitivity here ) so that diamond customer should not be predicted as silver , otherwise it'll be a big loss.
4 : we can add no of products customer is selling to get an idea about customer business
5 : Employees satisfaction index : really nice feature ( employees satisfaction proportional to cust_business & also proportional to your business )..
very nice video sir 🙏❤️.
Nice summary Dragon
Recently I gave a data science assessment for a company . I didnt went well because i was not able to do much with the data. but after listening to this video. I figured out what i could do much better and I came to know that was the most important thing I could have figured out. Classification of customers.
Thank you sir for this.
Thank you sir, because of your DSA playlist I was able to crack the interview. hence I got my job as a Data Scientist. As an fresher
Excellent! Congratulations
Just a question, you got a Data Scientist job after cracking an interview which focussed deeply on Data Structures and Algorithms? That's something weird, please feel free to clarify. 😅
@@anonymouslyawesome8125data structures and algorithm was one of the part of interview. It had a weightage of around 20%. Other parts include python, statistics, probability, SQL and obvious ML. So I prepared DS Algo from this channel.
@@GhostRider-uu6oh Awesome, congratulations!
@@anonymouslyawesome8125 Thank You
Thank you so much for this amazing session ...... Eagerly waiting for next approach :)
This was really insightful. After watching this video I realised what it really means to understand business interests.
This is an awesome video, you are doing a great job educating and sharing knowledge. You are doing a real wonderful work. God bless you and give you more prosperity and good blessings.
Thank you very much!
Hemanand and you did an excellent job.
Thanks for this highly informative insightful video.
💜👑
Learning a lot from you and your recommendations, thank you very much!
This is very helpful it gives real time view of a data analyst thinking perspective. Thanks for bringing this into our viewerships. Can you please do same way for data engineer and data scientist perspectives
such a amazing video...! that Data analyst is so talented...Great initiative dhaval..
Much Needed......🤩🤩🤩
wonderful, super wonderful..
GREAT WORK!! NEED MORE SUCH KIND OF VIDEOS.
Thank you so muchhh for this! 😍
Outstanding irl video. Loved it!
Thanks for this amazing videos,soo helpful
This thing was amazing 😀😀
Waiting for it❤️❤️❤️
Extremely insightful video... 🙏🏻
Great. Thank you !
This video is absolutely amaazing! Lots of great knowledge and information being shared. Will there be a part 2 of this discussion??? it would be interesting to see actual results of this exercise if possible.
Exactly
This brainstorming session was mind blowing. Thanks for the video.
Glad it helped
Sir this is the one video we need to think.like data analysts,but can you make such projects on other domains like this is the case of a software service firm, please cover any other industry as well
Great video
Mindblowing session❤
Spend 1.5 hour on this video.really valuable video.
Waiting for this......
Excellent job. Very neat insight into the problem and good data mining. Very useful for me to understand the problem better. Thank you for such a useful program
Glad it helped
Once again with a powerful content
Thanks a lot
Could you please put some light on, should one be domain specific and if how to be ...
Pros n cons of starting as a freelancer.
Instead of pain index, we can opt-out for customer health index or customer pleasure index
"Customer Adaptability Index" might sound better. :D Just kidding. Thank you for helping us out through your videos!
How a project cost is calculated in real world?
Pls make a video on it dhaval sir.
@codebasics
Great video. Very insightful. Thanks for this
Glad it was helpful!
Make videos about projects include in resume for data analyst role
@Codebasics please bring series on SQL tutorial for beginners
Point noted. However there are many good SQL tutorial out there. Khan academy has good SQL beginner tutorial and that too for free.
awesome video sir
☺️👍
Sir , it is enough to learn all tutorials from your channel to become a data scientist
No bro
*This is priceless!!*
*can you do a similar video for data engineer and data scientist roles??*
yes I will note down that suggestion
Sir please also upload course on your hindi channel
I am pursuing data analytics program. I am busniess statistics course. Please make series for statistics
Bro, is this possible to switch career after 15 years to data analyst and I am from autocad drafting....
Thank you sir for the wonderful video, well explained. Sir you can name pain index as customer satisfaction index
Customer satisfaction index is to indicate how satisfied a customer is with AtliQ's business. This is the other way, i.e. how satisfied AtliQ is with particular customer.
Yesss!
Hey! are you also learning power BI?
Upto what age companies will hire for data anylist position sir.
Sir could you please make video on step by step to get a data science intership?
Sir what is etl hw its carried out do i need to learn any other tool apart from ur suggested roadmap for analyst? If so pls let me know.
I have a video on that. In youtube search "codebasics what is ETL"
Sir now we want this project as Data Analyst Project .All Banked Programing .
Sir can you please make a video on the business case study rounds like how to expand market base of a company or active subscriber of ott platforms . Case study Questions asked in Hotstar interview rounds for eg.
Point noted. Let me think about this
Sir please tell us machine learning algorithm are needed for data analyst or SQL,python,excel,powerbi is infough
For a Data Analyst, you will have to be very comfortable to work with Data right from cleaning, transforming, analyzing, visualizing it. Be familiar with SQL, excel, tableau/power bi, pandas, numpy, matplotlib. Little bit of ML algorithms knowledge is fine.
Sir can you please make video on "Road map for Data Engineer".
It is available on his channel
@@jayantparmar8549 Thanks buddy👍
Hello sir , I hope you will reply
Sir, I’m 40,, homemaker, MCom and pgdba finance
Approx 1 year experience that’s too bfr 9 years.
I was always a bright student but couldn’t pursue my career.
What I ve is a burning desire to achieve something in my life
I’m learning python from ur channel and eventually wants to join data science field
Sir plz suggest should I continue on this path avoiding all the negative voices that erupt in my head time to time
Can I achieve success in this field
As I’m a no programmer , ve non technical background
And top of that age barrier
Please sir I really need ur guidance.
Hii sir I am mechanical bachelors degree holder and I am learning data science in an institution .My question is if I ought to do masters in US universities which field might me more appealing which relates data science?
For doing masters in USA, it is preferred you go for computer science. If you go for data analytics course you will most likely have issues finding a job that will sponsor your h1b. hence going for a generalized computer science course where there are tons of jobs and also employers are willing to file h1b will be more appropriate. You can select few data analytics subjects and later on become a data scientist even with CS degree
Customer FAVOURIBILITY is also something you could use
Good suggestion
without btech degree or graduation can I become data scientist and I have cs diploma
yes of course you can.
@@codebasics thanx for your suggestions sir
Sir How I start to learn DATA ANALYST skills.. any certificate require for job. If yes so how to get certificate of DATA ANALYST .. I am from Delhi and preparing for GOVT JOB but still Unemployed please help me for my bright future please
U r not replying to my comments and on the other hand u made a video on a question asked by a gurl. Not fair sir.
Please donate for this Video 🙏
Hi sir can you give me a shout out please am also programmer who makes apps , games and websites.