I don't use PIVOT tables anymore... I use this other thing instead!

Подписаться 609 тыс.

Просмотров 1,2 млн

50% 1

That is right! I no longer use Pivot Tables in Excel. I am now using Power Pivot. In this video, let me show you what Power Pivot is and how to use it with Excel. Plus, you get to meet Chan2 again 😂
⏱ VIDEO TOPICS:
===============
0:00 - What is Power Pivot and how to create one in Excel?
1:12 - Why use Power Pivot instead of regular Pivot Tables?
3:25 - Practical example of Power Pivot & DAX
📺 LEARN MORE ABOUT POWER PIVOT & DAX:
=======================================
Beginner to PRO DAX Lesson with 20+ examples - • Learn Power Pivot & DA...
How to write measures in Excel (another example) - • Advanced Pivot Tables ...
My Power Pivot playlist - • DAX & Power Pivot Tips...
Advanced Pivot Table tips & tricks playlist - • Analyze data quickly w...
👩‍💻 LEARN MORE ABOUT REGULAR PIVOT TABLES:
==========================================
Introduction to Pivot Tables - Complete Tutorial - chandoo.org/wp/excel-pivot-ta...
Introduction to Pivot Tables with 8 examples - • How to use Pivot Table...
Pivot Table mistakes you shouldn't make - • DON'T Make These 5 Piv...
6 Pivot Table Tricks to Impress Everyone - • 6 Massively time savin...
Creating Pivot Tables when you have lots of data - • How to make pivot tabl...
How to use Slicers in Excel - • How to use Excel Slice...
📁 SAMPLE FILE:
===============
Here is an Excel workbook with data for you to practice Power Pivot concepts - chandoo.org/wp/wp-content/upl...
~
I made a pivot with average sales per day.
It was a mean report 😂
~
#pivottables #excel

Наука

Опубликовано:

3 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 483

@wirechair 10 месяцев назад

I used to use your forum/ website about 10 years ago to learn a lot about excel. It is amazing how the internet allow you to also come to youtube and do these further explainers and with a little sketch! Thanks for all your work and for being around all this time!

@peggymahabir6108 7 месяцев назад

I appreciate the way you bring across the content as if you are having a conversation, it made what could have been a complex thing to explain quite easy to understand. Thank you!

@stevendipietro2928 10 месяцев назад

This is the best explanation I’ve seen, especially around the mapping. Great job.

@Daithai96 11 месяцев назад

Always loved your website when I was working in IT - great to see you on RU-vid as well - you got me so many brownie-points with your dashboard tutorials. You are in my Hall of Fame of Excel heroes.

@chandoo_ 10 месяцев назад

Wow.. so good to hear that :)

@Daithai96 10 месяцев назад

@@chandoo_ Well, I did not expect a reply! Just wanted to let you know what a great job you're doing, please keep it up - tutorial/example sites like yours are invaluable to so many people

@ArunRajTutorials 11 месяцев назад

Love that you keep it original. Great video. Would help a lot of finance folks.

@senpai.5517 11 месяцев назад

Chandoo, awesome content, as usual. I like the way you have presented it and it was nice meeting Chan2! Good team work.👏

@benndii 11 месяцев назад

I have been working so much with Power Bi and M over the last few months that I nearly forgot about the excel basics. DAX in Power Pivot? I did not know about that but it gets a really BIG thumbs up from me. Thanks for showing.

@chandoo_ 11 месяцев назад

Great to hear!

@eldarikus 10 месяцев назад

Not only did I hit the Like button, but I also subscribed, such is the power of POWERPIVOTS!!!!!! and your awesome humorous video style. Good job bro! Well done! You are, in fact, awesome!

@manabsingha8153 11 месяцев назад

I like the sense of humour in you videos. This gives me a boost to see your videos more and more. Keep it up my Excel Master :)

@chandoo_ 11 месяцев назад

Happy to hear that!

@akashgautam1909 11 месяцев назад

Basically, it acts as an SQL query with join applied 😁

@eleghari 9 месяцев назад

And this data should have been in MSAccess in the first place...

@muralisub6534 8 месяцев назад

Why do we require 20+ years to have related tables

@ebred76 10 месяцев назад

This is great information and related to a project I want to do to track pieces at work. This is just what I need to track them with data across different table information that I have. Thank you

@firstname4337 11 месяцев назад

distinct count has been so useful -- makes things so much easier

@GeertDelmulle 11 месяцев назад

