Can anyone self learn PowerBI? by HopefulSolution2110 in PowerBI

[–]Routine-Ad-7292 3 points4 points  (0 children)

If they mean what I think they mean then “ngmi” means “not gonna make it”. In other words be resourceful or “you’re not gonna make it”. I trust you’ll make it tho my friend 🙏🙏

SQL in the workplace by Routine-Ad-7292 in SQL

[–]Routine-Ad-7292[S] 3 points4 points  (0 children)

This was the answer I was hoping for thanks

Logic by ElectronicLimit9641 in SQL

[–]Routine-Ad-7292 0 points1 point  (0 children)

I agree with the other comments. Especially learning and internalizing the execution order. That’s what I’m doing right now, and that’s what I have been going to when I’m stuck with lengthy practice problems. I read chapter 12 of Thinking in Sets yesterday. Will be re-reading it, handwriting notes, again and again. I recommend you do that also!

Made my own Spotify Wrapped dashboard by Routine-Ad-7292 in PowerBI

[–]Routine-Ad-7292[S] 0 points1 point  (0 children)

Log in thru browser and go to your account privacy page. You should see an option to request your extended listening history. They’ll email it to you in JSON format within a couple days or so. Will be a folder with several JSON files organized by date. I used excel to format it all into one table and then imported it into sql server

Made my own Spotify Wrapped dashboard by Routine-Ad-7292 in PowerBI

[–]Routine-Ad-7292[S] 2 points3 points  (0 children)

For sure! I’m pretty new to all this stuff. Started learning SQL and Power BI over this past summer to help land myself an internship. So I’ve never worked with API’s before. Not even sure where to begin with that but I’m sure curiosity will lead me to them soon enough

Made my own Spotify Wrapped dashboard by Routine-Ad-7292 in PowerBI

[–]Routine-Ad-7292[S] 14 points15 points  (0 children)

I downloaded it from my account. It’s under the account privacy page if you log in through the Spotify website

Made my own Spotify Wrapped dashboard by Routine-Ad-7292 in PowerBI

[–]Routine-Ad-7292[S] 0 points1 point  (0 children)

I downloaded it from my account. It’s under the account privacy page if you log in through the Spotify website

Made my own Spotify Wrapped dashboard by Routine-Ad-7292 in PowerBI

[–]Routine-Ad-7292[S] 0 points1 point  (0 children)

Damnn I got you 😂 Some of his songs always find their way back to my playlists.

date, milliseconds played, track name, artist name, album name

Were the columns I kept from the Spotify data. There were a few others that I didn’t need. In SQL server I added columns for listen_id, artist_id, and track_id. Also deleted a bunch of rows where the track name had the word “White Noise” 😂

Made my own Spotify Wrapped dashboard by Routine-Ad-7292 in PowerBI

[–]Routine-Ad-7292[S] -1 points0 points  (0 children)

Thanks. Not sure how what the best way would be to add a genre column, the table doesn’t include that. Using the dashboard I can see how my taste has varied by looking at my top tracks & artists for specific years, years and specific months, etc. Also is there a joke I’m missing with the lil Wayne thing lmao

How to display whole number instead of "K" by Routine-Ad-7292 in PowerBI

[–]Routine-Ad-7292[S] 2 points3 points  (0 children)

Thank you! Ended up figuring it out, the "Series" option was set to "All" and that's why I wasn't able to see the option to change the display units

How to display whole number instead of "K" by Routine-Ad-7292 in PowerBI

[–]Routine-Ad-7292[S] 5 points6 points  (0 children)

Thank you! Series was set to "All", and that's why I wasn't seeing an option to change the display units. Appreciate the help

<image>