2022 Week 36 | Power BI: Split Violin Plot and HTML

3 Comments / Power BI, Workout Wednesday / By

Introduction

Another PlotlyJS visual this week – creating a split violin plot.

We’ll be comparing male and female dating preferences collected from speed dating events between 2002-2004.

 

EXTRA CREDIT – For those with a little more time on their hands, an extended workout challenge is included; conduct your own data analysis and create a data story to be told in the time it takes to speed date (4 minutes) utilising bookmarks for storyframing and the HTML Content visual to create a countdown timer.

 

Happy Vizzin’

/\___/\
|= ͡° ᆺ ͡°)=
\╭☞ \╭☞ AWESOME!

 

 

Requirements

  • Obtain the data and explanation of the data here: https://data.world/annavmontoya/speed-dating-experiment
  • Model the data or obtain the pbix from here: Workout Wednesday 2022 Week 36 – Microsoft Power BI Community
  • Import plotyJS visual from AppSource
  • Place the iid, gender, attributes and ratings for the question “What do you look for in the opposite sex?”, in the field well. Ensure the waves 6-9 are filtered as these are rated differently or adjust calculations accordingly.
  • Select the PloyJS visual, from the ellipis select edit visual
  • Add a violin trace
  • Add the attributes along the X Axis and the Ratings across the Y Axis
  • Under transform, Split trace by gender
  • Under trace styles, set female span mode hard, with positive visible sides
  • Under trace styles, set male span mode hard, with negative visible sides
  • Display outlier points and adjust point jitter, position, and opacity to suit
  • Adjust the Bandwith (2)
  • Display median lines
  • Under Save/Load, save and close

ADVANCED — EXTRA CREDIT

  • In a new measure create an animated HTML/SVG countdown timer of your own or re-style from the following template: https://kerrykolosko.com/portfolio/countdown-timer/
  • Set the animations for 4 minutes
  • Analyse the speed dating dataset and create your own visualisations
  • As the count-down timer resets across pages, use bookmarks to navigate your story.
  • Create a datastory that can be told within 4 minutes (the time it takes to speed date)

Dataset

This challenge uses data from dataworld available here:  https://data.world/annavmontoya/speed-dating-experiment

Or you can download the PBIX from the Data Stories Gallery : Workout Wednesday 2022 Week 36 – Microsoft Power BI Community

Share

After you finish your workout, share on Twitter using the hashtags #WOW2022 and #PowerBI, and tag @JSBaucke, @MMarie, @shan_gsd, @KerryKolosko, and @NerdyWithData. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year. 

Please be sure to cite source before sharing.

Solution

Video

3 thoughts on “2022 Week 36 | Power BI: Split Violin Plot and HTML”

  2. Kerry Kolosko

    From the modelled data — in the “What do you look for in the opposite sex?” Table, the field “Value – What do you look for in the opposite sex?”. Apologies it’s not named very well. From the unmodelled data — please refer to the data dictionary (Word Document provided). They should be fields “attr1_1”, “sinc1_1”, “intel1_1”, “fun1_1”, “amb1_1”, “shar1_1”

Comments are closed.

Scroll to Top