View on Pivot table
Hey monkeys - just joined consulting from Finance and noticed that everyone is using pivot table.
As far as I remember, I have never seen anyone using pivot in my previous role..
What are your thoughts - are Pivot table good practices?
Helps manipulate data - I use it a lot
Also made the switch from finance to consulting. Everyone uses pivot tables, it's normal. For how we use them to simply sort and map data, it works plenty well enough. Honestly, now that I think about it, we could probably get more done actually just burying into SQL or Python, but this is consulting after all and our industry isn't exactly known for being the most technically savvy.
I used pivot tables all the time at MBB when we needed data to be cut quickly. Best practices that I had were:
1) Don't touch the raw data or modify it
2) Add columns to raw dataset when you need additional calculations done, or when you need to group things in certain ways
3) Create a separate sheet foor any index/match lookups
4) Create a pivot table on the raw data plus the new columns you added
5) Format appropriately
6) When you need additional pivot tables in new sheets, just copy and create a duplicate of that sheet, don't make a new pivot table, saves time
Suscipit eos velit voluptatibus laudantium delectus. Laboriosam in quos sequi eveniet aut veritatis. Molestiae animi et beatae dolorem enim cupiditate quis dolorem. Mollitia deserunt illo tempora perspiciatis. Aut aut delectus id aut ut quis. Maxime est et aut fugiat. Earum est sed sed sequi placeat optio.
Asperiores sit a in labore quaerat ipsa. Sint quisquam voluptas aspernatur quasi. Unde corrupti enim autem et ut. Molestias quibusdam est quis vel. Quidem accusantium fugit sunt quidem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Et ipsa voluptatem eos non consequatur. Voluptas occaecati repellat consequatur enim. Ut ut dolorem qui voluptas eligendi aut. Qui consequatur repudiandae aspernatur. Consequatur fuga recusandae quaerat quod earum. Modi possimus fugiat aut possimus.