Challenge Summary
Welcome to "DViz - Shipment vs Consumption Dashboard Design Concepts Challenge". In this challenge, we are looking to explore design concepts for a new Data Visualization Dashboard that will be implemented using "Microsoft Power BI".
We recommend you to start by digging into data visualization design best practices, research Microsoft Power BI and think about creative and insightful ways to provide data visualization experiences.
We are really excited to kick off this new DViz Design Concepts Challenge.
Round 1
Submit your initial designs for a checkpoint feedback
- As a part of your checkpoint submission, you must upload your submission to MarvelApp so we can provide direct feedback on your designs.
- Make sure to include a URL/comment the link to your marvelapp while uploading your submission
- Make sure all pages have the correct flow! Use correct file numbering. (00, 01, 02, 03)
Round 2
Submit your final designs with all checkpoint feedback implemented.
- As a part of your checkpoint submission, you must upload your submission to MarvelApp so we can provide direct feedback on your designs.
- Make sure to include a URL/comment the link to your marvelapp while uploading your submission
- Make sure all pages have the correct flow! Use correct file numbering. (00, 01, 02, 03)
In this challenge, we are looking to design a creative (and useful) data visualization dashboard. Our new Shipment vs Consumption data visualization dashboard provides the user with a single tool where they can view and analyze 2 core data sets that are not commonly located in the same data store. This will make it easier for the respective users to analyze the data in an intuitive way which will help them with their day-to-day operations or whenever they need them and also understand the requirements for effective planning.
We have taken the time to list out the user needs and to help you understand what is important to them and what would be important in the dashboard.
Background Overview
- The sales data (shipment) and scan data (consumption) reflect the amount of product being sold from a manufacturer to the retailer (shipment) and retailer to consumer (consumption).
- Users would access the data on an as-needed basis, it is more of an ad-hoc report. The user would access this at any time during the day (as opposed to wanting to see it first thing).
- Reports will be created using Power BI
Design Considerations
- Try not to have too much information on your dashboard, you can make them compelling by making the visualization interactive and enable users to walk through or drill into the different insights.
- Use color, visual comparison, and drill-down charts to highlight comparison.
- Have your designs of size: 1366 x 768px (Desktop only, Power BI is responsive by nature so just need to design/ build once)
- Colors and branding are up to you - do some analysis in this area of what colors work well for Data Visualizations.
DViz Sample Data:
We have attached a spreadsheet with sample data that you can use in your data visualization report. Data is identified by which Retailer, SKU, and Date period the transactions we captured against. SKU level data can also be aggregated to PPG or Brand level.
Required Dashboard & Functionality
- Clean, intuitive dashboard with a modern look that separately reports shipment data to consumption data, but also includes a direct comparison of the data.
- Viewing data at different levels of aggregation in a chart/tabular forms, filtering data, drill up/down.
- Year on year or previous year comparisons
- Immediate refresh of data on a report when filtering or drilling up/down.
Required KPI's:
Below are the required KPI’s in the dashboard
Home/Dashboard:
1. Visualizing shipment data next to consumption
- Shipment and Consumption are two datasets that are usually viewed separately but this new dashboard is all about coming up with a comparison view of the shipment Vs consumption
- Looking forward to your ideas on how this can be shown
2. Total Shipment Quantity / Amount
3. Total Consumption Quantity / Amount
4. Market share between Retailers
5. Market share between Brand
6. Market share between PPGs (Promoted Product Groups)
7. Difference (Gap) between Shipment and Consumption volumes
Above KPIs will allow users to identify if the source data is being captured accurately by analyzing at different levels of aggregation (as mentioned Data is identified by which Retailer, SKU, and Date period the transactions we captured against. SKU level data can also be aggregated to PPG or Brand level)
Category View
Commercial Performance
- Net Revenue
- Growth
- Channel Mix
- Being able to filter Retailer/Brand/PPG/Date data selection in a report and/or drill up and down data sets. Focus on volume comparison.
- We need to identify trends in gaps between shipment and consumption volumes.
- Access data in chart and tabular forms to assist in validation.
Target Audience
- Users the Key Account Managers and Business Analysts who work for our clients.
- The clients are FMCG manufacturers that sell their products direct to Key Account Retailers across different markets such as Europe / USA / Asia.
User should be able to:
- To analyze their data to ensure that data is being captured accurately as the same data is also used separately to this dashboard as key inputs into other promotion level reporting and machine learning algorithms.
- Update/correct mappings of SKUs to EAN in systems such as AC Nielsen. Refresh calculation of uplift and cannibalization models within Optimize for account/sku combinations where additional data has been captured or where a significant change in data trends has been identified.
Important:
- Keep things consistent. This means all graphic styles should work together.
- All of the graphics should have a similar feel and general aesthetic appearance.
- Focus on User Experience / how a user interacts within the dashboard.
Reference
Example dashboards designs reference for your considerations:
- https://community.powerbi.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery
- https://docs.microsoft.com/en-us/power-bi/service-dashboard-create
- https://id.pinterest.com/steffuhnee/power-bi-dashboards/?lp=true
- https://dribbble.com/powerbidesign
MarvelApp Prototype
- We need you to upload your screens to Marvel App
- Please send your Marvel app request to csystic@gmail.com (Challenge Copilot)
- You MUST include your Marvel app URL in notes /comments while uploading (in your marvel app prototype, click on share and then copy the link & share it within your notes while you upload).
Judging Criteria
- How the dashboard shows the data and relationships
- How well you plan the user experience and capture your ideas visually.
- Cleanliness of your graphics and design.
- The overall design, UI and user experience.
- Consistency across the UX/U
- How well you interpret the example screens (business relevance) and show us new ideas and concepts.
Submission & Source Files
Preview Image
Please create your preview image as one (1) 1024x1024px JPG or PNG file in RGB color mode at 72dpi and place a screenshot of your submission within it.
Submission File
- Submit JPG/PNG for your submission files
- Submit Marvelap as part of your submission.
Source Files
All original source files of the submitted design. Files should be created in Adobe Photoshop, Illustrator, XD, or Sketch!
Final Fixes
As part of the final fixes phase, you may be asked to modify your graphics (sizes or colors) or modify overall colors. We may ask you to update your design or graphics based on checkpoint feedback.
Please read the challenge specification carefully and watch the forums for any questions or feedback concerning this challenge. It is important that you monitor any updates provided by the client or Studio Admins in the forums. Please post any questions you might have for the client in the forums.