JUNO - DViz IT Vendors Power BI Dashboard Design Concepts Challenge 5

Welcome to the  "Juno - DViz - IT Vendor Power BI Dashboard Design Concepts Challenge 5".

In this challenge, we are looking to create dashboard visualizations for the IT Vendor.
Read the challenge specification carefully and watch the forums for any questions or feedback concerning this challenge. Let us know if you have any questions in the challenge forum!

This is the 5th and final challenge in the JUNO DViz series.

CHALLENGE OBJECTIVES

• Web Application
• 3 Screens

Round 1

Submit your initial designs for a checkpoint feedback

• As part of your checkpoint submission, you must upload your submission to MarvelApp so we can provide direct feedback on your designs. Please include the MarvelApp URL in your notes.txt
• Make sure all pages have the correct flow. Use the proper file numbers, (1, 2, 3, etc.)

Round 2

Submit your final designs with all checkpoint feedback implemented.

• As part of your Final submission, you must replace your checkpoint submission with the final submission into MarvelApp so we can provide direct feedback on your designs. Please include the MarvelApp URL in your notes.txt
• Make sure all pages have the correct flow. Use the proper file numbers, (1, 2, 3, etc.)
• If you're not submitting in the Checkpoint/Round 1, you are not eligible to submit in the Final/Round 2

CHALLENGE OVERVIEW:
Our client is a large global insurance company focused on these core business segments: Global Life and General Insurance. 

Users of this IT Application Operations will be used by the COO and their main intention is to get a quick look at the dashboard and get an outlook of the overall application operations across different countries in Europe (Belgium, Netherlands, France, Finland, Sweden, Norway, South Africa, and Russia).

AUDIENCE:
Chief Operating Officers (COO)

DESIGN GOALS & PRINCIPLES
Below are some of the goals:

• These datasets require a design that can display a lot of table data, in lots of rows.  While this is true, try not to have too much information on your screen, you can make them compelling by making the visualization interactive and enable users to walk through or drill into the different insights.
• Elegant, clean, simple, user-centered look and feel with modern aesthetics
• Use color, visual comparison, and drill-down charts to highlight comparison.
• The overall design and user experience
• Engaging and easy-to-use/interact UI
• How well does your design align with the objectives of the challenge?

EXPLORATION SCORE
In terms of expectations, we would like to measure the concept against the following in the one to ten scales (ask the client to rate each of the parameters):

Creativity: 10
1: barely new ideas
10: a utopic product but with features that can be fully implemented

Aesthetics: 8
1: low-fidelity design, wireframe or plain sketch
10: top-notch finished looking visual design

Exploration: 8
1: strictly follow an existing reference or production guideline
10: open to alternative workflows/features not listed here that would help the overall application

Branding: 8
1: don’t care at all about the branding just functionality
10: without a properly branded product there is no success

BRANDING GUIDELINES
Please use the branding that has been provided in the forums

POWER BI REQUIREMENTS

• All principles of good UX design e.g. minimize user clicks, make the experience more intuitive, minimal time to reach desired selection criteria, store user selections for multiple reports and performance, good color and font themes, etc, these are all critical success factors for this challenge.
• Needs to follow Power BI Design Best Practices and also take a look at the Design Tips
• Please do some research on the Power BI software and get familiar with its purpose, limitations, and what's possible.
• You can reference this video about Power BI.

REFERENCE
Example dashboards design reference for your considerations:
- https://powerbi.microsoft.com/en-us/
- 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

TARGET DEVICE
Desktop: 1366px width and height 768px

REQUIRED FEATURES:

• Intuitive experience for end customers
• Developer friendly and easy to build designs
• Easy to translate to Microsoft Power BI reports.
• Allow a different variety of charts and data visualization. Think about filtering, sorting, and exporting the data.
• User will be accessing this dashboard on a Monthly, Quarterly (once in a week) basis

SCREEN REQUIREMENTS
For this challenge, we are looking for the below screens to be created in your submission. The functionality details listed below need to be included in your solution:
Please don’t show any maps in your designs as COO for that specific country will view data only specific to that country. Below is the list of countries for which we will be using the dashboard.

• BENE: Belgium & Netherlands
• NORDIC > drill-down to a single country in Nordic: Denmark, Norway, Sweden, Finland, and Iceland, as well as the Faroe Islands
• France
• Russia
• Netherlands

1) IT Vendors:
Required KPI's for this dashboard:

a.Critical Service Level Measurement
Please refer to “2.1 Critical Service Level” in eWPIV SM03 GCC Service Level Report Jan-21 - BD10.xlsx

We need to show a visualization for the list of services that achieved the target
Each of the services will have to Monthly target and this specific target will have the minimum and expected duration & target %.
Show the expected and minimum target % for the previous 6 months.
Based on whether they have reached or not will be shown as a color code.

NOTE: In the current sample provided, you will see this as a table but in this challenge, we are looking for your help to show it as a visualization. Think through how best we can show this in your dashboard.

Let’s take one of the examples service desks, “speed of answer” comes under this category, and
The expected target duration/ target is 30sec / 82%
The minimum target duration/ target is 30sec / 75%

So while showing the monthly targets, if the percentage is below 75%, it will be shown in red along with the percentage and if it reaches the expected target then it is shown in green.
We will have 2 years of historical data, so the user should be able to select the year and perhaps a quarter.

b. Compare feature
Provide a way for the user to compare the periods i.e. allow them to compare a quarter from this year with the previous year’s same quarter or just a straightforward comparison of this year with the previous year.
Also, think through how the user can select a particular period. For ex: select the first 6 months from the previous year with the last 6 months from this year.
Please make sure to leverage the Power BI features

c. Drill-down feature:
Please refer to “CSL1a_Sofia_Jan'21_20210215.xlsx, CSL1b_Chat_Jan'20_20210215.xlsb, CSL1c_Portal_Jan'21_20210215.xlsx”

We need to include drill-down features for CSL 1a, CSL 1b, and CSL 1c
So, users should be able to drill-down by clicking CSL 1a, CSL 1b, and CSL 1c..we have provided 3 service samples for

• Clicking on CSL 1a will drill down to show the contents of the “Sofia - GCC Summary” tab from CSL1a_Sofia_Jan'21_20210215.xlsx
• Clicking on CSL 1a will drill down to show the contents of the “Global Corporate Center(GCC)” tab from CSL1b_Chat_Jan'20_20210215.xlsb
• Clicking on CSL 1a will drill down to show the contents of “KM3C” tab from CSL1c_Portal_Jan'21_20210215.xlsx

���NOTE: We want to show these contents in the above tabs as a Visualization.

IMPORTANT

• Keep things consistent. This means all graphics styles should work together
• All of the graphics should have a similar feel and general aesthetic appearance

MARVEL PROTOTYPE

• We need you to upload your screens to Marvel App
• Please request for marvel app in the challenge forum
• You MUST include your Marvel app URL (in your marvel app prototype, click on share and then copy the link & share it with your notes/comment on this link while you upload)

SUBMISSION AND SOURCE FILES
Submission File

• Submit all JPG/PNG image files based on Challenge submission requirements stated above

Source File

• All source files of all graphics created in either Adobe XD or Sketch or Figma and saved as an editable layer

Declaration File 
Declaration files document contains the following information:

• Stock Photos Name and Source Links from an allowed sources
• Stock Art/Icons Name and Source Links from an allowed sources
• Fonts Name and Source Links source from an allowed source
• MarvelApp share link for review

FINAL FIXES
As part of the final fixes phase, you may be asked to modify content or user click paths