Power BI: Parallel Sets.

Create a parallel set visual using the Data Visualization Society‘s annual State of the Industry survey results and Sankey Chart AppSource visual from Microsoft. The visual shows the relationships between job role, time worked, and time spent producing visualizations.

Part of the Power BI Work Out Wednesday Challenges, reference below.

Data Source:

From the Data Visualization Society’s annual State of the Industry survey. Data can be found in full (in Google sheets) here.

Note: To pull data directly from Google sheets you will need a Google account. If you do not have an account, you can download the file containing the data and use it locally.

Challenge Requirements

• Connect to the job titles and tasks time data in the survey results.
• Remove any rows that have a blank answer for RoleMultichoice_composite, TimeWorked, or TimeProducingViz.
• Replace the following role values: “Leadership (Manager, Director, VP, etc.)” should be changed to “Leadership”. “Teacher” should be changed to “Academic/Teacher”.
• Use Power Query to generate a final table that contains 3 columns: Source, Target, and Count. Count should represent the distinct count of altID values. The Source column should contain the values for RoleMultichoice_composite and TimeWorked (where the data flows from). The Target column should contain the values for TimeWorked and TimeProducingViz (where the data flows to). This final table should contain 3,726 rows with 1,863 respondents.
• Create a parallel sets visualization that shows RoleMultichoice_composite on the left, TimeWorked in the middle, and TimeProducingViz on the right.
• Add a title and explanatory text to provide context and tips for use.

Reference: https://www.workout-wednesday.com/2022/02/15/pbi-2022-w07/

Please take a look at some of the other visualization projects in my Siri Shultz - PBI Portfolio.

Check my homepage here: Siri Shultz