BONUS: 5‌ CHECKPOINTS AWARDED WORTH ‌$50‌ EACH

Register
Submit a solution
The challenge is finished.

Challenge Summary

Welcome to the "HealthSparq - PowerBI DViz Dashboard UI Design Challenge Part 2".

In this challenge, we are looking to continue creating the full experience of a dashboard web application for Member Experience Team (MET) users to view several measures captured for HealthSparq in PowerBI.

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!

CHALLENGE OBJECTIVES

  • Web Application to be developed using PowerBI

  • Desktop Views

  • Around 4-6 pages with charts and data Visualizations as described in the requirements

Round 1

Round 1
01) Measurement Framework | Experience Measures | Identifying
02) Measurement Framework | Experience Measures | Filtering
03) Measurement Framework | Experience Measures | Dashboard View
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

Round 2
01) Measurement Framework | Experience Measures | Identifying
02) Measurement Framework | Experience Measures | Filtering
03) Measurement Framework | Experience Measures | Dashboard View
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

GLOSSARY

MET = Member Experience Team

Channel = The medium in which we are interacting with the member

Property = The specific system or manner being used to interact or support the member

Service = The action being taken by member or on behalf of the member to fulfill a need

 

CHALLENGE OVERVIEW:

Our client is Wellmark and they are a leading health insurance company based in the US. HealthSparq is one of many customer-facing Wellmark digital properties that we are looking to analyze. We are wanting to better understand the interactions and experiences that our customers have with a given property. We believe that the measures defined in our requirements will help to paint the picture of the member experience.

AUDIENCE:

Various Wellmark employees who are part of the Member Experience Team.

DESIGN GOALS & PRINCIPLES

Below are some of the goals:

  • Power BI compatible design, see reference section for more information.

  • Elegant, clean, simple, user-centered look and feel with modern aesthetics

  • Use color, visual comparison, and drill-down charts to highlight comparison.

  • Overall UI design and UX should be engaging and easy-to-use.

  • How well does your design align with the objectives of the challenge?

 

JUDGING CRITERIA

  • Creativity: Impactful; the solution is different or unique from what is already out there and can be implemented.

  • Exploration: Flexible; follow the provided screen requirements section and propose improvements or different paths that positively impact the user goals.

  • Aesthetics: Hi-fidelity design; provide a top-notch finished-looking visual design.

  • Branding: Flexible; follow the provided guidelines and suggest improvements where seem appropriate and in line with the goals.

 

BRANDING GUIDELINES

For this challenge you need to continue working with the same Look and feel of the design provided on this Marvel prototype. You will find the source file in the supporting document section. Considerations:

  • You need to keep the same aesthetic and look

  • Your new charts and visualizations needs to be fully compatible with Power BI

  • You are free to change the software. Provided file is a sketch but you are free to use your own tool as long as it is a vector oriented app: Figma, Adobe XD, etc.

 

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.

  • Must follow Power BI Design Best Practices and also take a look at the Design Goals and Principles

  • 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

 

SCREEN REQUIREMENTS

1) Measurement Framework | Experience Measures | Identifying

As a MET User of the Measurement Framework Dashboard I Want a Channel/Property/Service Switch Experience Measures captured; so That Experience Measures can help identify opportunities to improve member experience.

This page would work as a Dashboard with a mapping summary of all the acceptances criterias found in this document.  These criterias are:

AC1 - InteractionTypes must be grouped by Channel, Property, and Service Values

AC2 - Correlation Interactions must be grouped together using correlationID

AC2.1 - All distinct 'interactionTypes' under a single ‘correlationID’ must be grouped together. 

AC2.2 - All switches that occur under a single ‘correlationID’ must only count as 1 channel switch.  

AC2.3 - 'createdDatetime' from the latest 'interactionType' during the correlated interaction should be used as the datetime value for the member interaction. 

AC3 - When interaction contains SessionID (details.sessionId)

AC3.1 - All distinct 'interactionTypes' under a single 'SessionID' must be grouped together . 

AC3.2 - All switches that occur under a single 'SessionID' must only count as 1 channel switch.  

AC3.3 - 'createdDatetime' from the latest 'interactionType' during the session should be used as the datetime value. 

AC4 - Must be able to determine how many Wellmark Channel/Property/Services a member visited within a given time frame

AC5 - Must be able to identify the Wellmark Channel/Property/Service the member went TO and came FROM

AC6 - A Channel/Property/Service switch must consist of a Member switching from a Wellmark Channel/Property/Service to another Wellmark Channel/Property/Service.  As an example, a switch from one Interaction Type to another Interaction Type WITHIN the same Channel is NOT a Channel Switch.

 

2) Measurement Framework | Experience Measures | Filtering

As a MET User of the Measurement Framework Dashboard I Want a Channel/Property/Service Switch Experience Measures captured;  so That Experience Measures can help identify opportunities to improve member experience.

We need to use the same filters from PowerBI, same as used in the previous design. Please see the Marvel prototype link from the Branding section.

