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

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

[@swaroopa4uable]

This is the best video ever on this topic 👍

[@chandoo_]

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

[@SandraSouza-nj5fb]

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

[@c.e.bingham2079]

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.

[@parulgupta9872]

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

[@georgeaboh]

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

[@bernieTaranaki]

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

[@akshaysinghrajput9534]

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! 🙏🏼

[@nerdyislander4641]

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

[@utubeaccount6981]

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

[@DerekHolmes]

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

[@sarj4918]

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

[@sheetalbharti6498]

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

[@AbhijeetKumar-fv8fs]

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

[@sachinseli03]

Awesome content. Cleared many of these terms which I thought I need to learn separately in the process of Data Analytics. Thanks.

[@severtone263]

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

[@chandoo_]

Wow, thank you!

[@mansijswarnkar4389]

Simple, yet effective - Thank you Chandoo !

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

[@hillarychika]

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

[@chandoo_]

Happy to hear that!

[@makarand1985]

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

[@Anna-pf6pi]

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!

[@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 🙏🙏🙏

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

[@ajayk3218]

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

[@bangerasiddharth]

Such a simple way to explain. I hope you create playlist for more tools like power Bi, power apps in a similar fashion.

[@datamik-ing4639]

Really straightforward an incredibly helpful!

[@odiapeter9165]

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!

[@rameezhassan3289]

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

[@udas2159]

Excellent - keep helping us by your excellent teaching techniques❤

[@daviddunmer3889]

This was brilliant chandoo, looking forward to the Power BI video.

[@nehasawant9127]

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

[@hemavathisingaravelu9804]

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

[@texasfall6644]

Great format for a beginner. Thank you! Subscribed.

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

[@jakedunat]

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

[@DhanashriBhate]

Amazing video! you're a great teacher! And of course loved this format of delivery. Subscribed :D

[@netovalt]

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

[@nattawut_chatwiriyacharoen]

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.

[@mariekevanzaal8682]

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

[@vijayarjunwadkar]

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! 😊👍

[@zulkhaireesulaiman8575]

This is fantastic. Incredibly helpful!

[@swapnilkhurana5110]

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

[@prashant3812]

Thank you Chandoo...Great job.

[@mrombobrian3222]

You are just amazing Chandoo, really grateful

[@strategy_gal]

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

[@chandoo_]

Glad you enjoyed it!

[@andresfrancojunor]

Fantastic ! Thanks again Chandoo !!

[@krzysztofmmichaluk]

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

[@AjayPrashar]

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.

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

[@jams4598]

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

[@adityaghoshal7414]

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

[@ashuzawar]

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

[@srinivasaraosarabada5943]

Thank you Chandoo for demystifying these topics. You have helped me understand the essence of a much larger area of study!

[@chandoo_]

Thanks Srinivasa..

[@aherezaoswald7859]

Every aspiring data analyst should should from here.

[@chandoo_]

😊😍

[@ExcelWithChris]

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

[@chandoo_]

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

[@nisthakhanal6280]

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

[@rajdantani636]

Nice video Chandoo! Useful basic concepts! Thanks!

[@madhavan4627]

Well explained Chandoo. Thank you so much for this content. I like these type of content

[@tejalsavla462]

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

[@pavanvarma1089]

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

[@irisgenx]

This was really informational and to the point. Great Work.

[@rajarshisikdar8800]

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

[@juantray]

This was a good approach. It’s a break from some of the current styles others are using. Keep up the good work.

[@brianligat9493]

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.

[@proximacentaur1654]

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

[@chikkile]

You are the Best Chandoo!!!

[@lakbaylaboy2644]

Chandoo! You are simply the best! 🥰🥰🥰

[@TomiwaAdegbola]

I just subscribed, your explanations are way easy to comprehend.

[@padminisubramainam]

explained well..kudos to you

[@anandmikkili609]

Nailed it to perfection. Simply Excellent

[@yamunau.yamuna5189]

Very nice explination, innovative way of teaching

[@ianshep57]

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

[@TwinAna]

Great Teacher!😊

[@YouExcelTutorials]

This is refreshing and insightful. Thanks for sharing Chandoo!

[@chandoo_]

Thanks YET... I am glad you enjoyed it.

[@sagarkeshyal752]

This is a really exciting way to teach, thankyou sir

[@ApoorvaDixit1488]

Thank you so much Sir. You make these concepts easy to understand.

[@Aadi.P]

As always, simple, easy to understand, and informative. Great video.

[@chandoo_]

Thank you Aadi.

[@KiranYadavOG]

Awesome way of teaching.

[@HarishKumar-lz2nw]

Wonderful Neat and Clean explanation. Thanks a lot.

[@paolarubiogarcia323]

Your channel is helping a lot!!!! I really appreciate your content! 😊 thank you

[@chandoo_]

Glad you think so!

[@nithinreddy2788]

Your explanation is too good mate. Keep up the good work

[@BenDieselBasicAutomotive]

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.

[@shaikusman536]

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

[@vinodkamath2057]

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

[@jamanemon2110]

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

[@vikramdeshmukh6373]

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_]

You are welcome Vikram 😀

[@raytebout3252]

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_]

Thanks Ray. I have a video on Power BI / PQ & Power Pivot here - kzbin.info/www/bejne/bJ3dlaKsrpaoedk

[@armandogomez856]

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

[@vivekphadke16]

Great resource for newcomers and experts alike. Thanks a lot

[@frankb.2172]

Great explanation. Thank you! 🙂

[@Mamtha7272]

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

[@chandoo_]

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

[@nagabhushanbgbg7787]

Amazing and beautifully presented, very well simplified and articulated

[@chandoo_]

Glad you liked it!

[@julie_chen]

Very simple and yet effective teaching. 😊

[@gowrim8329]

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

[@sallyisabel]

Very short and sweet summary.

[@anuradhadontha6227]

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

[@Shambeyond]

Thank you so much sir. Such an insightful video

[@ssnrajuPenmetsa]

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

[@ganeshrkamath8781]

Amazing Explanation!! Thanks Chandoo :)

[@chandoo_]

My pleasure 😊

[@preetisarode6091]

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

[@priscillalee5012]

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_]

Great to hear that Priscilla 😀

[@kaltoumrachdi2086]

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