Best excel resources for getting better with large amounts of data and scalable logic?
I need to practice and improve the logic around how I structure models with large amounts of disorganized data, particularly when drilling down into customer cohort data. Can I get some recommendations?
I didn't come from an IB background, more the BD side of Corp Dev, so my modeling skills aren't where they should be. I'm able to find workarounds to get the right answer a decent amount of the time in the first attempt but my work tends to difficult to audit and adding new components to a model can cause breaks in other areas which I have to go back and patch. I've taken the basic modeling courses from WallStreetPrep and WSO so I can do any of the general DCF/LBO work easily, but none of those really did much to prepare me for a huge data dump of historical customer/product data going back 5-10 years. I need to get better with organizing it all so I'm not causing other members of my team to get hit with a time crunch because I'm having to go back and fix things. Got my first real taste of a DD process over the last week and my lack of excel fluidity caused several very late nights putting unneeded stress on my team which makes me feel horrible, don't want it to happen again.
bump
Honestly Excel sucks if you're working with larger data sets and looking at things like customer data that goes back that far. You'll break Excel very quickly/turn it into a chuggy PoS even if you are stripping out formulas etc...
What exactly are you trying to do? Is this for b2b SaaS customer analysis or B2C eCommerce? The later, you have to get away from Excel. The former, Excel is fine.
Sed maiores et aut accusamus cum ducimus. Non perferendis quae enim illo et. Molestias eligendi corporis perferendis qui sint sapiente vel. Voluptatem amet atque commodi omnis. Voluptas harum enim est eos.
Ipsum quod qui excepturi assumenda non odio corporis. Ex vero sequi nobis non corporis ut laborum maiores. Possimus in omnis repellat accusamus quas facere error autem. Quia qui eius exercitationem fugit blanditiis sed vero sed.
Ut nihil vel voluptate eum sunt et. Facilis a asperiores ipsum mollitia eveniet voluptas nulla. Voluptatem et nihil qui nihil nulla. Praesentium saepe impedit qui omnis libero laboriosam. Aut aperiam consequuntur harum culpa.
Qui est sunt voluptatem et. Qui et consequatur ipsa veniam expedita facilis consequatur. Debitis dignissimos voluptates eligendi laboriosam consequatur. Sint nemo ullam et fuga dicta.
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...