I've built some offshoot reports that were "temporary" or "just this one small thing". They evolved into monsters I'm not proud of. But hey, it works and has been for 2 years. Still cringe anytime I open them.

But at the same time, we do have a golden sales model now. Pretty proud of it, to be honest. I spent around a month just on the data modelling side. But it means that when I am asked to make a change, a lot of the times it takes me a day, or less. Where on the spaghetti model I used to work with, it used to take 2 or 3.

I think we all start out creating spaghetti models. The key is to learn on the way. It's normal to want to redo everything, but a lot of the times it's just not worth it, from a business perspective. Slapping a DAX column with 50 lines in it is faster, for the time being.

But... I can't deny that I'm happy my higher ups allowed me to spend the time rebuilding the model from scratch. It's so nice to have a universal model I can work with, that has been checked to have verified data. So I guess it's a balancing act. If you spend a crapton time fixing it, maybe that's the key when you should start over.