The following are the filtering criterias:

  • Must be able to filter based on a reporting window of time as well as filter on a Channel/Property/Service time period 

  • As a MET user, I'd like to see the number of Channel Switches that occurred within a 6 calendar day time period at a specific reporting window (i.e. from 1/1/2020 - 3/1/2020) 

  • Default Channel/Property/Service Switch filter to 2 calendar days

  • Channel/Property/Service Switch filter must allow for a filter up to and including 30 calendar days.

  • Default reporting window filter to YTD.  Year To Date. 

  • Must be able to filter experience measures by all data included in Membership dataset.  Inclusive list of Membership dataset below:

  • Gender Code

  • Language Code

  • Marital Status Code

  • Member Eligibility Status Code

  • Member Status Code

  • Out of Area Code

  • Plan Member Status Code

  • Relationship to Plan Member Code

  • Benefit Grouping Identifier

  • Benefit List Identifier

  • Product Identifier

  • Rate Select Code

  • ULP Code

  • Minimum Effective Date

  • Coverage Full Code

  • Maximum Expiration Date

  • Market Segment Code

  • Product Description

  • Risk Pool Code

  • Bill Funding Type Code

  • Coverage TOC Code

  • Grandfathered Status Code

  • LOB Product Type Code

 

3) Measurement Framework | Experience Measures | Dashboard View

As A MET User of the Measurement Framework Dashboard I Want a Channel/Property/Service Switch Experience Measures captured;  so That Experience Measures can help identify opportunities to improve member experience.

Channel/Property/Service Switch Dashboard must contain an Overview Page containing:

  • Total interactions

    • Count all interactions during the reporting window, not just channel switches.

  • Total Channel switches 

  • Total Channel Switches by Month 

  • Channel Switch Rate

    •  "Of all the interactions we track, what percentage are channel switches" 

  • Top switch paths by volume - start/finish (channel-to-channel) 

    • Order DESC

    • Display top 5 by default

  • Top switch paths by volume - start/finish (property-to-property) 

    • Order DESC

    • Display top 5 by default

  • Top switch paths by volume - start/finish (service-to-service)

    • Order DESC

    • Display top 5 by default

 

In addition to a Overview on the Channel/Property/Service Switch Dashboard, the Dashboard must also contain breakout pages for the following channels:

  • Voice (inbound) 

  • Online Self Service 

  • Web Inquiry 

  • Email (Inbound & Outbound) 

  • Mail (Inbound & Outbound) 

 

Each breakout page must contain:

  • Total interactions 

    • Count all interactions with the given channel during the reporting window, not just channel switches.

  • Total Channel switches (to the given channel)

  • Total Channel Switches by Month 

  • Channel Switch Rate --> "Of all the interactions we track, what percentage are channel switches" 

  • Top switches by volume (channel)

    • Order DESC

    • Display top 5 by default

  • Top switches volume (property) 

    • Order DESC

    • Display top 5 by default

  • Top switches by volume (service) 

    • Order DESC

    • Display top 5 by default

 

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

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.

Stock Photography

Stock photography is not allowed in this challenge. All submitted elements must be designed solely by you. See this page for more details.

How To Submit

  • New to Studio? ‌Learn how to compete here
  • Upload your submission in three parts (Learn more here). Your design should be finalized and should contain only a single design concept (do not include multiple designs in a single submission).
  • If your submission wins, your source files must be correct and “Final Fixes” (if applicable) must be completed before payment can be released.
  • You may submit as many times as you'd like during the submission phase, but only the number of files listed above in the Submission Limit that you rank the highest will be considered. You can change the order of your submissions at any time during the submission phase. If you make revisions to your design, please delete submissions you are replacing.

Winner Selection

Submissions are viewable to the client as they are entered into the challenge. Winners are selected by the client and are chosen solely at the client's discretion.

ELIGIBLE EVENTS:

2022 Topcoder(R) Open

Challenge links

Screening Scorecard

Submission format

Your Design Files:

  1. Look for instructions in this challenge regarding what files to provide.
  2. Place your submission files into a "Submission.zip" file.
  3. Place all of your source files into a "Source.zip" file.
  4. Declare your fonts, stock photos, and icons in a "Declaration.txt" file.
  5. Create a JPG preview file.
  6. Place the 4 files you just created into a single zip file. This will be what you upload.

Trouble formatting your submission or want to learn more? ‌Read the FAQ.

Fonts, Stock Photos, and Icons:

All fonts, stock photos, and icons within your design must be declared when you submit. DO NOT include any 3rd party files in your submission or source files. Read about the policy.

Screening:

All submissions are screened for eligibility before the challenge holder picks winners. Don't let your hard work go to waste. Learn more about how to  pass screening.

Challenge links

Questions? ‌Ask in the Challenge Discussion Forums.

Source files

  • Sketch
  • Figma
  • Adobe XD

You must include all source files with your submission.

Submission limit

Unlimited

ID: 30219401