Step by step process of thinking like a data analyst | How a data analyst thinks
Рет қаралды 41,430
Күн бұрын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'.
@codebasics 2 жыл бұрын
Do you want to learn technology from me? Check codebasics.io/ for my affordable video courses.
@vedanttele5187 2 жыл бұрын
Thank to you I successfully switch from chemical engineering to data analyst just now I got offer from one compny based in banglore
@aloneluvr5469 2 жыл бұрын
Share Your Skillset and Portfolio details
@bibekpaul1054 2 жыл бұрын
Share your LinkedIn profile
@tanviikhar8655 2 жыл бұрын
What all skills you acquired for this ?
@rakeshb7378 2 жыл бұрын
Which company bro?
@vedanttele5187 2 жыл бұрын
@@rakeshb7378 Insure pro 2.0
@shrutiuday2055 Жыл бұрын
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.
@GhostRider-uu6oh 2 жыл бұрын
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
@codebasics 2 жыл бұрын
Excellent! Congratulations
@anonymouslyawesome8125 2 жыл бұрын
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. 😅
@GhostRider-uu6oh 2 жыл бұрын
@@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.
@anonymouslyawesome8125 2 жыл бұрын
@@GhostRider-uu6oh Awesome, congratulations!
@GhostRider-uu6oh 2 жыл бұрын
@@anonymouslyawesome8125 Thank You
@gonzalosanchez401 2 жыл бұрын
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.
@datascientistoflife8550 2 жыл бұрын
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...
@bestlife8026 2 жыл бұрын
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.
@HariPrasad-ox5ri 2 жыл бұрын
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!
@redroom07 2 жыл бұрын
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 🙏❤️.
@codebasics 2 жыл бұрын
Nice summary Dragon
@shashipaul6279 2 жыл бұрын
Thank you so much for this amazing session ...... Eagerly waiting for next approach :)
@eshabahal 2 жыл бұрын
This was really insightful. After watching this video I realised what it really means to understand business interests.
@shantanuraj7086 2 жыл бұрын
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.
@codebasics 2 жыл бұрын
Thank you very much!
@sanghmitrasisodiyacovers Жыл бұрын
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.
@thereawakening3170 2 жыл бұрын
wonderful, super wonderful..
@bhubannayak6155 2 жыл бұрын
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
@cinthiacicilio 2 жыл бұрын
Learning a lot from you and your recommendations, thank you very much!
@pavankalyan_297 2 жыл бұрын
Much Needed......🤩🤩🤩
@girishamanocha3636 2 жыл бұрын
Thank you so muchhh for this! 😍
@lego-xq4fh 2 жыл бұрын
Hemanand and you did an excellent job. Thanks for this highly informative insightful video. 💜👑
@Vishwas997 2 жыл бұрын
This thing was amazing 😀😀
@devotionaleventschannel5551 2 жыл бұрын
GREAT WORK!! NEED MORE SUCH KIND OF VIDEOS.
@ashishakatsuki137 2 жыл бұрын
Great video
@DineshKumarM6689 2 жыл бұрын
Thanks for this amazing videos,soo helpful
@imdadulhaque9757 2 жыл бұрын
Waiting for it❤️❤️❤️
@ephraimmotho887 Жыл бұрын
Outstanding irl video. Loved it!
@dan.6398 7 ай бұрын
Great. Thank you !
@shubhambhavsar4953 Жыл бұрын
such a amazing video...! that Data analyst is so talented...Great initiative dhaval..
@karthikbs8749 2 жыл бұрын
This brainstorming session was mind blowing. Thanks for the video.
@codebasics 2 жыл бұрын
Glad it helped
@maheshchavan1724 2 жыл бұрын
Waiting for this......
@piyushpaikroy3579 2 жыл бұрын
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
@kushagrgoyal9614 2 жыл бұрын
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.
@lego-xq4fh 2 жыл бұрын
Exactly
@RGMUTEX 9 ай бұрын
Mindblowing session❤
@Indica2658 Жыл бұрын
Extremely insightful video... 🙏🏻
@harikrishna-nn7do 2 жыл бұрын
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
@codebasics 2 жыл бұрын
Glad it helped
@Kumar-Prabhat 2 жыл бұрын
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.
@asifmostafa2551 11 ай бұрын
Spend 1.5 hour on this video.really valuable video.
@umashankarv3958 2 жыл бұрын
Instead of pain index, we can opt-out for customer health index or customer pleasure index
@mzgoochee 2 жыл бұрын
Great video. Very insightful. Thanks for this
@codebasics 2 жыл бұрын
Glad it was helpful!
@sebijohn5628 2 жыл бұрын
"Customer Adaptability Index" might sound better. :D Just kidding. Thank you for helping us out through your videos!
@GujjuRakshit 2 жыл бұрын
How a project cost is calculated in real world? Pls make a video on it dhaval sir. @codebasics
@khushichaudharysart275 2 жыл бұрын
awesome video sir
@codebasics 2 жыл бұрын
☺️👍
@hvchetan1 2 жыл бұрын
@Codebasics please bring series on SQL tutorial for beginners
@codebasics 2 жыл бұрын
Point noted. However there are many good SQL tutorial out there. Khan academy has good SQL beginner tutorial and that too for free.
@manikhandanj5681 2 жыл бұрын
Make videos about projects include in resume for data analyst role
@raghavendranarayana2226 2 жыл бұрын
Sir , it is enough to learn all tutorials from your channel to become a data scientist
@sourabhbhatt5170 2 жыл бұрын
No bro
@kumarsantosh4978 2 жыл бұрын
Upto what age companies will hire for data anylist position sir.
@adityams1659 2 жыл бұрын
*This is priceless!!* *can you do a similar video for data engineer and data scientist roles??*
@codebasics 2 жыл бұрын
yes I will note down that suggestion
@mohamedmustafa7275 2 жыл бұрын
Bro, is this possible to switch career after 15 years to data analyst and I am from autocad drafting....
@vishalmane3139 2 жыл бұрын
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.
@codebasics 2 жыл бұрын
I have a video on that. In youtube search "codebasics what is ETL"
@mangurk 2 жыл бұрын
Thank you sir for the wonderful video, well explained. Sir you can name pain index as customer satisfaction index
@codebasics 2 жыл бұрын
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.
@miiihiir 2 жыл бұрын
Yesss! Hey! are you also learning power BI?
@nainisayn9872 2 жыл бұрын
Sir please also upload course on your hindi channel
@RupinderKaur-el2rb 2 жыл бұрын
I am pursuing data analytics program. I am busniess statistics course. Please make series for statistics
@sameerulhaq4066 2 жыл бұрын
Sir could you please make video on step by step to get a data science intership?
@adzinja6574 2 жыл бұрын
Sir please tell us machine learning algorithm are needed for data analyst or SQL,python,excel,powerbi is infough
@saianuragneelisetty4548 2 жыл бұрын
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.
@prasannavidhale2949 2 жыл бұрын
Sir now we want this project as Data Analyst Project .All Banked Programing .
@shambhavi_mj 2 жыл бұрын
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.
@codebasics 2 жыл бұрын
Point noted. Let me think about this
@maheshchavan1724 2 жыл бұрын
Sir can you please make video on "Road map for Data Engineer".
@jayantparmar8549 2 жыл бұрын
It is available on his channel
@maheshchavan1724 2 жыл бұрын
@@jayantparmar8549 Thanks buddy👍
@santhoshr8943 2 жыл бұрын
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?
@codebasics 2 жыл бұрын
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
@A12157 2 жыл бұрын
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.
@lolhead7127 2 жыл бұрын
Customer FAVOURIBILITY is also something you could use
@codebasics 2 жыл бұрын
Good suggestion
@dhirendrasingh5637 2 жыл бұрын
without btech degree or graduation can I become data scientist and I have cs diploma
@codebasics 2 жыл бұрын
yes of course you can.
@dhirendrasingh5637 2 жыл бұрын
@@codebasics thanx for your suggestions sir
@ankushrajput9600 2 жыл бұрын
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
@OMMI100m 2 жыл бұрын
Please donate for this Video 🙏
@sourabhbhatt5170 2 жыл бұрын
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.
@ProgrammerDevelops 2 жыл бұрын
Hi sir can you give me a shout out please am also programmer who makes apps , games and websites.
Talentele Learning
Рет қаралды 196 М.