OLAP Operations in Data Warehouse | Slice Dice Roll-up Drill-down Pivot | Example of location, time

OLAP Operations in Data Warehouse in English are explained here. Slice, Dice, Roll-up, Drill-down and Pivot are explained in English with the Example of location, time and items in this video of CSE concepts with Parinita Hajra
#olapOperations #rollUp #DrillDown #slice #dice #pivot #cse #cseconceptwithparinita
If you like my video contents, please LIKE, COMMENT, SUBSCRIBE and SHARE with your friends :)
In case of any specific doubt, confusion or discussion, you can anytime connect with me at:
Instagram: / computer_science_concepts
Whatsapp: chat.whatsapp....
Facebook: / parinita.hajra
Compiler design tutorials:
• Compiler Design for GA...
Theory of computation (TOC) tutorials:
• Theory of computation ...
Cryptography techniques tutorials:
• Cryptography Tutorial
Data Mining and Data Warehouse tutorials in Hindi:
• Data Mining and Wareho...
Data Mining and Data Warehouse tutorials in English:
• Data Mining and Wareho...
Artificial Intelligence tutorials in English:
• Artificial Intelligenc...
Artificial Intelligence tutorials in Hindi:
• Artificial Intelligenc...
GATE previous year important questions:
• GATE 2023 important co...
Data Compression tutorials:
• Data Compression Tutorial
Computer Networks tutorials:
• Computer Networks Tuto...
Technical job updates:
• Technical job updates
Digital image processing:
• Digital Image Processi...
Database management system tutorials:
• DBMS: Database Managem...
Data structures and Algorithms tutorials:
• Data Structure and Alg...
Programming questions:
• Programming
Digital electronics:
• Digital Logic
Informational and Motivational videos:
• Motivational Video
Keep learning, keep supporting 🤝✨💯

[@gouravgarg9809]

3:52 drill down
6:31 roll up
9:05 dice
10:18 slice
11:43 pivot

[@CSEconceptswithParinita]

Thanks for specifying 🙂

[@kalpanasivakumar6692]

Thanks😄

[@Saiteja-ll5bx]

I love you ❤️❤️❤️ ur Excellent in explaining ❤️

[@CSEconceptswithParinita]

😊😊😊

[@Neelansh2511]

You have made the concepts crystal clear within 15mins. Thank you:)

[@CSEconceptswithParinita]

Thanks for acknowledging 😊Keep learning, keep sharing✌

[@Hasi_era]

This is super clear. Thanks from Sri Lanka.

[@CSEconceptswithParinita]

You're welcome😊

[@niveditahajra9325]

You have made the topic crystal clear

[@CSEconceptswithParinita]

Thank you 😊

[@pkyadav6230]

Excellent explanation mam u should be one of the greatest teacher on RUclips

[@CSEconceptswithParinita]

Thanks for acknowledging 💫😊

[@manimarans176]

Thanks very use full to me.. Past 7days I was confused this diagram .. Now its very clear mind ...

[@CSEconceptswithParinita]

Glad to know that 😌
Keep learning, keep sharing ✌ 😊

[@mohammadarsh9342]

i'll be watching different videos again with confusion this video blessing for me
Thank You so much

[@CSEconceptswithParinita]

Keep learning, keep sharing 😊

[@mohammedarshad9318]

The Lecture was amazing thanks alot saved lot of my time!!

[@CSEconceptswithParinita]

My pleasure! Keep learning, keep sharing ✌️ 😊

[@jawidmusic.7ce]

today I have data warehousing mid term exam and this explanation was superrrrrr. thanks didi

[@vaibhavc1110]

Thank you so much for this great explanation, got a perfect video of the OLAP operation.🙏

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌️😊

[@sakthiponvigneshm604]

one of the best explanations i ever heard

[@CSEconceptswithParinita]

Thanks for acknowledging 🙂
Keep learning, keep sharing ✌️

[@djtillu6461]

Wow really great explanation ....adding definition to each opearation is much more better

