DON'T Make These 5 Pivot Table Mistakes

~
Pivot Tables are a staple diet for data analysts all over the world. But are you ruining them with these 5 mistakes? In this video let's understand how 5 silly mistakes can make your pivot tables WRONG.

Video topics ⏱👇:
===============
0:00 - The 5 mistakes you make with Pivots
0:23 - Mistake 1 - Using cell ranges when making pivot
2:08 - Fixing the mistake with tabular data
4:03 - Mistake 2 - Just using default options
5:13 - Mistake 3 - Making a static pivot report
6:35 - Mistake 4 - Pivoting from just ONE dataset
9:43 - Mistake 5 - Not using Power Pivot
11:14 - Learning more about Pivot Tables

📗 Sample Workbooks:
===================
Practice the concepts using the sample workbook data here -

💻Learn more:
=============

~

What is Ross' favourite Excel feature?
PIVOT, PIVOT, PIVOT!

You have a beautiful day 🌞🌻😃

#Excel #PivotTables

[OhSugarwastaken]

Whoa...data model. I love this channel.

[pzetbiw]

I am happy to learn that I was using majority of these features on my day today work.
Measures was new to me and few shortcuts are also very helpful. Thanks for this video ❤

[ayobnubbee]

Thanks Sir Chundoo, with power query, I was getting no joy, build a relationship using the graphics but on the pivot it still gave me totals on all rows. This was quicker and better.

[Ohman]

All those copy paste to next column to find variance is gone from today :) Thank you for the video👏

[caraziegel]

I'm so glad that you keep showing up on my youtube front page. I have been using pivot tables on and off for decades, and even took a college course on excel in the middle of that . . but sometimes I forget, or features change when I'm not looking. I knew there had to be a way to combine tables and do calcs and change titles, but I was too lazy to look. I love your videos!

[stopthink]

Data models are a game changer. It is best to know details about "single to many" and "many to many" behaviors when building relationships. It would also be good to learn about primary key and foreign key when building out your reports. The data modelling /DAX measures features also come in handy in Power BI.

[mmightygyan]

Thanks for showing relationship creation.

[BalrogsHaveWings]

More great tips, thanks again Chandoo!
Random thought: When it comes to naming ranges, I tend to use a prefix to identify what it is... For example, a table name begins with "tbl", or a list name begins with "lst"...
I find this helps me sort of categorise my ranges, search and identify them easily.

[salehmuhammad]

Great Chandoo these really helpful to whom they just think statically now they have something to go out side the box.

[surajbhardwaj]

Pivot table makes data understandable in quick way... Today I learnt new tricks in pivot table...Thank you Sir...😀🙏

[christopherstich]

I’ve been diving into measures in Power BI, but I had no idea they were available inside of pivot tables. Tip #5 will change the way I work!

[sebghatulbarykhabaey]

Your teaching, Mike and Leila are most useful.
Thanks for your kind teachings.

[Pawar]

Very helpful video sir. Plz suggest do we have to have a good knowledge of excel before jumping into power BI

[keeloraz]

Yar this is really good. I knew when I found Chandoo's youtube channel it'll be awesome. Love this guy

[sp-uvkc]

Excellent tutorial on relationships. Thank you

[jobazooka]

OMG... at 05:18... the 'banded rows' option.... I never knew this one! Thx a bunch... that's awesome! :D

[godxavier]

This is so useful, especially the relationship between the two tables.

[ayotundeodunlami]

Many thanks Chandoo. Your lessons are right on point and very rich.

[hilmansyahbo]

Hi Chandoo... One thing I don't really like about Table, when the size of table is quietly big, the speed of Pivot Table when refreshed was impacted a lot. I prefer to use a normal range instead of table, but I used dynamic range (name range), so when the data adding, no need to change manually the source of the Pivot Table Range. One thing also I don't like about Table, when we working with macro, when the size of the table is big enough, the running speed of the macro also impacted.

[muhammadakteruzzaman]

@Chando you are my hero, please keep it up your good work-rest will be followed