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

  Рет қаралды 126,436

Chandoo

Chandoo

Күн бұрын

Frustrated by the technical terms like dimensions, data modeling or snowflake? In this video, let me explain more than 20 jargon words when it comes to data modeling & business intelligence world.
Terminology explained in this video:
Table
Fact
Dimension
Calendar
Relationship
One to many, one to one, many to many
Keys - Primary & Foreign keys
Star schema
Snowflake schema
Measures
Values, Aggregation
Data Modeling
Slicer
Filter
Query
ETL
Transformations
Batch
Data Pipeline
Source
Refresh
---
Want to learn more?
================
Check out my getting started with Power BI video - • Introduction to Power ...
Power Pivot, DAX explained with 15 example measures - • Getting started with P...
More on Power BI - chandoo.org/wp/powerbi-introd...
Need to learn any other technical terms?
=================================
Drop a comment so I can gather ideas for 2.0 of this video.
Thanks and stay awesome 😀
#DataModeling

Пікірлер: 493
@swaroopa4uable
@swaroopa4uable 2 жыл бұрын
This is the best video ever on this topic 👍
@chandoo_
@chandoo_ 2 жыл бұрын
Wow... that is so nice to hear...
@c.e.bingham2079
@c.e.bingham2079 2 жыл бұрын
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.
@akshaysinghrajput9534
@akshaysinghrajput9534 2 жыл бұрын
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! 🙏🏼
@georgeaboh
@georgeaboh Жыл бұрын
You are a great teacher! You know how to break down complex concepts. Thanks, Chief :)
@parulgupta9872
@parulgupta9872 2 жыл бұрын
This is really simplified way to describe so many concepts in one go. Awesome way of teaching.
@utubeaccount6981
@utubeaccount6981 2 жыл бұрын
Proves that a good teacher can explain things even with pen and paper, not needing nifty tech! Top!
@bernieTaranaki
@bernieTaranaki 2 жыл бұрын
Excellent, clear and concise and brings together all the terms we may have heard out of context. More please!
@rajasekharkavuluru9666
@rajasekharkavuluru9666 Жыл бұрын
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.
@vinodlakshmanan3869
@vinodlakshmanan3869 Жыл бұрын
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 🙏🙏🙏
@nerdyislander4641
@nerdyislander4641 2 жыл бұрын
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.)
@mansijswarnkar4389
@mansijswarnkar4389 2 жыл бұрын
Simple, yet effective - Thank you Chandoo !
@sarj4918
@sarj4918 2 жыл бұрын
This was so informative and straight to the point. Amazing content!
@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.
@odiapeter9165
@odiapeter9165 6 ай бұрын
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!
@DerekHolmes
@DerekHolmes 2 жыл бұрын
As someone who's self taught in power bi, I find this very helpful. I really liked this format!
@mrombobrian3222
@mrombobrian3222 6 ай бұрын
You are just amazing Chandoo, really grateful
@armandogomez856
@armandogomez856 8 ай бұрын
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
@texasfall6644
@texasfall6644 2 жыл бұрын
Great format for a beginner. Thank you! Subscribed.
@rajdantani636
@rajdantani636 Жыл бұрын
Nice video Chandoo! Useful basic concepts! Thanks!
@sachinseli03
@sachinseli03 2 жыл бұрын
Awesome content. Cleared many of these terms which I thought I need to learn separately in the process of Data Analytics. Thanks.
@deepikamk3191
@deepikamk3191 Жыл бұрын
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.😊
@hillarychika
@hillarychika 2 жыл бұрын
Thank you Chandoo, you just simplified this well. Your channel is a gold mine!
@chandoo_
@chandoo_ 2 жыл бұрын
Happy to hear that!
@datamik-ing4639
@datamik-ing4639 2 жыл бұрын
Really straightforward an incredibly helpful!
@severtone263
@severtone263 2 жыл бұрын
You are simply the best teacher on KZfaq! Thank you for this wonderful format and video!
@chandoo_
@chandoo_ 2 жыл бұрын
Wow, thank you!
@SandraSouza-nj5fb
@SandraSouza-nj5fb 9 ай бұрын
It is no fancy, no special effects, real hand writting. But what really matters, the content, is great, clear, complete. Excellent.
@DhanashriBhate
@DhanashriBhate Жыл бұрын
Amazing video! you're a great teacher! And of course loved this format of delivery. Subscribed :D
@andresfrancojunor
@andresfrancojunor 2 жыл бұрын
Fantastic ! Thanks again Chandoo !!
@zulkhaireesulaiman8575
@zulkhaireesulaiman8575 Жыл бұрын
This is fantastic. Incredibly helpful!
@hemavathisingaravelu9804
@hemavathisingaravelu9804 2 жыл бұрын
Excellent way of explaining , short and very clear. Thank you
@nehasawant9127
@nehasawant9127 Жыл бұрын
excellent out of the box presenting technique! also the content is clear, concise & easy to understand!
@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
@rameezhassan3289
@rameezhassan3289 Жыл бұрын
This is one of the best video where one can understand the industry jargons and get confident, thanks for the video
@netovalt
@netovalt Жыл бұрын
I want it for sure, keep up with this amazing job. Thank you Chandoo
@nattawut_chatwiriyacharoen
@nattawut_chatwiriyacharoen 2 жыл бұрын
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.
@ajayk3218
@ajayk3218 Жыл бұрын
Thank you for these excellent and simple-to-understand videos. Much appreciated!
@mariekevanzaal8682
@mariekevanzaal8682 Жыл бұрын
This is the best! I love this way of explaining. Thank you!
@TomiwaAdegbola
@TomiwaAdegbola 2 жыл бұрын
I just subscribed, your explanations are way easy to comprehend.
@prashant3812
@prashant3812 11 ай бұрын
Thank you Chandoo...Great job.
@ashuzawar
@ashuzawar Жыл бұрын
Fantastic way to explain, Chandroo!.. Easy to understand method by taking it all off-screen!
@Anna-pf6pi
@Anna-pf6pi 11 ай бұрын
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 12 күн бұрын
You are amazing teacher! You explain complicated things in simple way! Thank you!
@jams4598
@jams4598 Жыл бұрын
I have watched so many videos and your channel is the best. Very clear explanation .thank you
@ExcelWithChris
@ExcelWithChris 2 жыл бұрын
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_ 2 жыл бұрын
Awesome Chris. I am glad this format and delivery style resonated with our viewers :)
@tejalsavla462
@tejalsavla462 Жыл бұрын
You explain the terms and concepts so well .....love your videos .....
@jakedunat
@jakedunat 2 жыл бұрын
thank you. You explain it in the simplest terms. Great job!
@daviddunmer3889
@daviddunmer3889 2 жыл бұрын
This was brilliant chandoo, looking forward to the Power BI video.
@sagarkeshyal752
@sagarkeshyal752 Жыл бұрын
This is a really exciting way to teach, thankyou sir
@bangerasiddharth
@bangerasiddharth 2 жыл бұрын
Such a simple way to explain. I hope you create playlist for more tools like power Bi, power apps in a similar fashion.
@chikkile
@chikkile 2 жыл бұрын
You are the Best Chandoo!!!
@krzysztofmmichaluk
@krzysztofmmichaluk Жыл бұрын
Absolutely great video. Love this Casy Naistad style. Super.
@makarand1985
@makarand1985 2 жыл бұрын
Mr. Chandoo is the greatest teacher I have ever seen in my life !!!!
@brianligat9493
@brianligat9493 6 ай бұрын
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.
@anandmikkili609
@anandmikkili609 Жыл бұрын
Nailed it to perfection. Simply Excellent
@vijayarjunwadkar
@vijayarjunwadkar 2 жыл бұрын
Superb idea Chandoo! This video made all concepts so much clear over all the books I read on these topics! You may please do more such videos on other topics too! 😊👍
@strategy_gal
@strategy_gal 2 жыл бұрын
I appreciate how you explained each word and showed them in the video. Very informative!
@chandoo_
@chandoo_ 2 жыл бұрын
Glad you enjoyed it!
@madhavan4627
@madhavan4627 Жыл бұрын
Well explained Chandoo. Thank you so much for this content. I like these type of content
@HarishKumar-lz2nw
@HarishKumar-lz2nw 3 ай бұрын
Wonderful Neat and Clean explanation. Thanks a lot.
@shaikusman536
@shaikusman536 2 жыл бұрын
Super, Simple, Pricise and Easy to Understand....Hats off for your efforts bro.....
@ianshep57
@ianshep57 2 жыл бұрын
That is a brilliant way of showing the video. Awesome.
@udas2159
@udas2159 9 ай бұрын
Excellent - keep helping us by your excellent teaching techniques❤
@irisgenx
@irisgenx 2 жыл бұрын
This was really informational and to the point. Great Work.
@nisthakhanal6280
@nisthakhanal6280 Жыл бұрын
Hand down the best video to understand key concepts. I am your big-time fan
@anuradhadontha6227
@anuradhadontha6227 Жыл бұрын
I like all your videos. Great teaching and very easy to understand.
@gowrim8329
@gowrim8329 Жыл бұрын
Thank you so much. This is unique way of teaching and very useful and easy to understand
@proximacentaur1654
@proximacentaur1654 Жыл бұрын
This was a very clear and precise explanation. The simple visual presentation very good. Subscribed!
@vivekphadke16
@vivekphadke16 Жыл бұрын
Great resource for newcomers and experts alike. Thanks a lot
@srinivasaraosarabada5943
@srinivasaraosarabada5943 2 жыл бұрын
Thank you Chandoo for demystifying these topics. You have helped me understand the essence of a much larger area of study!
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Srinivasa..
@ApoorvaDixit1488
@ApoorvaDixit1488 2 жыл бұрын
Thank you so much Sir. You make these concepts easy to understand.
@lakbaylaboy2644
@lakbaylaboy2644 2 жыл бұрын
Chandoo! You are simply the best! 🥰🥰🥰
@julie_chen
@julie_chen Жыл бұрын
Very simple and yet effective teaching. 😊
@Shambeyond
@Shambeyond 11 ай бұрын
Thank you so much sir. Such an insightful video
@paolarubiogarcia323
@paolarubiogarcia323 2 жыл бұрын
Your channel is helping a lot!!!! I really appreciate your content! 😊 thank you
@chandoo_
@chandoo_ 2 жыл бұрын
Glad you think so!
@digitaljas5594
@digitaljas5594 2 жыл бұрын
Really Awesome Mr. Chandoo
@frankb.2172
@frankb.2172 6 ай бұрын
Great explanation. Thank you! 🙂
@AjayPrashar
@AjayPrashar 2 жыл бұрын
This is an excellent video Chandoo. Another British youtuber (Dr. John Campbell), also uses a similar technique. What is more impressive is the pace and clarity of the lesson. I would rather have the marker with stacked paper cutouts than some fancy 4k graphics. Thank you for the high quality lesson.
@holla4691
@holla4691 4 ай бұрын
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_ 4 ай бұрын
Wow, thank you!
@aarimaz
@aarimaz Жыл бұрын
I really did enjoy the video and it was very easy to understand! thank you!
@KiranYadavOG
@KiranYadavOG 9 ай бұрын
Awesome way of teaching.
@pavanvarma1089
@pavanvarma1089 2 жыл бұрын
You are the really valuable person from Microsoft. Thank you soo much for best presentations.
@rajarshisikdar8800
@rajarshisikdar8800 Жыл бұрын
This is legendary level. People with no knowledge about the data field or power BI will easily understand each data term.
@vikramdeshmukh6373
@vikramdeshmukh6373 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 😀
@nithinreddy2788
@nithinreddy2788 Жыл бұрын
Your explanation is too good mate. Keep up the good work
@hussainsalim2854
@hussainsalim2854 Жыл бұрын
Thank you for such a good and educational content.
@vinodkamath2057
@vinodkamath2057 Жыл бұрын
Excellent ...you have explained maximum in minimum words..You ate a great. Teacher 🙏
@saketnair
@saketnair Жыл бұрын
What a unique way to explain loved it..
@kaltoumrachdi2086
@kaltoumrachdi2086 4 ай бұрын
I can ' t thank u enough for making things clear to me
@YouExcelTutorials
@YouExcelTutorials 2 жыл бұрын
This is refreshing and insightful. Thanks for sharing Chandoo!
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks YET... I am glad you enjoyed it.
@ganeshrkamath8781
@ganeshrkamath8781 2 жыл бұрын
Amazing Explanation!! Thanks Chandoo :)
@chandoo_
@chandoo_ 2 жыл бұрын
My pleasure 😊
@adityaghoshal7414
@adityaghoshal7414 Жыл бұрын
Loved this representation, please request you to make more videos of different concepts using this format.
@ravikiranhrd
@ravikiranhrd Жыл бұрын
Excellent way of explanation 🙏
@Aadi.P
@Aadi.P 2 жыл бұрын
As always, simple, easy to understand, and informative. Great video.
@chandoo_
@chandoo_ 2 жыл бұрын
Thank you Aadi.
@juantray
@juantray Жыл бұрын
This was a good approach. It’s a break from some of the current styles others are using. Keep up the good work.
@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 😀
@namitagirish5879
@namitagirish5879 Жыл бұрын
Thank you very much for such a clear and simple explanation, helps to understand the basics for beginners like me✌
@SportsAndFork
@SportsAndFork 2 жыл бұрын
Love learning and watching this new style. Very good
@chandoo_
@chandoo_ 2 жыл бұрын
Happy to hear that! I will add a few more videos on this style for sure.
@abhisquest
@abhisquest 2 жыл бұрын
This is Awesome. Simple and so informative. Thank You.
@chandoo_
@chandoo_ 2 жыл бұрын
Glad it was helpful!
@Mamtha7272
@Mamtha7272 2 жыл бұрын
Chandoo Anna, this is a very easy way to understand. thank you for your hard work for us.
@chandoo_
@chandoo_ 2 жыл бұрын
Hi Bhavani... Thanks for the cheer mate :)
@arnabbangal766
@arnabbangal766 Жыл бұрын
Enjoyed this video. Small video but lot important jargons and architecture flow
@nagabhushanbgbg7787
@nagabhushanbgbg7787 2 жыл бұрын
Amazing and beautifully presented, very well simplified and articulated
@chandoo_
@chandoo_ 2 жыл бұрын
Glad you liked it!
What is ETL with a clear example - Data Engineering Concepts
13:56
Just try to use a cool gadget 😍
00:33
123 GO! SHORTS
Рет қаралды 61 МЛН
Data Analyst Job Interview - Don't make these 7 mistakes
11:02
Top 30 *Advanced* Excel Tips to make you awesome ⚡💡
22:25
The book every Data Analyst should read
10:34
Luke Barousse
Рет қаралды 199 М.
Database vs Data Warehouse vs Data Lake | What is the Difference?
5:22
Alex The Analyst
Рет қаралды 721 М.
The truth about Power BI (and how to learn it properly)
13:35
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
Power BI Masterclass: Data Modeling 101
56:54
CRG Quisitive
Рет қаралды 52 М.
Samsung S24 Ultra professional shooting kit #shorts
0:12
Photographer Army
Рет қаралды 18 МЛН
How charged your battery?
0:14
V.A. show / Магика
Рет қаралды 5 МЛН
MacBook Air Японский Прикол!
0:42
Sergey Delaisy
Рет қаралды 236 М.
ВЫ ЧЕ СДЕЛАЛИ С iOS 18?
22:40
Overtake lab
Рет қаралды 116 М.
Mem VPN - в Apple Store
0:30
AndroHack
Рет қаралды 103 М.
Bardak ile Projektör Nasıl Yapılır?
0:19
Safak Novruz
Рет қаралды 6 МЛН
i like you subscriber ♥️♥️ #trending #iphone #apple #iphonefold
0:14