Here’s Hideo’s entry for Power BI Challenge 7. @Hideo, feel free to add other details of your work.
Here is the link to the report:
And here’s how Hideo described it:
This time I took Q&A style. When I was thinking how do I build report with having brief copied on the canvas, I thought this is a good idea to following the questions so I did not change any one word from the three key focuses.
Q1 Average delivery is 36.1days and can see further by clicking the vessel button.
Simple bar chart but try to stand out with having orange line which is a spike of slow delivery items.
I have try to focus on delivery days by items to make sure we consider those delivery days for the next re-orders.
I have try to explain as much as possible by narrative so the consumer can choose fast delivery and slow delivery items by using the Days slicer in the basis of average delivery 36.1 days.
Q2 Location is on the right end to make the most of the space.
Average storage is 15.9days and can go further by clicking the truck icon.
Same logic with Q1 has been applied on Q2.
Again I have try to stand out for the slow moving items delivery by orange bar.
By considering the average storage 15.9days, we can pick up fast moving items and slow moving items easily by using the storage days slicer.
For those slow moving items we would consider purchase quantity and timing for the next re-order.
Vice-versa, we need to consider to order more for the fast moving items.
Prepared two answers.
For the answer 1, by clicking the first chart button, billing details chart pops out to show the billing details by date. Orange lines are highlights when the big bill spike happens. (no image to save screen)
The 2nd chart button for Answer 2 is interesting.(Image as below) Because by changing the TOPN material number, pie chart is going to adjust as per your selection. Also Answer 2 itself is changing according the number entered. Number 50 is set up as a default which means top 50 materials dominates 81.0% of total billings.