Hi there. I'm new to PowerBI and trying to visualise (graphs and tables) the performance of a process over time, eg the trends by week of how much "value" moves through about six steps of a process from identifying a potential sale through the selling then delivering then billing.
The data I have is in two tables: a sales table with the dates that each unique sales opportunity moves from step one to step two etc, and the value is the monthly recurring revenue that it will be once delivered. The second table (delivery table) breaks the sales order into a number of services, that each then have a delivery date and a "first billed" date.
The output I'm hoping to build is for example:
This week, $20k worth of value was identified ie entered the first step of the process, $50k moved from step 1 to step 2, $30k moved from step 2 to step 3 etc. And therefore at the end of the week, $200k was sitting in the WIP bucket that had moved from step one to step two, but hasn't yet moved to step three.
What's the best way to visualise this, and what do I need to do to my data tables for it to work, including beinf able to filter by product, by sales person etc? Thanks for your help.