Explain By Example: OLTP vs OLAP

TL;DR:
Watch OLTP vs OLAP explained using a simple school analogy.
I had so much fun making the first video that I decided to start on the second one shortly after.
If you have read the actual blog post for this topic which is on OLTP vs. OLAP, you would notice that at the end I mention a section that describes the difference between normalisation vs. denormalisation. I originally planned to incorporate it into this video and even made all the animations and voice over but upon review, I decided I hated it. It was an awful example and I'm not sure why no one told me off for using it.
So, if you're wondering what happened to that section, there is a reason why it is missing. I suppose when you review old content you made almost two years ago, there are a lot of self-reflection (and possibly regrets) involved so I'll save you the horror even though it was only an extra minute long.
Thanks for watching. Remember to thumbs up/down, subscribe, and leave a comment below!
📔 Feel like reading instead? Go check out / explain-by-example-olt...
🇲 Want to stalk me? Follow me on: medium.com/@michelle.xie
🐦 Need someone to talk to? Tweet me: @mishxie

[@yousefomairi8899]

I am lucky that i found your channel in youtube
Thank you for the easy and non-boring explain you make 💙

[@KARTHIKEYANRE-tn4cz]

I have been through lot of videos for OLAP, OLTP and Warehouse , but ended with this example and ended my loop of search because of this END = "Explain by Example". Thanks!!

[@ayappakn1073]

Amazing!!, never thought OLTP and OLAP concepts could be explained like this!! It was so much fun watching this video Thank you!!

[@josephdoe5195]

Your video is amazing. RUclips is hard but you genuinely sound pleasant and present like a professional. Please don't stop. Hope to see you be big some day.👌

[@YousefHaidary]

wow you have a great way of delivering information in a very clear way, thank you!

[@dansinn]

Very well explained, 3:55 is my favourite part

[@SahilKashyap64]

🙏Thank you, you made it so easy to understand. Now I can easily explain these terms to my collegues.

[@palihno]

That's a great example. Very clear and informative.

[@bluis]

Great example, now I know the terms for things I've been using and doing for years.

[@surabhisharma8562]

Crystal clear explanation. Thanks alot 😊

[@Alex-UK369]

Super well explained. Thanks a lot 🙏🙂

[@sandyboxer5]

shit!!!! after looking and understanding with your example , i realised how dumb im lolll.. thanks i was confused with both of the names however i got it now...keep rocking , good content and its really creative idea to have a youtube cHannel like this which helps to understand information as "piece of cake" ofcourse the credit is your ideology.. good luck for your future plans

[@Quraovers8345]

Thanks, very easy to understand. Makes a lot of sense now!

[@udohchigozie5957]

Wow, this is very very nice. Thanks a lot I now have a far better understanding.

[@dhruvmaindola5767]

this video is insanely underrated!

[@KenLaw-fu7wh]

You are the nature explainer and thanks for kind sharing!!

[@EdsonNascimentoEN]

Very nice explanation, thanks for sharing. I wonder what software you used to draw the beautiful explanation.

[@jefinjoseph365]

awesome explanation - very clear!!!

[@danielsantossebrero2267]

Amazing explanation, thank you!

[@manivannanr7192]

Thank you...very clear explanation

[@Khushi-lm9pr]

SOOOOO SOOOO GOOD , THANKYOU

[@sayeddileri3461]

amazing example. Many thanks!!1

[@princejunior4330]

U r so good at explaining 👍

[@cewneyseg1315]

Eeeeee
Dat was soo good
Simply explained with examples
Thank you alot ☺

[@Zarunza1]

Very clear , Thank you

[@JNJ529]

so good!

[@takudzwamupanesure7765]

Thanks, I understand the topics well

[@j.r.9966]

This is great - thank you

[@yonathanwolezg1527]

Thank you 🙏🙏🙏

[@takadiwachipfumbu9795]

Lifesaver💙

[@paridalamohitbabu1017]

I'm your 400th sub 🙂

[@hetalaghara]

Very clear explanation....

[@lisaabokhai3984]

Great video thank you

[@bhushanchaudhari5215]

Really nice explained.

[@Artouple]

Wotta a great video! Found a treasure:))

[@emmanuelgoodluck9013]

this is awesome i just subscribed

[@quanhoang68679]

thanks a lot for this stuff

[@sanskritisen6681]

REALLY HELPFULL

[@sakhilemjiyakho819]

Thank you so much

[@suvrotica]

Could you do videos on statistics

[@Mahmoud-ys1kt]

sehr gut danke

[@enrique-zarate4594]

4:50 is where my mind finally made “click”. Amazing video.

[@DROIDRUSH]

Thank you.

[@daks8426]

Nice explanation

[@trekkingxlove6953]

Excelente..👍👍👍

[@aminaomar9173]

Great!!!

[@ahmedwael3179]

wonderful

[@MegaDeepak56]

Good voice and explanation...

[@mariammohamed7762]

U r amazing
Thx❤

[@smugglemuffins]

I’m stuck very confused. Is the only difference where they search for the data? Do one from a database with current quick information and the other a data warehouse with more in depth and broadly sought after reasoning for the answer?

[@thecoycook2098]

OLTP is at the transaction grain. Is primarily used for applications and operations.
OLAP is analytic and is aggregated for creating analytical reporting such as KPI or metric dashboards so is at a categorical level.
OLTP DB might say these are all the transactions from this store and have a row for each sale.
An OLAP Data-warehouse would say last month we sold X number of this product. It might only have a row for each products monthly total.

[@Veigaburame]

5:55 is the part that I really want to hear !!!!

[@pubgcalling2000]

I don't learn about olap but I learn about data ware house and database 😅

[@sarathbinu5676]

❤

[@gigachad445]

Thanks i am more con now

[@pRoDlGy007]

What a stupid example