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.
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.
1/
[#]Notify #Plex #Plexamp #YearInReview #Music #Metal #MicrosoftFabric #PowerBI
=> More informations about this toot | View the thread | More toots from SQLAllFather@techhub.social
=> View notify tag | View plex tag | View plexamp tag | View yearinreview tag | View music tag | View metal tag | View microsoftfabric tag | View powerbi tag This content has been proxied by September (3851b).Proxy Information
text/gemini