JUNO - DViz IT Application Ops Power BI Dashboard Design Concepts Challenge 4

Welcome to the  "Juno - DViz - IT Applications Ops Power BI Dashboard Design Concepts Challenge 4".

In this challenge, we are looking to create dashboard visualizations for the IT Application Ops.
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 4th challenge in the JUNO DViz series.

CHALLENGE OBJECTIVES

• Web Application
• 1 Dashboard Screen

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 Applications Ops:
Required KPI's for this dashboard:

Availability of business-critical applications and non-business critical applications
Availability business-critical applications
(see sample data: Business and Application Interruption Report.xlsx/Countries Interruption Report - Final.xlsx)

• This reflects the application availability to ensure business-critical services comply with business needs
• Your visualization should have these details:
  • Number of applications that had an outage in a month
    • Outage duration for each of the business-critical applications
    • Also, include the description of the incident
  • Allow the user to drill-down, so they can view other details of the outage

Availability of non-business critical applications

• This is the same as above just that this shows the outage of the non-business critical applications.
• You can think through how effectively these can be represented in the visualization

Commentary on CAA availability where targets missed
Please refer to detailed Resolution Notes (for reporting) in Business and Application Interruption Report.xlsx

• This shows the Insight into reason (incident) for each of those applications that missed the CAA target.
• This can be put up as a drill-down from the above visualizations

Critical application performance per EMEA BU as a percentage

• Need to show the visualization on how often the availability of the application is down, performance is affected Indicates overall BU performance

MIM stats per month per EMEA BU
Please see Countries Interruption Report - Final.xlsx

• This shows the overall status of the applications grouped by BU or Countries
• Establish overall EMEA position and by BU to identify areas of concerns
• Shows visualization as a Rolling 12 months representation

Number of reactive and proactive application
- This is more text-based and the total volume of data is very less
- Show the problem record ID, Description and click on it shows reveal/drill-down to more information

Problem Records
Problem management Global RCA stats (Pmi - PM6)
Please see Problem Record Dummy Data 2021-02-05.xlsx

• Demonstrate effectivity of process is how many iRCAs within the target, how many actions by the due date

Number of reactive application problem records

• Indicate how many incidents triggered root cause analysis

Number of pro-active application problem records

• Reflect agility of CI SEO team to prevent the incident occurrence

Cost allocation
(We will be looking to provide the sample for this one at the checkpoint)

• Need to show the visualization for the Cost allocation per application/process based on the country
• Shows visualization as a YTD representation

Service Desk incident volumes & top call drivers
Please see incident.xlsx

Volume application incidents Sev1, 2, 3, 4

• This will reflect application stability for the full outage and degraded services (e.g. reporting not working only)
• Show the volume of applications that comes under the Sev 1, 2, 3, or 4.

Service Desk Incident volumes

• Related to number 3, different classification for category/sub-category for volumes
• Display a graph with the category/sub-category hierarchy
• Indicates end-user experiences / top reasons for calls/opportunities to promote new technologies

Service Desk Top call drivers

• Category / Sub-category hierarchy with the resolution codes
• Indicates areas requiring focus (either ITS or BU)

Sev3 WL volumes and trends

• Need to show the volume/ trends specific for the Sev3 WL and help identify the BUs that are most impacted / trends

NPS & End-user satisfaction stats
(See sample data: ESAT CI.xlsx)

• Show the satisfaction score as a percentage, NPS (on a scale from 1 to 10)  for each of the Business unit (CI BeNe, CI Nordics, CI Russia, CI France)
• On clicking the total satisfaction score, show what constitutes the overall percentage (sample data has been provided)0
• Shows visualization as a Rolling 12 months representation

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