Forum Discussion
Power BI Challenge 4 - Delivery App Review
Hi Sam,
I took already challenge 3 and think it is really good that you opened the competition for challenge 4. Thanks!
Main point for both challenges is that you can show some change and best some improvements between start and end. For this challenge "my consultancy" has a problem as the app usage since implemantation
- has no visible positive effects on the time being spent at a store
- has not increased (low acceptance: difficult to use?)
=> Demonstrate that the Label Damage has increased as well! I used quarter to avoid any outliers. In the beginning people, will pay extra attention, so it makes sense to regard bigger time frames, but you can also select 2 months or just 1 month in the first and second period [filter in the lower right visual - s. second screenshot].
The data is quite evenly distributed, I assume that is because the data was created with some random function. E.g. a histogram of the duration in 5 min bins does not show a realistic distribution, which could be used to generate meaningful insights. Even the number of issues (label damage, damage, returns) does not seem to negatively impact the time being spent at a store: A perfect delivery takes more time than deliveries with issues. Weird.
=> I concentrated on the main requirements and added two visuals showing the influence of day of the week plus time of the day.
I found with decomposition trees that the biggest impact on the time being spent at a store and other KPI is the store itself.
=> The required KPI are shown on store level. You can select one or more warehouses to check warehouse store combinations.
I wanted to create a one pager and tried to keep it as simple as possible. Simple includes also the colour scheme [if there were more interesting findings, I could have used probably a more high-lightening colour for them - s. second screenshot].
Please let me know if you have any questions or feedback and suggestions.
Thanks again!
Screenshot with 2 warehouses selected.
Screenshot with signal colour and 2+2 months selected
This is one of the entries we received for this challenge:
Mudassir Syed Rashid Ali
https://app.powerbi.com/groups/me/reports/d4da36cc-0035-4f4f-9b3a-8ba6f6a16ff9?ctid=2342efc5-e1b1-4fae-9a72-5a0432948e85