Here’s the entry from one of our non-member participants, Vida.
Here is the link to the report:
And here’s how Vida described it:
Since materials from the same order were received on different dates and also sold on different dates, I analysed data at order-material level, instead of order level.
If the same material from the same order was received at multiple dates, the last date was used as a received date. Same strategy was used for billed material dates.
To avoid bi-directional relationships Purchase, Received and Invoiced tables were merged into one. Only Purchase table POs were matched to other tables, i.e. non matching POs from Received and Invoices tables were not included in the merged table.
Purchase to Receive Time and Receive to Bill time was calculated in PQ. I also grouped materials to Received & Billed, Yet to Bill and Yet to Receive.
Elapsed time was calculated in PQ and visualised as histogram by using bins feature.
Custom visual - Bullet chart was used to show tons purchased vs received vs billed and cost vs sales.
User can see a tooltip with more details in the tons visual. They can also select material from the visual and Value visual will be filtered.
To learn about the real-life scenario presented for the challenge, be sure to click on the image below.