48 hours - Hestia - Basket Mismatch Analysis Results - Power BI Dashboard - 1/3

Challenge Objectives

Important: This is a very short challenge with only 48 hours of submission time!

We ran a datascience ideation challenge for Basket Itemset Mismatch analysis and would like to develop some dashboards to display the result from one shortlisted ideation submission in an interesting and compelling way using Power BI.
 

Technology Stack

• Power BI

Individual Requirements

Datasource
The result dataset is provided as csv file in the forum. Items in group, Missed items, Warehouse and other details are available in this csv. You can also assume a product lookup csv which will have the product names mapped for each ids in the items in group and missed items columns. Also for customers (V_CUST_ID) you can assume a lookup is available for getting the names.

Please note that your submission should work without these lookups also. So you can provide 2 versions if needed

Scope
Develop a visually appealing Power BI dashoard

• The dashboard should be able to view the items (batches) and missed items (exclusions) and clicking on them to get more details.
• Ability to filter out customers is required
• Ability to filter out warehouse is required

Please note that the winner will be selected by client and there won't be any appeals phase.
 

Final Submission Guidelines

• A summary document that explains the visualizations that you've created, their purpose, and any features you've added especially, ones that might not be completely obvious to users. You should also make sure that your submission is not breaking when we add a new datasource. You can document the steps to add new data to the dashboard.
• Power BI Dashboard file
• Any new data files you've created beyond the ones provided in the forums.  (optional)