You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
-
I think once all our systems are aligned by early next year (and running smoothly) the system(?) that tracks this will throw out all the data and all sorts of cool things. It's just in the meantime we're stuck with a manual checking function and me making a pretty spread sheet to give someone a monthly snapshot.
hugo7
hurricane_run
I hired a data analyst two years ago who fundamentally changed my understanding of what excel was capable of. I found power query quite intuitive but power pivot more challenging. The real answer to these data questions is to use a direct analysis tool connected to the DB.