[@CSEconceptswithParinita]

Yup. Keep learning, keep supporting 🤝✨

[@djtillu6461]

@@CSEconceptswithParinita mam we need types of data in data mining tmrow we have exam can u plase share any link about that topic right now it's emergency

[@CSEconceptswithParinita]

Which topic?

[@djtillu6461]

@@CSEconceptswithParinita types of DATA

[@krishmba06]

This is really amazing video - Simple but very effective in learning the OLAP commands - Thanks a lot for this informative video.. Please keep up the good work !!!

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@anveshgundapaneni4393]

Good explanation mam. Thank u so much

[@CSEconceptswithParinita]

Keep learning, keep sharing 😊

[@pavanmadamset]

Parinitha Madam, We Are Gratul For Creating Useful Video With Helpful Diagrams, Examples And Explanation

[@CSEconceptswithParinita]

My pleasure ! Keep learning, keep sharing 🙂

[@manshree_is_live]

Thank you for this video mam.....
Keep teaching us on YT
This efforts means a lot 🙏❤
You are simply amazing mam

[@CSEconceptswithParinita]

Keep learning, keep sharing 💫✌️

[@sankalpinfotech1622]

Great information given by you madam, very nice 👌

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@VenkyChalla123]

The way u teach is Too Good

[@rishabhjain2532]

best explanation on the internet ...

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@w0rdy007]

Fantastic breakdown and really well explained using the diagrams!

[@CSEconceptswithParinita]

Happy to help! Keep learning, keep supporting 🙂🤝

[@krishnagupta4847]

Thank you for this super easy and clear explanation

[@CSEconceptswithParinita]

My pleasure! Keep learning, keep sharing 😊

[@ChabPoha]

Wonderful Straight to the point No doubt please solve some numericals in it

[@CSEconceptswithParinita]

Okay, I'll try

[@javieraguirre9135]

thanks, a really clear and straight explanation

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌😊

[@psbhuvaneswari196]

Thankyou so much sister. It's very clear and understandable

[@CSEconceptswithParinita]

You are welcome 😊
Keep learning, keep sharing!

[@thilangajayarathne6575]

Thank you madam. Its really helpfull for me to understand this concept crystal clear

[@CSEconceptswithParinita]

Happy to hear that😊 Keep learning, keep sharing ✌

[@yasamanderiszadeh902]

This helps a lot, thank you!

[@CSEconceptswithParinita]

You're welcome. Keep learning, keep sharing ✌😊

[@yasamanderiszadeh902]

@@CSEconceptswithParinita I have emailed you :)

[@MahalakshmiA.H.]

Very clear thank you so much mam it is very use full 🥰😇

[@CSEconceptswithParinita]

Keep learning, keep supporting 😁

[@garcialyndone8666]

Wow you're amazing!!! Thank you so much. You're of such enormous help ❤️

[@CSEconceptswithParinita]

I'm glad to help you 🙂
Keep learning, keep sharing!

[@Jeevansaradhy]

Thankyou very much madam💞

[@CSEconceptswithParinita]

You're welcome. Keep learning,keep sharing ✌😊

[@devikagowda2521]

was really helpful. Thank you so much!

[@CSEconceptswithParinita]

Happy to help 🙂 Keep learning, keep supporting ✨

[@gouduavinashgowtham5430]

Nice explanation mam. Thanks form North Korea

[@CSEconceptswithParinita]

Most welcome 😊 Keep learning, keep supporting ✨

[@kalyanijaanu7064]

Thank you mam

[@CSEconceptswithParinita]

Keep learning, keep sharing 😊

[@Naveen1908]

Thank You Ma'am.... Really it helped me a lot to understand this concept. Love💚

[@CSEconceptswithParinita]

I'm glad to know that 😊
Keep learning, keep sharing ✌

[@Gmloverff]

Very good explanation

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@erickfajar8930]

very well explained, thank you!

[@CSEconceptswithParinita]

Glad it was helpful!

