Visual Love
The Visual Love report is a fun slicing and dicing interaction that creates a collective visualization of “love” across the Power BI community.
Concept & Interaction
The report invites you and the Power BI community to express love using emojis in a fun, anonymous way. You select an avatar for yourself—choosing from a mix of age, gender, and skin tone options—and similarly pick an avatar for your significant other (and if you are single, you can select the avatar of your dream partner). Next, you choose a heart emoji from a diverse range, and your selections are shared with the broader Power BI community.
Engagement & Community Impact
By aggregating these anonymous interactions, the Visual Love report creates a dynamic snapshot of community sentiment around the theme of love. It’s not just a tool for individual expression; it’s a way to connect with the broader Power BI community through shared insights and collective data storytelling.
Data Collection & Tracking
Each click and selection in the report is tracked in real time using BI Pixie, a tool that I have created to monitor engagement, adoption, and user satisfaction. As you interact with the report (for example, when adjusting slicers, clicking on data visuals or exploring different pages), your usage data is anonymously captured. This data not only powers the aggregated Visual Love report but also fuels insights into how users engage with Power BI reports overall. The Visual Love report includes a light-weight customized elements of BI Pixie.
Philosophical Twist About Love
In a creative twist, the report is designed to be introspective—it measures its own usage and engagement. This self-referential design turns the report into a living dashboard that not only conveys data about love but also reflects on its own performance, suggesting that introspection itself is a form of self-love. The Visual Click Heatmap page, is a good example for that introspection. The Heatmap shows the clicks in each visual and page of the report. Even the Heatmap page itself. So, as you click at the Heatmap visual itself, the clicks will be added in the next refresh of the semantic model.
Do you love this report? Click the Love or Hate buttons at the top right corner of the first page, and review the total Love/Hate rates in the Page Sessions page. Yes, this report analyzes its own audience's satifaction. Isn't it a true self-love?
Technical Details & Data Sources
- Emoji Data: The report uses internal tables with pre-defined emoji characters and their corresponding codes, ensuring accurate and consistent visualization of love.
- Usage Analytics: BI Pixie tracks all interactions and stores the anonymous data in an Azure Storage account.
To access the data, use the ADLS Gen2 connector in Power BI and connect to the URL below:
https://bipixiepublic.dfs.core.windows.net/bipixielake
Use this SAS token to read the data:sp=rl&st=2025-02-21T03:20:16Z&se=2025-04-21T10:20:16Z&spr=https&sv=2022-11-02&sr=c&sig=Hfcs6fNdR7WmRonp3EiUtdjaWSuK6btwTSM6iYBfhtk%3D
Usage data is updated in the storage account in real-time. The Visual Love report will be updated every 30 minutes.
Intersted to learn more about BI Pixie? Contact me on LinkedIn or here.