I use both types all the time. One thing I miss in PP is the grouping feature in the rows from std. pvt tables. Building that into PP requires a ‘more advanced’ knowledge of DAX. BTW: DAX as a formula language is quite cryptic IMO, or as Alberto F. puts is: DAX is simple but it’s not easy. Still, the added power of PP is undeniable.

@chandoo_ 11 месяцев назад

Thanks for that. Yes, we are not able to "Group" with Power Pivot tables. I show a trick to get grouping in this video 👉 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_J23sAGyztY.html

@GeertDelmulle 11 месяцев назад

@@chandoo_ Thanks for that referenced video. :-) The thing is: it is not generic enough: I use/need the grouping for creating histograms, which in std. Pivot tables is easy to do,… and to reconfigure on the spot. (Nowadays you can also use dynamic arrays for this, as well.) And I mean: for more than ‘just’ dates. In order to do this dynamically (variable bin size) you need to use more advanced DAX functions (…) If you have a way of doing that (and a video to show it), I’d be happy to watch it. :-)

@chandoo_ 11 месяцев назад

I understand. My preferred method is to use Power Query and create "conditional column" with arbitrary bucket boundaries. If you have Power BI, you can natively group values just like we did in Excel.

@chrism9037 11 месяцев назад

Great video Chandoo. I am also using Power Pivot a lot more, though I still use regular pivot tables for simple analysis.

@chandoo_ 11 месяцев назад

Glad to hear that Chris. :)

@anandchawda7061 10 месяцев назад

Hi Chandoo, very helpful…good to see your creative and funny side together!

@amraouigroup 2 месяца назад

Hi Chandoo, this is to thank you for the amazing, entertaining, and most importantly, instructive videos about Excel. You've truly succeeded in turning a dull technical subject into a funny and informative one, thanks to your talented humor and your smart and interactive scripts. Be brave and keep up the good work. All the best, my friend 😊👍🏻

@amaan-the-analyst 4 месяца назад

Thanks Chandoo bro! Always learning something valuable from your videos.

@faridqanet4709 Месяц назад

That is awesome! Your teaching skill is on another level.

@michaeldruce4536 11 месяцев назад

Thanks Chandoo. I’ve always checked the add to data table box but wondered where or what it did

@mandata143 11 месяцев назад

Didn't know Excel has this kind of power. Your content is 💯.

@franksims2037 4 месяца назад

I love his videos! He is a lot of fun and very informative! 🙂

@lorenakademar5267 3 месяца назад

Woow...great short and well explained video! thank you

@TheRacoon001 9 месяцев назад

Thank you for sharing and making the video! very informative and helpful.

@power-reconcile 16 дней назад

Great video! Thanks for sharing!

@Cricketer-007 6 месяцев назад

Love it. Thank you, Chandoo. You the best!!

@user12345654 8 месяцев назад

1:11 Even Superman looks like a normal dude until he puts on the underpants on top. Amazing quote ! 🤣 👍

@katemedina7123 10 месяцев назад

This is what I'm looking for before. Thank you for sharing this!

@h1tm4st3r5 11 месяцев назад

wonderfull man. Loved your video, you make everything looks easy!!! Congrats!!!

@davidsonmayck6937 6 месяцев назад

Thank you! You just helped me solve a huge challenge I had.

@silenceofharmony 2 месяца назад

:) Besides providing very useful information,I have a lot of fun while watching your videos.

@pjelbro3492 10 месяцев назад

Really good. Love the presentation style as well. Thank you

@nelzpelaez8517 11 месяцев назад

This is amazing! Easy to learn and easy to follow plus the antics. lol.

@prabhathkota107 9 месяцев назад

Beautifully explained in simple terms... learned something new, kudos ❤

@chandoo_ 9 месяцев назад

Glad to hear that

@danielnichols3594 11 месяцев назад

I still use Power Pivot every day even though I've moved on to Power BI. Measure portability and the advantage of DAX measures over calculated fields/calculated items in standard Pivot Tables are key selling points of Modern Excel, aka Power Pivot. And Power Query gives you reusability of data transformations so you spend less time manipulating data & more time analyzing your operations.

@chandoo_ 11 месяцев назад

AWESOME points... With "Analyze in Excel" you can build your models in Power BI and still have them available in Excel for reporting.

@indrajaravi6945 Месяц назад

Why did you move to Power BI?

@broderp 10 месяцев назад

This explained a lot. Thank you!

@abhinav10x 11 месяцев назад

awesome! I have little query for creating pivot table is their need "data in range" format or can be create in table format, as previously described data should be in range format, please advise

@dheerajpatel5906 9 месяцев назад

Amazing information Chandoo. Helping me a lot with my daily activities. Thank you for the information!!!❤

