HR Consultation Insights - Power BI Challenge #3 Entry from Greg

Challenge Updates
2

Hi All:

INSPIRATION:
My inspiration was more from a back-end and presentation point-of-view than a “pick the best visuals” point-of-view. @BrianJ 's analysis was excellent and had I done something similar, I’m hopeful I could have extracted more insights, but, alas, I didn’t go very deep all with the data itself at all.

HOW:

  1. Generated a very clean data model, using the main table as a staging query and multiple references to create all model tables (except dates);
  2. Generated a consistent theme using a image background and partially-transparent rectangles for the header and footer bars:
    • I wanted a colour-shifting background, so used PowerPoint to take the gradient image I found and mirror it so colours go dark-light-dark (top-to–bottom)
  3. Used eDNA Colour Theme Generator to extract colours from the image background I selected and created a JSON theme;
    • picked the darkest theme colour to use as the background colour for the grid rectangles and used drop shadows (drop shadows impacted spacing, and in the time available I didn’t find a solution I fully liked)
  4. Included a Last Refresh table;
  5. Included slicer selections in the footer and a slicer bar just above the footer:
    • made the date slicer take-up the minimum amount of space by hiding the slider;
    • made all slicers multi-select;
    • included a reset slicers button (to call the reset slicers bookmark
    • created concatenation measures using CONCATENATEX for all slicer selections, so that all selections are always visible (even if the report was screen-shotted, PDF’d, or printed);
    • included the last refresh date, report ID, report version, and report version date in the footer, again so always visible, again using CONTACTENATEX, as well as whitespace [UNICHAR(8204)] for the card body and my concatenated admin measure in the card title so I could right-align it;
  6. Added an [Outcome Score] calculated column to the [Outcome] table to permit comparison of policies;
  7. Used the Enlighten Data Story custom visual to preset a small number of the key measures at the top;

I didn’t have the time I wanted to go deep on the visuals to use, and I would have liked to generate more impactful visuals and insights.

Still, a thouroughly enjoyable challenge, and it did give me the opportunity to explore a few presentation ideas I’ve been kicking around for a while. Congratulations to all.

Greg

5 Likes