Top 20 Data & BI terms every data analyst *should* know

Поделиться
HTML-код
  • Опубликовано: 4 ноя 2024

Комментарии • 502

  • @swaroopa4uable
    @swaroopa4uable 3 года назад +114

    This is the best video ever on this topic 👍

    • @chandoo_
      @chandoo_  3 года назад +2

      Wow... that is so nice to hear...

  • @sanjusanjeev3515
    @sanjusanjeev3515 10 месяцев назад +6

    Top 20 Terms:
    1. Table
    2. Fact tables(Tall and narrow)
    3. Dimension tables (Short and Wide)
    4. Calendar Table
    5. Star Schema (In a denormalised form, fairly used)
    6. Snowflake Schema (Normalised, occasionally used)
    7. Measure (Power BI term)
    8. Value (Excel Pivot Term)
    9. Aggregation (SQL term)
    10. Slicer
    11. Filter
    12. Model
    13. Cube
    14. Data warehouse
    15. ETL (Extract, Transform, Load)
    16. Data Pipeline
    17. Query (power query)
    18. Transform
    19. Batch
    20. Source and Refresh.

  • @DerekHolmes
    @DerekHolmes 3 года назад +38

    As someone who's self taught in power bi, I find this very helpful. I really liked this format!

  • @SandraSouza-nj5fb
    @SandraSouza-nj5fb Год назад +2

    It is no fancy, no special effects, real hand writting. But what really matters, the content, is great, clear, complete. Excellent.

  • @utubeaccount6981
    @utubeaccount6981 2 года назад +3

    Proves that a good teacher can explain things even with pen and paper, not needing nifty tech! Top!

  • @parulgupta9872
    @parulgupta9872 2 года назад +7

    This is really simplified way to describe so many concepts in one go. Awesome way of teaching.

  • @georgeaboh
    @georgeaboh 2 года назад +17

    You are a great teacher! You know how to break down complex concepts. Thanks, Chief :)

  • @jamanemon2110
    @jamanemon2110 8 месяцев назад +1

    You are really an awesome teacher chandoo. I really like your teaching method. Very easy,effective and well explained 👏

  • @odiapeter9165
    @odiapeter9165 11 месяцев назад +1

    Just seen this video. As a new project manager in data and analytics, I consider this as gold. It has helped to better understand the tech guys, the entire workflow, and the best part, presenting my work during steercomms. Thanks!

  • @holla4691
    @holla4691 9 месяцев назад +1

    As someone who is starting their journey as a data analyst, I find your videos to be the most helpful ones. You have a very clear way of presenting things, and you describe things in such detail that it answers all the questions that I have for the subject that you are talking about. Thank you for being a great teacher for us aspiring data analysts. :)

    • @chandoo_
      @chandoo_  9 месяцев назад +1

      Wow, thank you!

  • @akshaysinghrajput9534
    @akshaysinghrajput9534 2 года назад +1

    This approx is explaining the concepts is so far the best I have ever seen. You are making understanding these concepts very easy. Thank you! 🙏🏼

  • @tusharkalal5767
    @tusharkalal5767 2 года назад +1

    I was just seriously listening to every word of yours and a lady catwalking suddenly after you said modelling really cracked me up.
    You've been a great help to thousands like me in making these concepts easy. Thank you very much.

    • @chandoo_
      @chandoo_  2 года назад +1

      A data modeller walks in the to bar. The bartender asks, "Do you need a table?"
      The data modeller replies, "Nope, I need at least two". 🤣

    • @tusharkalal5767
      @tusharkalal5767 2 года назад

      @@chandoo_ Hahahahaahahah🤣!!! Nice one!

  • @raytebout3252
    @raytebout3252 2 года назад +7

    I absolutely love this. I've been doing ad hoc analysis for years on program data and this is the first time I fully understand the data analytics process in terms. I would absolutely love to see a follow-up video explaining power query, power bi, and dax. Thank you so much for your content. This format and the information were extremely helpful.

    • @chandoo_
      @chandoo_  2 года назад

      Thanks Ray. I have a video on Power BI / PQ & Power Pivot here - ruclips.net/video/6lzdovy1uCw/видео.html

    • @armandogomez856
      @armandogomez856 Год назад

      Chandoo has bunch of videos explaining this, you'll get quickly with those.
      Good luck.

  • @rajarshisikdar8800
    @rajarshisikdar8800 Год назад

    This is legendary level. People with no knowledge about the data field or power BI will easily understand each data term.

  • @AbhijeetKumar-fv8fs
    @AbhijeetKumar-fv8fs 2 года назад

    I would never say No to any of your content, I was huge fan of your animated presentation with zoom in's in and zoom out and this takes it altogether to next level. I have seen the channel late but I follow it regularly now. Please keep posting

  • @sheetalbharti6498
    @sheetalbharti6498 Год назад

    This is the simplest way of explaining the toughest concept. Thank you for giving the wonderful insights.

  • @severtone263
    @severtone263 2 года назад +3

    You are simply the best teacher on RUclips! Thank you for this wonderful format and video!

    • @chandoo_
      @chandoo_  2 года назад +1

      Wow, thank you!

  • @priscillalee5012
    @priscillalee5012 2 года назад

    I watch all your videos; you explain data analysis skills in an easy way. I watch them to refresh my Excel skills and learned Power BI on my own.

    • @chandoo_
      @chandoo_  2 года назад

      Great to hear that Priscilla 😀

  • @ExcelWithChris
    @ExcelWithChris 3 года назад +3

    Started watching and after the first two minutes I can say, BRILLIANT work once again!!! Thanks.
    Cant wait for the Power BI one!

    • @chandoo_
      @chandoo_  3 года назад

      Awesome Chris. I am glad this format and delivery style resonated with our viewers :)

  • @rajasekharkavuluru9666
    @rajasekharkavuluru9666 Год назад +3

    This is super helpful and excellent nugget to grasp the basics so clearly. Particularly this over the shoulder technique adopted to deliver this session is very good.

  • @Anna-pf6pi
    @Anna-pf6pi Год назад +1

    I want to thank you not only for such a valuable and easy understanding content, but also for your unique way of teaching, it was also very funny and engaging!

  • @cathayat4672
    @cathayat4672 5 месяцев назад

    You are amazing teacher! You explain complicated things in simple way! Thank you!

  • @aherezaoswald7859
    @aherezaoswald7859 3 года назад +1

    Every aspiring data analyst should should from here.

  • @swapnilkhurana5110
    @swapnilkhurana5110 Год назад

    Literal gold available, that too free of cost - beautiful and detailed explanation. Hats off !!

  • @rameezhassan3289
    @rameezhassan3289 Год назад

    This is one of the best video where one can understand the industry jargons and get confident, thanks for the video

  • @brianligat9493
    @brianligat9493 11 месяцев назад +2

    Great format. I was dreading that that this might just be you holding bits of paper but you covered the basics well and injected good humour. You could add some words about Latency, Refresh Rate/Frequency, and Batch vs Incremental loading.

  • @vinodlakshmanan3869
    @vinodlakshmanan3869 2 года назад +1

    You are a great teacher, all of my small steps in power bi is mainly through your videos. You are just amazing , your videos are clear & precious which makes the user understand the concept at ease. Thanks for all your videos and keep making more such videos 🙏🙏🙏

  • @gowrim8329
    @gowrim8329 Год назад +1

    Thank you so much. This is unique way of teaching and very useful and easy to understand

  • @sruthiviswa4537
    @sruthiviswa4537 2 года назад +1

    By watching and clean observation of your explanation. By the second time understand easily but just closing eyes and listening to your audio by clear visualizing pictorial thing like a dream. IT IS ACTUALLY WONDERFUL EXPLANTION I MUST SAY. IT REALLY HELPED ME OUT FOR MY INTERVIEW AS A FRESHER AND OFCOURSE YOUR EXPLANATION AND REPRESENTION MADE ME MORE INTRESTING.. THANK YOU SO MUCH..

    • @chandoo_
      @chandoo_  2 года назад

      Wow. Thank you for the kind & lovely words Sruthi. So Happy to hear about your interview experience.

  • @armandogomez856
    @armandogomez856 Год назад

    Hi Chandoo
    This is the 1st time I'm writing you since I looked at this video but I've seen other great videos from you that are related to Power Bi. Believe me I've learned from other videos too but referring me to your videos, you have a very easy way to explain concepts, terms or anything that you want to explain and is easy to understand, in addition too the way you suddenly add funny short video or gif.
    I had learned many tips and tricks from you about Power BI by looking at other videos but now, this video was clearly special for me because I realized and confirmed that I know and have experience working with these different tools and concepts. I was not totally aware that I was applying all these concepts in many projects at the same time, for example, DW or Data Lake, so, the way you put all together in one short video was wonderful and powerful for my knowledge.
    I read all the comments from other people who wrote you and I agree with them. Continue creating this mine of information.
    Thank you so much

  • @strategy_gal
    @strategy_gal 3 года назад +1

    I appreciate how you explained each word and showed them in the video. Very informative!

    • @chandoo_
      @chandoo_  3 года назад

      Glad you enjoyed it!

  • @bezawitarage1686
    @bezawitarage1686 2 года назад

    OMG YOU ARE JUST AN ANGEL I JUST KNOW YOU TODAY AND EVERYTHING IS SO CLEAR AND YOU MAKE IT SO SIMPLE FOR ME BY GIVING IMAGINARY EXAMPLES. THOSE IMAGINARIES MAKES EVERYTHING VERY INTERESTING. I USED TO FOLLOW OTHER POWER BI INSTRUCTIRS IN YOU TUBE BUT YOU ARE THE NUMBER 1 THANKS SIR GOD BLESS YOU

    • @bezawitarage1686
      @bezawitarage1686 2 года назад

      ONE RECOMRNDATION I CAN GIVE IS THAT IT WILL BE GOOD IF YOU SHOW US IN REAL MEANING FOR EXAMPLE IF YOU TALKING ABOUT TRANSFORMATION ITS BETTER TO SEE IT IN PBI DESKTOP

  • @gvinodnair
    @gvinodnair 3 года назад +4

    Very simple and practical explanation, It gives clear idea to a beginner who wants to explore the world of data analysis in a systematic and organized way. Looking forward to more presentations like this. Great job Chandoo. 👌🏼

    • @chandoo_
      @chandoo_  3 года назад

      Thanks Vinod. I am glad the style and material proved useful. :)

  • @makarand1985
    @makarand1985 3 года назад

    Mr. Chandoo is the greatest teacher I have ever seen in my life !!!!

  • @bernieTaranaki
    @bernieTaranaki 3 года назад +2

    Excellent, clear and concise and brings together all the terms we may have heard out of context. More please!

  • @jams4598
    @jams4598 2 года назад +1

    I have watched so many videos and your channel is the best. Very clear explanation .thank you

  • @hillarychika
    @hillarychika 2 года назад +1

    Thank you Chandoo, you just simplified this well. Your channel is a gold mine!

    • @chandoo_
      @chandoo_  2 года назад

      Happy to hear that!

  • @nerdyislander4641
    @nerdyislander4641 2 года назад +1

    I feel like you decluttered my brain on this topic man, thank you. (And the fact that the blurriness did not make me click away is a testament to your ability and command as a science communicator.)

  • @ParthasarathyLS
    @ParthasarathyLS Год назад

    Cleared 1 very important Jargon that i was not used to as non IT person

  • @vinodkamath2057
    @vinodkamath2057 Год назад

    Excellent ...you have explained maximum in minimum words..You ate a great. Teacher 🙏

  • @nisthakhanal6280
    @nisthakhanal6280 2 года назад

    Hand down the best video to understand key concepts. I am your big-time fan

  • @krzysztofmmichaluk
    @krzysztofmmichaluk 2 года назад

    Absolutely great video. Love this Casy Naistad style. Super.

  • @Mamtha7272
    @Mamtha7272 3 года назад +2

    Chandoo Anna, this is a very easy way to understand. thank you for your hard work for us.

    • @chandoo_
      @chandoo_  3 года назад

      Hi Bhavani... Thanks for the cheer mate :)

  • @BenDieselBasicAutomotive
    @BenDieselBasicAutomotive 2 года назад

    Thank you again for the knowledge. You bring me back to college.... Except that no tuition fee required. You simplify the knowledge that I feared most to explore.

  • @ashuzawar
    @ashuzawar 2 года назад

    Fantastic way to explain, Chandroo!.. Easy to understand method by taking it all off-screen!

  • @c.e.bingham2079
    @c.e.bingham2079 3 года назад +1

    I enjoyed that format. You simplified the concepts, which made the material/subject easy to understand. I would love to see more of this format.

  • @mrombobrian3222
    @mrombobrian3222 10 месяцев назад

    You are just amazing Chandoo, really grateful

  • @anandmikkili609
    @anandmikkili609 Год назад

    Nailed it to perfection. Simply Excellent

  • @shaikusman536
    @shaikusman536 3 года назад

    Super, Simple, Pricise and Easy to Understand....Hats off for your efforts bro.....

  • @deepikamk3191
    @deepikamk3191 Год назад +1

    Loved the way you explained it I just finished learning informatica theory and now in the project work and I really wanted a clarity on one to many concept and you just made it so very easy to understand.
    I so wish I came across your account before.😊

  • @pavanvarma1089
    @pavanvarma1089 3 года назад

    You are the really valuable person from Microsoft.
    Thank you soo much for best presentations.

  • @julie_chen
    @julie_chen Год назад

    Very simple and yet effective teaching. 😊

  • @PamTiwari
    @PamTiwari Год назад

    This is very helpful, because we learn everything by watching and doing, but when it comes to face interview questions it's totally based on term they use and how you present your answer while using technical terms to related ETL tools and Bi tools

  • @mariekevanzaal8682
    @mariekevanzaal8682 Год назад

    This is the best! I love this way of explaining. Thank you!

  • @vaijnathpolsane
    @vaijnathpolsane 2 года назад

    Simple but very clear, out of the box thinking.... now it's too easy. I wish I would have found these in my college days.

    • @chandoo_
      @chandoo_  2 года назад

      Thanks Vaijnath...

  • @vikramdeshmukh1207
    @vikramdeshmukh1207 2 года назад

    Thanks, thats a quick & good way to understand than going through heap of texts on the internet. You have a very simple but effective method for explaining the concept. Keep it up.

    • @chandoo_
      @chandoo_  2 года назад

      You are welcome Vikram 😀

  • @senthilkumar-di4hv
    @senthilkumar-di4hv 3 года назад +4

    Learnt a lot in a swift period.waiting for more such...

    • @chandoo_
      @chandoo_  3 года назад

      That is nice to hear. Thanks Senthil... 😊

  • @vivekphadke16
    @vivekphadke16 2 года назад

    Great resource for newcomers and experts alike. Thanks a lot

  • @harmeekbhela244
    @harmeekbhela244 3 года назад +1

    Very lucid explaination, makes it so easy to grasp and understand. Thanks Chandoo

    • @chandoo_
      @chandoo_  3 года назад +1

      That is awesome to hear. 😊

  • @kaltoumrachdi2086
    @kaltoumrachdi2086 9 месяцев назад

    I can ' t thank u enough for making things clear to me

  • @paulinaegbuna9520
    @paulinaegbuna9520 5 месяцев назад

    i cant believe that I only discovered you. YOU ARE GOD SENT

  • @anuradhadontha6227
    @anuradhadontha6227 Год назад

    I like all your videos. Great teaching and very easy to understand.

  • @balrajsanthosh1942
    @balrajsanthosh1942 2 года назад

    The video is just at a ultimate level of making someone understand from scratch to a expertise level thanks a lot for this video and please share the link of next video following to this will be waiting and eager to watch, (please share) 🥰

  • @netovalt
    @netovalt Год назад

    I want it for sure, keep up with this amazing job. Thank you Chandoo

  • @nagabhushanbgbg7787
    @nagabhushanbgbg7787 3 года назад +2

    Amazing and beautifully presented, very well simplified and articulated

    • @chandoo_
      @chandoo_  3 года назад

      Glad you liked it!

  • @udas2159
    @udas2159 Год назад

    Excellent - keep helping us by your excellent teaching techniques❤

  • @pk-solution2148
    @pk-solution2148 3 года назад

    In every video, you provided the best explanation ever. Thank you so much for sharing the valuable video. I watched every video of you.

    • @chandoo_
      @chandoo_  3 года назад

      Glad it was helpful!

  • @mansijswarnkar4389
    @mansijswarnkar4389 2 года назад

    Simple, yet effective - Thank you Chandoo !

  • @zulkhaireesulaiman8575
    @zulkhaireesulaiman8575 2 года назад

    This is fantastic. Incredibly helpful!

  • @m.samleshraj5420
    @m.samleshraj5420 3 года назад

    This is the best way to understand any concept.

    • @chandoo_
      @chandoo_  3 года назад

      Thanks Samlesh... :)

  • @shivanishete3923
    @shivanishete3923 2 года назад

    your teaching skills is really good.... easily understand and learn many things..

  • @akshay789ful
    @akshay789ful 3 года назад

    Waiting to learn more of Data Modeling in simple manner like this video, this is so simple and easy.

    • @chandoo_
      @chandoo_  3 года назад

      Glad it was helpful!

  • @tr.amysoe
    @tr.amysoe 3 года назад +2

    It is pretty good explanation style and effective!

    • @chandoo_
      @chandoo_  3 года назад

      Glad you think so!

  • @rajdantani636
    @rajdantani636 2 года назад

    Nice video Chandoo! Useful basic concepts! Thanks!

  • @ajayk3218
    @ajayk3218 Год назад

    Thank you for these excellent and simple-to-understand videos. Much appreciated!

  • @preetisarode6091
    @preetisarode6091 Год назад

    It was very interesting to know the concepts of BI in this way .. please make more videos on power bi in similar way.

  • @arnabbangal766
    @arnabbangal766 2 года назад

    Enjoyed this video. Small video but lot important jargons and architecture flow

  • @proximacentaur1654
    @proximacentaur1654 2 года назад

    This was a very clear and precise explanation. The simple visual presentation very good. Subscribed!

  • @texasfall6644
    @texasfall6644 2 года назад

    Great format for a beginner. Thank you! Subscribed.

  • @tejalsavla462
    @tejalsavla462 2 года назад

    You explain the terms and concepts so well .....love your videos .....

  • @nehasawant9127
    @nehasawant9127 2 года назад

    excellent out of the box presenting technique! also the content is clear, concise & easy to understand!

  • @hariprasad289
    @hariprasad289 3 года назад

    This kind of explanations will help to learn things more faster. Thank you sir

    • @chandoo_
      @chandoo_  3 года назад

      Glad to hear that

  • @sagarkeshyal752
    @sagarkeshyal752 Год назад

    This is a really exciting way to teach, thankyou sir

  • @juliane1mota
    @juliane1mota 3 года назад +2

    As usual, so didatic. Thank you ever so much Chandoo.

    • @chandoo_
      @chandoo_  3 года назад

      Thanks Juliane :)

  • @souravsubudhi1414
    @souravsubudhi1414 2 года назад

    Sir your way of teaching is really excellent.. thank you so much sir

  • @hemavathisingaravelu9804
    @hemavathisingaravelu9804 3 года назад

    Excellent way of explaining , short and very clear. Thank you

  • @nacitkhan2365
    @nacitkhan2365 3 года назад +1

    Excellent explanation. Please keep making such videos because in a short span of time you taught very valuable concepts.

    • @chandoo_
      @chandoo_  3 года назад

      Thank you, I will

  • @aparnapandravada5073
    @aparnapandravada5073 3 года назад

    Awesome. Really you are doing a great job by sharing knowledge with ppl..

  • @lakbaylaboy2644
    @lakbaylaboy2644 3 года назад

    Chandoo! You are simply the best! 🥰🥰🥰

  • @ianshep57
    @ianshep57 3 года назад

    That is a brilliant way of showing the video. Awesome.

  • @raviray6576
    @raviray6576 3 года назад

    Best explanation ever. Really innovative and effective style of teaching.

    • @chandoo_
      @chandoo_  3 года назад

      Thanks Ravi... :)

  • @imdssupplychain5503
    @imdssupplychain5503 Год назад

    very helpful to me as im new in the data analytics career.

  • @adityaghoshal7414
    @adityaghoshal7414 Год назад

    Loved this representation, please request you to make more videos of different concepts using this format.

  • @leonardcheah1318
    @leonardcheah1318 2 года назад

    Awesome video, I like the way you present using paper drawing, yet it still able bring clean and clear message, keep up

  • @jakedunat
    @jakedunat 2 года назад

    thank you. You explain it in the simplest terms. Great job!

  • @nattawut_chatwiriyacharoen
    @nattawut_chatwiriyacharoen 3 года назад

    Many thanks Chandoo, I love the way you explained. It's easy to understand and plenty of sense of humors. Love it.
    I'm looking forward to seeing the Power BI video.

  • @HarishKumar-lz2nw
    @HarishKumar-lz2nw 8 месяцев назад

    Wonderful Neat and Clean explanation. Thanks a lot.

  • @syed599
    @syed599 3 года назад

    Exceptional approach to explain the complex concept of Data Model. It is very helpful.

    • @chandoo_
      @chandoo_  3 года назад

      Glad it was helpful!

  • @ssnrajuPenmetsa
    @ssnrajuPenmetsa Год назад

    So informative. I like the way you explain. Thanks for sharing Chandoo

  • @sarj4918
    @sarj4918 2 года назад +2

    This was so informative and straight to the point. Amazing content!