@FranFerioli 10 месяцев назад

Power Pivot and Power Query are very powerful indeed. My complaint is that it's a lot of clicking and submenus. Almost immediately you get into DAX (for Power Pivot) and M language (for Power Query). Alternatively, you can use Python to clean your data, calculate what you need and write an excel file for plotting and sharing. At the end it's a matter of personal preference, but I find Python applicable to a wider set of problems although it does not fully substitute excel (for me at least).

@shadowlynxv6082 9 месяцев назад

Wait. Can you stick Python into Power Pivot. And if so, 1:06 is it better than Dax or M?

@FranFerioli 9 месяцев назад

@@shadowlynxv6082 I don't think so and it is not what I meant. I use Python to format the data and write a table/excel file. It is then very easy to import clean data with power query in an excel file I use for visualisation (copy-paste also works for relative small sets). The problem with power query/pivot is that it becomes exponentially more difficult if you have to manipulate data.

@shadowlynxv6082 9 месяцев назад

@@FranFerioli oh. I see.

@dhrumil5811 11 месяцев назад

Excellent . I always learn something from you. 👏🏻

@davidingham2216 11 месяцев назад

Excellent video and a great presentation style. Thanks for sharing

@blanchebayla 11 месяцев назад

Your videos are always amazing Chandoo. Thanks for sharing!

@chandoo_ 11 месяцев назад

Glad you like them!

@AlabasterClay 9 месяцев назад

Awesome video. You're a great teacher. Thanks!

@coram6248 11 месяцев назад

You are the funniest excel instructor!

@agapheputrasusilo741 7 месяцев назад

What a life saver, thanks Chandoo !

@beesettigopikrishna6161 11 месяцев назад

Thanks Chandoo Sir for sharing such awsome and cool excel tricks.

@raimundojs9547 11 месяцев назад

Awesome! Indeed a game changer in Excel! Thanks for sharing.

@shindepratibha31 10 месяцев назад

Thanks for the amazing video. Is there a way to refresh pivot tables on the protected sheet?

@brijeshshah574 11 месяцев назад

Thanks for sharing such amazing knowledge 🙌🙏😇

@namy1557 11 месяцев назад

Beautifully explained with some interesting video creativity, Learning while enjoying watching videos is great fun.. Keep it up Chandoo.. 😇✌🏻

@dkypa 10 месяцев назад

You are the only guy made learn excel made like watching cartoons.

@Ed-zd2qb 8 месяцев назад

Had to click the like button for that, toing toing sound and expression... 😂😂😂

@SK-di6ti 11 месяцев назад

Thank you for sharing knowledge.

@galacticfunk42 11 месяцев назад

"Even Superman looks like a normal dude until he puts the underpants on top". You are wise beyond your years 🤣🤣🤣

@patrickcardon1643 2 месяца назад

First time someone managed to stuff underpants into power pivot tables ... super!

@soumyajeetmitra6958 4 месяца назад

Wow! great learning from you!

@user-kq3tc5tu1c 10 месяцев назад

Dooh! I really enjoyed clicking on the "Like" button. (Insert Chandoo's eyebrow movements!). Great job on this content. Cheers!😎

@neerajkapoor1050 11 месяцев назад

Have started power pivots and results are amazing

@chandoo_ 11 месяцев назад

Great to hear!

@sambarajkanaveni7312 11 месяцев назад

I too use Power Pivot but many people dont know this. .. Surely It helps Chandoo🎉

@DarkoVlajkovic 10 месяцев назад

I use both, depends on the need for the analysis, size of database, number of databases etc :)

@kossiviaglee2997 8 месяцев назад

I needed this. Now i know the difference between a simple pivot table and a Power Pivot table. Thanks!

@chandoo_ 8 месяцев назад

Glad it was helpful!

@cpajulio 10 месяцев назад

This is a great video. Love the humor too.

@harshitdhupia 11 месяцев назад

Respect to you Chandoo !! ❤❤ following you since 2007!!

@chandoo_ 11 месяцев назад

Wow.. Thank you so much for being with all these years 😍

@deniseherud 8 месяцев назад

this is mind blowing--thank you!!! i just inherited another role at my company, and the person who designed one of the spreadsheets i'll be using, wasn't a power user...this info is going to be lifesaving for me❤ Is there a limit to the number of columns i can use with power pivot??? i have a dozen or so that i'll be working with on a supercharged coverage file.

@sergioancaojr 11 месяцев назад

Awesome content.. very useful for us basic users of excel.. keep it coming dude. I love your humble approach on technical issues with 2 personality acting! I like the superman analogy..😂😂😂