[@christinelee54]

Very helpful. Thank you!

[@CSEconceptswithParinita]

My pleasure! Keep learning, keep supporting ✨

[@sky.lovers]

Thank you so much !!! really helpful

[@CSEconceptswithParinita]

Glad it helped! Keep learning, keep supporting ✨

[@Mo_hazard]

great video may god bless you

[@CSEconceptswithParinita]

Keep learning, keep sharing 😊

[@attitudeboy2840]

Thank you for your valuable information ✨✨✨✨❤️❤️💗

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌️ 😊

[@lalaschannel4283]

chaa gai hain aap mam dill jeet lia

[@CSEconceptswithParinita]

Keep learning, keep sharing 🙂

[@kareemsharawi4778]

Excellent explanation, thanks a lot.

[@CSEconceptswithParinita]

My pleasure 😊 Keep learning, keep supporting 🤝

[@heyankitrajput]

Best Explanation!!

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@arhammehta4400]

thank you so much for your information

[@CSEconceptswithParinita]

You are most welcome. Keep learning, keep supporting ✨

[@sriharismart9255]

Very clear explanation. Thank you!

[@CSEconceptswithParinita]

My pleasure! Keep learning, keep supporting ✌😊

[@MahmudHasanSajeeb]

Now it is very clear. Thank you. :)

[@CSEconceptswithParinita]

My pleasure😊 Keep learning, keep sharing ✌

[@ancyjames3519]

Well explained

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@mariam7677]

really clear,thanks

[@CSEconceptswithParinita]

Happy to help! Keep learning, keep supporting 🙂

[@somalasrestha1283]

SUPERB!!!
Thanks a lot!!

[@CSEconceptswithParinita]

My pleasure 😊
Keep learning, keep supporting ✌😊

[@karliehu7115]

this is very clear, thank you!

[@CSEconceptswithParinita]

My pleasure 😊

[@DDTFVibhishALKRamani]

Thanks! good
explanation

[@CSEconceptswithParinita]

Keep learning, keep sharing 😊

[@itssumairashaikh723]

Thank you so much ❤

[@CSEconceptswithParinita]

My pleasure! Keep learning, keep supporting 😊

[@yogeeswarareddylomada8781]

Very well explained

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌ 😊

[@avigangurde4398]

awesome
explanation

[@CSEconceptswithParinita]

Keep learning, keep supporting 😊

[@maramalamri1187]

Thank you this is very clear explanation :)

[@CSEconceptswithParinita]

Keep learning, keep supporting ✌😊

[@madhawapriyashantha3722]

Thanks .Fine

[@CSEconceptswithParinita]

✌😁

[@sudiptahajra8974]

Thank you so much mam

[@CSEconceptswithParinita]

My pleasure 😊

[@user-ls5yp8zt3e]

THANK YOU SO MUCH

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌️ 😊

[@fatmasliti2161]

thank youu so much , you helped me a lot

[@CSEconceptswithParinita]

Happy to help 🤝🙂

[@praveennair1]

Great Explanation thanks.

[@CSEconceptswithParinita]

My pleasure 😊Keep learning, keep sharing 😊✌

[@cartoonistprakash]

Good |One, it was helpful

[@CSEconceptswithParinita]

Thanks 😊 Keep learning, keep sharing ✌

[@sasikumar-rh4yn]

Clear explanation 🥰🥰

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌🙂

[@amg....]

Impressive

[@CSEconceptswithParinita]

Keep learning, keep supporting ✨

[@vruchikakamble8131]

Thank you mam❤

[@CSEconceptswithParinita]

Most welcome 😊 keep learning, keep supporting!

[@5c1_ganesh5]

I passed my exam tanq so much

[@CSEconceptswithParinita]

Glad to hear that! Congratulations ✌ 😊

[@5c1_ganesh5]

@@CSEconceptswithParinita i will suggest to my frnds ✌️

[@CSEconceptswithParinita]

Thanks🤝🤝🙂

