Power BI Challenge 4 - Delivery App Review

[EnterpriseDNA]

Hi everyone! 

Here is the 4th installment of the Enterprise DNA Power BI Challenge.

Remember it's open to everyone so don’t be afraid to get stuck in.

To learn more about the challenge and how it works be sure to check out the link below!

Remember: The weekly winner will receive a complimentary Enterprise DNA membership that they can use or share with anyone. Plus, an opportunity for the work to be showcased across our channels. 

THE BRIEF

You are working at a consultancy that implemented an app for a client to help them improve their delivery process and fulfillment from warehouses to store.

The app was created so that drivers could scan the label as opposed to entering it manually while also recording the time of arrival, the time they left the store, and some other variables that the management was interested in improving.

The management is now looking to evaluate how the business has reacted and how effective the app is.

The senior consultant has extracted all data from the app and placed it into the file as below.

He now wants you to use this data and create a report or dashboard to help management visualize what is happening so that we can decide what the next stage of the transformation is.

The management is particularly interested in any warehouse store combination that it’s not working well for.

• The time being spent at a store.
• The number of times manual entry was still used.
• The number of damaged labels
• If returns are being collected

A 1 in the data represents true

A 0 represents false

The ball is now in your court and you need to find a way to present this data here.

Objective: Produce a report which can help review the effectiveness of the app.

The data set can be downloaded below.

Challenge 4.xlsx 

SUBMISSION DUE DATE - Sunday, 26th July 2020 (PST)

How to join:

1. Post your report in this thread.

2. Submit your PBIX files to powerbichallenge@enterprisedna.co

Use this subject: Power BI Challenge 4 - Name (Member) if you are an Enterprise DNA member and Power BI Challenge 4 - Name (Non-member) if not an Enterprise DNA member

3. If you're currently NOT an Enterprise DNA Member, additional steps are required for you to follow to increase your probability of winning.

a. Post on your social media accounts this caption: I accepted Enterprise DNA's Power BI Challenge 
Make sure to hyperlink this post - https://community.powerbi.com/t5/Desktop/Power-bI-Challenge-4-Delivery-App-Review/m-p/1229835#

b. Use these hashtags on your social media post - #EnterpriseDNA #EnterpriseDNAPowerBIChallenge #PowerBIChallenge #PowerBIChallengeAccepted
c. Change your profile pic for the 2 weeks duration of the challenge to this image.

***Please note that not following these 3 steps may decrease your probability of winning. 

Best of luck!

Any issues or questions please reach out.

Sam