@chandoo_ 11 месяцев назад

Thank you :)

@JohnMatthew1 4 месяца назад

Brilliant, thank you for this, helps a lot.

@DharshaniRajendran 11 месяцев назад

Your videos are mind blowing like always.. I have a doubt.. can we extract data from web which is in bar chart form?

@alfredtomiamubiaya3330 11 месяцев назад

Always awesome Chandoo. Thanks for awesome video always.

@patrickwheeler1979 8 месяцев назад

Thanks for putting this together.

@chrishorn9372 3 месяца назад

Thanks. Learn't something new about Pivot tables. Much appreciated.

@chandoo_ 3 месяца назад

You are welcome. Thanks for the super ❤

@bondniko 9 месяцев назад

It is so nice to talk to a smart person...

@Catsaresupergreat 6 месяцев назад

Thanks heaps, your videos are "Really"&"GREAT"!

@chandoo_ 6 месяцев назад

Thank you for the love and super :)

@lamiv1 11 месяцев назад

Hi Chandoo, is there any reason why am not able to view other table under All in the pivot table fields section?

@RFVisionary 11 месяцев назад

👍🏻 Very interesting hint. Funny made clip! 😊

@moutazeldeib9481 10 месяцев назад

Amazing Chandoo and thank you very much for all your valuable information

@RohitSharma-vi8fh 11 месяцев назад

Thanks for Knowledge sharing☺

@nikhilmehta2486 Месяц назад

Thanks. Is it counting distinct names?

@nadidecifci4533 11 месяцев назад

Awesome 👏 👏👏please do more videos about power pivot 🙌

@hamzahsayap8844 Месяц назад

Greatest explanation❤

@mdrinkwater 6 месяцев назад

Hi Chandoo. Is there a way to easily identify missing data after you make a connection? For example, if a number of employees do not exist in the department table?

@ashokkelkar4648 11 месяцев назад

Sir, pls make video about using "field items & sets" under power pivot set up. I m already using combination of Power query, Power pivot, Dax for financial analysis to check variance from LY to CY and ach% against AOP

@chandoo_ 11 месяцев назад

I don't use that feature. I suggest using CUBE formulas instead if you want a custom layout for your pivots.

@fireman194 2 месяца назад

That was pretty cool. Liked and now a subscriber

@shivangpant9639 9 месяцев назад

Really great explanation ♥️

@bandaralqahtani4356 6 месяцев назад

Chandoo Thank you for providing me with so much new information

@chandoo_ 6 месяцев назад

It's my pleasure

@shoaibrehman9988 11 месяцев назад

Gr8 video, Sir how can we define one to one relationship by using power pivot could you pls assist

@sivakumars8920 3 месяца назад

Nicely presented sir, and explained in simple language..

@chinyerenwigwe5166 11 месяцев назад

I know I discovered gold the first day I subscribed to your channel!!!

@culpritdesign 11 месяцев назад

Good stuff! Teaching the folks about data modeling and measures. You are doing amazing work for the people.

@chandoo_ 11 месяцев назад

Thank you for the lovely words :)

@mohammadparvezkhan2914 2 месяца назад

That effects around like button...was awesome...

@SAPMentors 11 месяцев назад

Very Nice. Interesting informative and yet fun to watch video. Great content man..

@mrejohn6344 11 месяцев назад

Wow this channel is improving. Now he adding extras in his videos. Hope it wasn't too expensive.

@SS-iq6yt 4 месяца назад

New learning for me. Thanks 👍

@chandoo_ 4 месяца назад

Glad to help

@abhilashn2993 10 месяцев назад

As usual Chandoo is back with wonderful video. Really missing "I saw my Boss" videos 😀...

@Luciano_mp 11 месяцев назад

Thank you Chandoo!

@GaboCh2000 6 месяцев назад

Funny and educational. Good job.

@xxxxxfirefoxxxxx 10 месяцев назад

wow you earned my subscribe. Very very useful, I'll be using this for work

@emonghosh4733 11 месяцев назад

It will enrich my excel Techniques.thanks❤

@jasonswami9275 11 месяцев назад

Love his training 😂

@orrorin9430 10 месяцев назад

5:45 I agree everything else but HR department has most tickets 😂

@brianspiller9075 11 месяцев назад

There are more differences than just adding to the data model. There are a few use cases that favor Regular Pivot tables. This is not to say PowerPivot in Excel is not worthwhile. PowerPivot is a new essential for Excel Analyst and introduces the knowledge to PowerBI.