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

[@swaroopa4uable]

This is the best video ever on this topic 👍

[@chandoo_]

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

[@sanjusanjeev3515]

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.

[@SandraSouza-nj5fb]

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

[@DerekHolmes]

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

[@utubeaccount6981]

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

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

[@rajarshisikdar8800]

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

[@holla4691]

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

Wow, thank you!

[@tusharkalal5767]

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

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]

@@chandoo_ Hahahahaahahah🤣!!! Nice one!

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

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

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

[@jamanemon2110]

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

[@aherezaoswald7859]

Every aspiring data analyst should should from here.

[@chandoo_]

😊😍

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

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

[@sheetalbharti6498]

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

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

[@sruthiviswa4537]

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

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

[@bezawitarage1686]

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]

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

[@ParthasarathyLS]

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

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

[@swapnilkhurana5110]

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

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

[@severtone263]

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

[@chandoo_]

Wow, thank you!

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

[@makarand1985]

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

[@rameezhassan3289]

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

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

[@cathayat4672]

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

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

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

[@vinodkamath2057]

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

[@bernieTaranaki]

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

[@gvinodnair]

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

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

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

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

[@vaijnathpolsane]

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

Thanks Vaijnath...

[@gowrim8329]

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

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

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

[@chandoo_]

Happy to hear that!

[@shaikusman536]

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

[@pavanvarma1089]

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

[@balrajsanthosh1942]

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

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

[@nisthakhanal6280]

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

[@paulinaegbuna9520]

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

[@strategy_gal]

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

[@chandoo_]

Glad you enjoyed it!

[@julie_chen]

Very simple and yet effective teaching. 😊

[@jams4598]

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

[@ashuzawar]

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

[@senthilkumar-di4hv]

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

[@chandoo_]

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

[@nagabhushanbgbg7787]

Amazing and beautifully presented, very well simplified and articulated

[@chandoo_]

Glad you liked it!

[@shivanishete3923]

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

[@vikramdeshmukh1207]

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 😀

[@anandmikkili609]

Nailed it to perfection. Simply Excellent

[@mrombobrian3222]

You are just amazing Chandoo, really grateful

[@harmeekbhela244]

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

[@chandoo_]

That is awesome to hear. 😊

[@pk-solution2148]

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

Glad it was helpful!

[@adityaghoshal7414]

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

[@akshay789ful]

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

[@chandoo_]

Glad it was helpful!

[@preetisarode6091]

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

[@hariprasad289]

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

[@chandoo_]

Glad to hear that

[@vivekphadke16]

Great resource for newcomers and experts alike. Thanks a lot

[@anu6227-k2n]

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

[@udas2159]

Excellent - keep helping us by your excellent teaching techniques❤

[@souravsubudhi1414]

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

[@krzysztofmmichaluk]

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

[@kaltoumrachdi2086]

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

[@netovalt]

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

[@m.samleshraj5420]

This is the best way to understand any concept.

[@chandoo_]

Thanks Samlesh... :)

[@tejalsavla462]

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

[@arnabbangal766]

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

[@raviray6576]

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

[@chandoo_]

Thanks Ravi... :)

[@texasfall6644]

Great format for a beginner. Thank you! Subscribed.

[@proximacentaur1654]

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

[@Jeschko2012]

Thank you very much, the Form you used appears to be very good, I flatter myself that I might have understood this complex matter. Also I want to compliment you for (of, over?) your precise pronounciation: The automatic english subtitles grab every word and make it even easier to understand and follow your words. Kind regards from the other side of the globe (Germany), Ute

[@chandoo_]

Thanks JUH for that comments. KZbin / Google voice recognition is insanely smart.

[@tr.amysoe]

It is pretty good explanation style and effective!

[@chandoo_]

Glad you think so!

[@Mansijswarnkar]

Simple, yet effective - Thank you Chandoo !

[@waltforbes3084]

Both your content and style of delivery is AWESOME! Better than Netflix (to me)! Lol!

[@chandoo_]

Wow, thanks!

[@BalaKumarGona]

Very well explained. One feedback would be swapping the paper makes it hard to keep track of what you are saying. If you could sync it, it will be better

[@mariekevanzaal8682]

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

[@MichaelYugo]

Great presentation format... Consider putting sketchbook on a slight incline towards the camera angle (away from you) to compensate for the camera angle. Move the plant and just leave markers and highlighters and cards around to grab and for background. Nice! Thank you for the knowledge.

[@chandoo_]

Great suggestion!

[@imdssupplychain5503]

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

[@leonardcheah1318]

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

[@rajdantani636]

Nice video Chandoo! Useful basic concepts! Thanks!

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

[@nacitkhan2365]

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

[@chandoo_]

Thank you, I will

[@bangerasiddharth]

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

[@thangavelduraisamy730]

Easy to understand the data modelling in power bi... Nice and simple to catch the point...

[@chandoo_]

Glad you liked it

[@syed599]

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

[@chandoo_]

Glad it was helpful!

[@sairamadaboina8257]

Thank you Sir, you're explanation was very good, please upload more and more new trending courses and tricks.

[@sagarkeshyal752]

This is a really exciting way to teach, thankyou sir

[@datamik-ing4639]

Really straightforward an incredibly helpful!

[@nehasawant9127]

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

[@ajayk3218]

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

[@chandrashekharreddy5623]

Impressive explanation! Finally i understood the data modeling concept ✅

[@chandoo_]

Glad it was helpful!

[@ritudahiya6223]

@chandoo.. Such an amazing way of explaining complex concepts.. Can you please make a video on the process starting from etl till making dashboard and how sql is used in this. And how data analyst use sql and powerbi together. The whole concept. Please its a request Highly appreciable.