SQLAllFather<p>I left Spotify in 2021 and started listening to my own music collection. I already had the MP3s and/or the CDs from which to rip them, so I hosted them on my Plex server and started listening to them using the excellent Plexamp mobile client.</p><p>One thing I missed from Spotify was the "wrapped" listening summary... but I'd always believed I could improve on what Spotify delivered. This winter break I spent some time implementing a solution in Microsoft Fabric. I used data from my Plex server's SQLite database for recent years, and from the JSON files that Spotify will send you if you make a GDPR data request for older years. I standardized enriched both data sets with the open source MusicBrainz database, and then visualized some Spotify-inspired vanity metrics in Power BI.</p><p>1/</p><p><a href="https://techhub.social/tags/Notify" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Notify</span></a> <a href="https://techhub.social/tags/Plex" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Plex</span></a> <a href="https://techhub.social/tags/Plexamp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Plexamp</span></a> <a href="https://techhub.social/tags/YearInReview" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>YearInReview</span></a> <a href="https://techhub.social/tags/Music" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Music</span></a> <a href="https://techhub.social/tags/Metal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Metal</span></a> <a href="https://techhub.social/tags/MicrosoftFabric" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MicrosoftFabric</span></a> <a href="https://techhub.social/tags/PowerBI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PowerBI</span></a></p>