Step by step process of thinking like a data analyst | How a data analyst thinks

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

Пікірлер: 100

  • @codebasics
    @codebasics2 жыл бұрын

    Do you want to learn technology from me? Check codebasics.io/ for my affordable video courses.

  • @vedanttele5187
    @vedanttele51872 жыл бұрын

    Thank to you I successfully switch from chemical engineering to data analyst just now I got offer from one compny based in banglore

  • @aloneluvr5469

    @aloneluvr5469

    2 жыл бұрын

    Share Your Skillset and Portfolio details

  • @bibekpaul1054

    @bibekpaul1054

    2 жыл бұрын

    Share your LinkedIn profile

  • @tanviikhar8655

    @tanviikhar8655

    2 жыл бұрын

    What all skills you acquired for this ?

  • @rakeshb7378

    @rakeshb7378

    2 жыл бұрын

    Which company bro?

  • @vedanttele5187

    @vedanttele5187

    2 жыл бұрын

    @@rakeshb7378 Insure pro 2.0

  • @datascientistoflife8550
    @datascientistoflife85502 жыл бұрын

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

  • @shrutiuday2055
    @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.

  • @redroom07
    @redroom072 жыл бұрын

    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

    @codebasics

    2 жыл бұрын

    Nice summary Dragon

  • @GhostRider-uu6oh
    @GhostRider-uu6oh2 жыл бұрын

    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

    @codebasics

    2 жыл бұрын

    Excellent! Congratulations

  • @anonymouslyawesome8125

    @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

    @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

    @anonymouslyawesome8125

    2 жыл бұрын

    @@GhostRider-uu6oh Awesome, congratulations!

  • @GhostRider-uu6oh

    @GhostRider-uu6oh

    2 жыл бұрын

    @@anonymouslyawesome8125 Thank You

  • @gonzalosanchez401
    @gonzalosanchez4012 жыл бұрын

    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.

  • @HariPrasad-ox5ri
    @HariPrasad-ox5ri2 жыл бұрын

    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!

  • @bestlife8026
    @bestlife80262 жыл бұрын

    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.

  • @shantanuraj7086
    @shantanuraj70862 жыл бұрын

    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

    @codebasics

    2 жыл бұрын

    Thank you very much!

  • @shashipaul6279
    @shashipaul62792 жыл бұрын

    Thank you so much for this amazing session ...... Eagerly waiting for next approach :)

  • @bhubannayak6155
    @bhubannayak61552 жыл бұрын

    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

  • @eshabahal
    @eshabahal2 жыл бұрын

    This was really insightful. After watching this video I realised what it really means to understand business interests.

  • @cinthiacicilio
    @cinthiacicilio2 жыл бұрын

    Learning a lot from you and your recommendations, thank you very much!

  • @lego-xq4fh
    @lego-xq4fh Жыл бұрын

    Hemanand and you did an excellent job. Thanks for this highly informative insightful video. 💜👑

  • @kushagrgoyal9614
    @kushagrgoyal96142 жыл бұрын

    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

    @lego-xq4fh

    Жыл бұрын

    Exactly

  • @sanghmitrasisodiyacovers
    @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.

  • @shubhambhavsar4953
    @shubhambhavsar4953 Жыл бұрын

    such a amazing video...! that Data analyst is so talented...Great initiative dhaval..

  • @karthikbs8749
    @karthikbs87492 жыл бұрын

    This brainstorming session was mind blowing. Thanks for the video.

  • @codebasics

    @codebasics

    2 жыл бұрын

    Glad it helped

  • @pavankalyan_297
    @pavankalyan_2972 жыл бұрын

    Much Needed......🤩🤩🤩

  • @piyushpaikroy3579
    @piyushpaikroy35792 жыл бұрын

    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

  • @thereawakening3170
    @thereawakening31702 жыл бұрын

    wonderful, super wonderful..

  • @DineshKumarM6689
    @DineshKumarM66892 жыл бұрын

    Thanks for this amazing videos,soo helpful

  • @Indica2658
    @Indica2658 Жыл бұрын

    Extremely insightful video... 🙏🏻

  • @harikrishna-nn7do
    @harikrishna-nn7do2 жыл бұрын

    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

    @codebasics

    2 жыл бұрын

    Glad it helped

  • @devotionaleventschannel5551
    @devotionaleventschannel55512 жыл бұрын

    GREAT WORK!! NEED MORE SUCH KIND OF VIDEOS.

  • @ephraimmotho887
    @ephraimmotho887 Жыл бұрын

    Outstanding irl video. Loved it!

  • @girishamanocha3636
    @girishamanocha36362 жыл бұрын

    Thank you so muchhh for this! 😍

  • @Vishwas997
    @Vishwas9972 жыл бұрын

    This thing was amazing 😀😀

  • @asifmostafa2551
    @asifmostafa255110 ай бұрын

    Spend 1.5 hour on this video.really valuable video.

  • @imdadulhaque9757
    @imdadulhaque97572 жыл бұрын

    Waiting for it❤️❤️❤️

  • @Kumar-Prabhat
    @Kumar-Prabhat2 жыл бұрын

    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.

  • @umashankarv3958
    @umashankarv39582 жыл бұрын

    Instead of pain index, we can opt-out for customer health index or customer pleasure index

  • @dan.6398
    @dan.63986 ай бұрын

    Great. Thank you !

  • @ashishakatsuki137
    @ashishakatsuki1372 жыл бұрын

    Great video

  • @maheshchavan1724
    @maheshchavan17242 жыл бұрын

    Waiting for this......

  • @RGMUTEX
    @RGMUTEX8 ай бұрын

    Mindblowing session❤

  • @GujjuRakshit
    @GujjuRakshit2 жыл бұрын

    How a project cost is calculated in real world? Pls make a video on it dhaval sir. @codebasics

  • @hvchetan1
    @hvchetan12 жыл бұрын

    @Codebasics please bring series on SQL tutorial for beginners

  • @codebasics

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

  • @raghavendranarayana2226
    @raghavendranarayana22262 жыл бұрын

    Sir , it is enough to learn all tutorials from your channel to become a data scientist

  • @sourabhbhatt5170

    @sourabhbhatt5170

    2 жыл бұрын

    No bro

  • @manikhandanj5681
    @manikhandanj56812 жыл бұрын

    Make videos about projects include in resume for data analyst role

  • @sebijohn5628
    @sebijohn56282 жыл бұрын

    "Customer Adaptability Index" might sound better. :D Just kidding. Thank you for helping us out through your videos!

  • @mzgoochee
    @mzgoochee2 жыл бұрын

    Great video. Very insightful. Thanks for this

  • @codebasics

    @codebasics

    2 жыл бұрын

    Glad it was helpful!

  • @sameerulhaq4066
    @sameerulhaq40662 жыл бұрын

    Sir could you please make video on step by step to get a data science intership?

  • @adityams1659
    @adityams16592 жыл бұрын

    *This is priceless!!* *can you do a similar video for data engineer and data scientist roles??*

  • @codebasics

    @codebasics

    2 жыл бұрын

    yes I will note down that suggestion

  • @mangurk
    @mangurk2 жыл бұрын

    Thank you sir for the wonderful video, well explained. Sir you can name pain index as customer satisfaction index

  • @codebasics

    @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

    @miiihiir

    2 жыл бұрын

    Yesss! Hey! are you also learning power BI?

  • @nainisayn9872
    @nainisayn98722 жыл бұрын

    Sir please also upload course on your hindi channel

  • @RupinderKaur-el2rb
    @RupinderKaur-el2rb2 жыл бұрын

    I am pursuing data analytics program. I am busniess statistics course. Please make series for statistics

  • @prasannavidhale2949
    @prasannavidhale29492 жыл бұрын

    Sir now we want this project as Data Analyst Project .All Banked Programing .

  • @khushichaudharysart275
    @khushichaudharysart2752 жыл бұрын

    awesome video sir

  • @codebasics

    @codebasics

    2 жыл бұрын

    ☺️👍

  • @shambhavi_mj
    @shambhavi_mj2 жыл бұрын

    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

    @codebasics

    2 жыл бұрын

    Point noted. Let me think about this

  • @vishalmane3139
    @vishalmane31392 жыл бұрын

    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

    @codebasics

    2 жыл бұрын

    I have a video on that. In youtube search "codebasics what is ETL"

  • @kumarsantosh4978
    @kumarsantosh49782 жыл бұрын

    Upto what age companies will hire for data anylist position sir.

  • @mohamedmustafa7275
    @mohamedmustafa72752 жыл бұрын

    Bro, is this possible to switch career after 15 years to data analyst and I am from autocad drafting....

  • @maheshchavan1724
    @maheshchavan17242 жыл бұрын

    Sir can you please make video on "Road map for Data Engineer".

  • @jayantparmar8549

    @jayantparmar8549

    2 жыл бұрын

    It is available on his channel

  • @maheshchavan1724

    @maheshchavan1724

    2 жыл бұрын

    @@jayantparmar8549 Thanks buddy👍

  • @adzinja6574
    @adzinja65742 жыл бұрын

    Sir please tell us machine learning algorithm are needed for data analyst or SQL,python,excel,powerbi is infough

  • @saianuragneelisetty4548

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

  • @lolhead7127
    @lolhead71272 жыл бұрын

    Customer FAVOURIBILITY is also something you could use

  • @codebasics

    @codebasics

    2 жыл бұрын

    Good suggestion

  • @santhoshr8943
    @santhoshr89432 жыл бұрын

    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

    @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
    @A121572 жыл бұрын

    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.

  • @dhirendrasingh5637
    @dhirendrasingh56372 жыл бұрын

    without btech degree or graduation can I become data scientist and I have cs diploma

  • @codebasics

    @codebasics

    2 жыл бұрын

    yes of course you can.

  • @dhirendrasingh5637

    @dhirendrasingh5637

    2 жыл бұрын

    @@codebasics thanx for your suggestions sir

  • @ankushrajput9600
    @ankushrajput96002 жыл бұрын

    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
    @OMMI100m2 жыл бұрын

    Please donate for this Video 🙏

  • @sourabhbhatt5170
    @sourabhbhatt51702 жыл бұрын

    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
    @ProgrammerDevelops2 жыл бұрын

    Hi sir can you give me a shout out please am also programmer who makes apps , games and websites.