SqlBobScot

@SqlBobScot@techhub.social
20 Followers
26 Following
217 Posts
Chief Power BI Nerd - Works for Quorum in Sunny Scotland, just your typical Data Shepherd, Data Plumber, Data Dance Teacher sort of person.
US Makes Visa Applicants Set Social Media To Public

Where are all those free speech absolutists now?

Comic Sands

At the grocery store this morning, unidentified person ranting to the cashier: Women should dress more traditional, like they did when I was younger.

Me nodding along and thinking yes, yes please. Although as a Gen Xer, my definition might not match what is in that person's mind.

Language is important.
I'm tired of media euphemisms.
It's not climate skeptic, it's climate denier.
It's not vaccine skeptic, it's anti-vaxxer.
And it's "lies" and "racism" and "genocide" and "war." Words have meaning.
β€œ1 in 31 children will be diagnosed with autism spectrum disorder by age 8.” That’s not an epidemic, it’s a data point that RFK Jr. and others have twisted into a movement of misinformation. https://thinkbigpicture.substack.com/p/rfk-autism-epidemic-never-existed
The Autism Epidemic That Never Was

RFK Jr.'s scientific illiteracy has led the ignorant down a dangerous path.

This is the proper way to descend stairs.

A little update I'm available for hire - if anyone is looking for a 'Chief Power BI Nerd' ? or a 'Data Shepherd, Data Plumber, Data Dance Teacher' Maybe just a Plain Vanilla Senior BI consultant/engineer? Then let me know 😁

https://www.linkedin.com/posts/rwlpfrench_who-moved-my-cheese-animated-summary-activity-7317886795042492416-wHxP?utm_source=share&utm_medium=member_desktop&rcm=ACoAAAHATzMBeJdmDWN_7jqI0va9OfpPbuAKs5A

Who Moved my Cheese? Animated Summary | Robert French

Someone moved my cheese! One of the constants in my life is that things change. Last week, I was informed that I would be made redundant. My last day with the company was Friday, 11th April 2025, so I am available for an interview. This situation has both positive and negative aspects. On the positive side, I can look for a new role and dig deeper into learning about Power BI also related topics 😍 So, if you require a "Chief Power BI Nerd" or a "Data Shepherd, Data Plumber, Data Dance Teacher," then let's talk. Or if you're looking for a Plain Vanilla Senior BI consultant/engineer, I am worth speaking to. My passion is Data and anything related to it. Can I recommend the book Who Moved My Cheese? This short video is an excellent summary of the central message: https://lnkd.in/enTJpMvT. The message does not make it any easier to deal with change. For me, it just helps to know that change will happen and bring new opportunities, as it has in the past then will continue to do so in the future. 😁

Turnabout is fair play.

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

Myself and my partner have been watching it get lighter for about 1.5 hours. Now the sun is just peeking round the shoulder of Eval (the hill in the background)
Γ—

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

This year I listened to music for over 85K minutes.

2/

This year I listened to over 2200 songs.

3/

My top song for the year is Versvs Christvs by Behemoth. Apparently I listened to this one song for over 43 hours this year, which seems perfectly reasonable to me. Magnificamus te.

4/

All of my top 5 songs this year were by Behemoth. To be fair, I think my to 50 were, but the report only shows the top 5.

5/

I wonder why my year's genre cloud is dominated by the words "black" and "metal." Just one of those mysteries, I guess.

6/

I listened to 109 different artists in 2024. This is pretty typical for my listening habits on Plexamp. My "artists per year" numbers of Spotify were often near or over 1,000 because Spotify was constantly pushing at me crap I would never want to listen to. When I filter out the garbage (artists with very low listen counts and durations) the number is much closer to 100 than to 1,000.

7/

My top band of 2024 was Behemoth? I'll bet no one saw THAT coming!!

8/

Although Behemoth is my current musical obsession, I do listen to lots of other music. Tiamat is a decades-long favorite, while Schammasch is a new-to-2024 discovery. Who knows where they'll show up next year?

That's what I have so far. I'll probably keep tweaking the solution throughout the year, but I'm pretty pleased with how this came together... and today is pretty much the last day I can share a 2024 retrospective without feeling like I missed a deadline somewhere.

9/

Even though it's not super relevant for today, I also love the ability to compare and contrast different years. But am I including these screen shots to show off my report, or as evidence that I do actually listen to music other than Behemoth?

10/10

@SQLAllFather That is super awesome, thanks for sharing!
@SQLAllFather @plexamp This is awesome. I do my own with SQL every year, but only for top tracks and artists! I never considered the other stats.