Hello Fabric Community and Judges!
For this dashboard I used a dataset from a longitudinal study done by Stanford entitled "How couple meet and stay together". The study tracked couples over the course of 6 years and recorded hundreds of variables about their relationships. I've curated a few of the interesting statistics I found for you all.
Data collection & presentation
The data from the study was in .dta format which I learned is a proprietary file format used in the Stata statistical software. I wrote a short python script that used pandas to convert the .dta to a .csv file. That csv file has 175 columns for each variable that was tracked in the study. I cleaned the data with Power Query. I uploaded the user guide, codebook and rubric PDF files to ChatGPT and asked questions to help me understand what exactly the fields represented. I tried to stay true to the theme of love and focused on showcasing interesting stats about how people meet and different variables that are correlated with higher relationship satisfaction. Sources are cited at the bottom of this post.
All visuals are core Power BI visuals. The bottom middle timeline is an SVG image I created and applied in the advanced card visual.
Design choices
For the report JSON theme file, I used shades of pink for the theme colors generated with the Tailwind CSS color generator. For the neutral palette (which is applied to everything besides data points) I chose warm gray palette with a slightly neutral undertone with the intent being to evoke a sense of purity, openness, and lightness to complement this weeks theme of love and the shades of pink.
I used Segoe UI across the entire report except for the logo in the top left which uses Poppins (an open source sans-serif font) for it's playfulness. I applied different font weights and colors to titles and subtitles to help guide the eye and establish good visual hierarchy.
The dashboard canvas is 1440 x 1080px which uses a 4:3 aspect ratio and allows for a little more breathing room for the visuals than the standard 16:9 default Power BI canvas size. The report is set to "actual size" and won't fit perfectly in the community preview window but can be set to fit to page. I recommend opening the report in full screen.
Accesibility
Tab order and alt text was set in Power BI, and I ensured the dashboard passed multiple accessibility test by using the free browser plugin Skilltide.
Enjoy!
Jon Sandmann
Sources Cited
Rosenfeld, Michael J., Reuben J. Thomas, and Sonia Hausen. 2023. How Couples Meet and Stay Together 2017-2020-2022 combined dataset. [Computer files]. Stanford, CA: Stanford University Libraries. https://data.stanford.edu/hcmst2017
eyJrIjoiNGU1M2Y5ZTctNGY0MS00ZDAzLTk0MTAtYjFiOTY0Y2MzZjVhIiwidCI6IjcxOWM3NTc0LTEyOWYtNDJhYS05OGFlLWM4MDU5MjlkNzk2NyIsImMiOjF9