[@rrahulrroyr]

Well explained !!

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@lakshminarayana4652]

Mam could you tell me what exactly is the pivot does I don't understand because u told that it's just a rotation what is the advantages of the rotation please reply

[@ramadevirongali6776]

Superb mam ❤

[@CSEconceptswithParinita]

Keep learning, keep sharing 😊 👍

[@mengistumekuria1463]

thanks very intersting

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌️ 😊

[@sreekurmamniharika9147]

Excellent

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌😊

[@dhananjayag.m5124]

thank you very much

[@CSEconceptswithParinita]

My pleasure! Keep learning, keep sharing 🙂

[@techy_cop]

Relly helpfull

[@CSEconceptswithParinita]

Keep learning, keep sharing 🙂

[@suryar8673]

❤️ thank you✨

[@CSEconceptswithParinita]

My pleasure 😊 keep learning, keep sharing✌

[@angmathew4377]

you are gem, Thanks for sharing

[@CSEconceptswithParinita]

Keep learning, keep supporting ✌😊🙏

[@angmathew4377]

@@CSEconceptswithParinita Please put this on linked in network and it will spread all over places very soon.

[@CSEconceptswithParinita]

Oh okay, I'm not sure how it will work

[@angmathew4377]

@@CSEconceptswithParinita youtube video link on your linked in profile comments or shared area and th en ask any of your connection to like. You video is must have for IT and data science professionals. So users will start watching on youtubs via linked in.

[@CSEconceptswithParinita]

Thanks for the suggestion, I'll definitely try 😊

[@ameyuplenchwar546]

Good Explanation

[@CSEconceptswithParinita]

Thanks for acknowledging 😁

[@rabisubedichettri7217]

Thank you

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌😊

[@Lakshmiprasd436]

your voice is nice

[@CSEconceptswithParinita]

Haha thanks

[@atharavdeshmukh5777]

Nice explanation 👍🏻

[@CSEconceptswithParinita]

Keep learning, keep sharing 🙂

[@dritonsinani2223]

Super clear!

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌😊

[@EnochWorkineh]

🔥🔥🔥🔥🔥🔥🔥

[@adityapatil6723]

grate work didi

[@CSEconceptswithParinita]

Keep learning, keep supporting 🙂

[@ayesharaja5065]

Amazing

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌ 😊

[@varshinisalian3214]

Very nice explanation ❤️

[@CSEconceptswithParinita]

Thank you 💞
Keep learning, keep supporting ✌

[@dhulipalaj]

Super explanation

[@CSEconceptswithParinita]

Keep learning, keep sharing 😊✌

[@kasabhavya3277]

Tquu mam

[@CSEconceptswithParinita]

Keep learning, keep sharing ✌😊

[@sk-ne3vp]

Masss 💥

[@roshini7369]

For pivot should we rotate only in anti clock wise or in any direction ?

[@logann124]

Very nice

[@CSEconceptswithParinita]

Thanks!

[@kbarbier4946]

Thanks to have provided a course in full english and not some random hindi/english/i don't know wtf langage mixture

[@CSEconceptswithParinita]

I'm happy to help😊

[@trendwatchers24]

Please tell about other two
Drill across
Drill through

[@benjaminkovackeber]

Very good content.

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@The_Mitnick]

🤩

[@yashumithun760]

Thank uh mam

[@CSEconceptswithParinita]

Happy to help :)

[@RithikaGopikrishna]

so good!

[@CSEconceptswithParinita]

Thanks for acknowledging 😊

[@Shnjrr1234dona]

can i know to which process you made this example
for

[@vickym2789]

👍🏻🤝🏻💯

[@gustavomartins007]

Incrível, Muito bom! \o/

[@rajkashyap1513]

I recommend to my teacher watch this video 😂

[@CSEconceptswithParinita]

😅😅

[@trendwatchers24]

Nice voice

[@osknowledge2836]

mam you had written New work instead of New York

[@gurunadhan2666]

Uma 🙏🏽😭