Advanced Power BI Project • End to End • ChatGPT • Custom Visuals

Learn how to use Python, ChatGPT, HTML, DENEB to make this report.
🟢Skip the python with the enriched Dataset: https://onyxdata.ck.page/a12261b1fb

00:00 – Intro
00:46 – Download and Enrich Dataset
05:55 – Glassmorphism Background
11:50 – Power BI
17:38 – HTML Visual
20:33 – DENEB Visuals
29:58 – Power BI Formatting

I wanted this to be a step into Advanced Visualization Techniques,
especially if you’re a Power BI developer and haven’t used them
These techniques are powerful tools to add to your kit.

The Video covers:
💠Enriched dataset with ChatGPT & Python
💠Glassmorphism Background
💠Power BI Building
💠HTML Cover Art
💠DENEB Visuals
💠PBI Format

You want the Python code? Scroll down 👇

=================================
🔥Code Interpreter for Data Analysis
🔗https://youtu.be/WCtjoKJdx3w?si=8N_sGWM0dFo9nH1e

🔥Power BI Backgrounds
🔗https://youtu.be/YP1Tr7nrwNI?si=P3RhJycSGspGyXpj

🔥Bravo in Power BI
🔗https://youtu.be/_NEnQNp102U?si=KC9ARXr2cE1ikCa-&t=457

🔥Ahmed’s Portfolio
🔗https://photos.google.com/share/AF1QipNqulXXlB1nFDSeglnIG3ftPOY-F79O3Z3lliW6u5nvNTfHPxWd_T2sWvy0q4sG5A?key=eTFFOTdrSlJxRlRmN29iSHdMeVFLSmhfUmdqOWJn

🔥Dataset
🔗https://www.kaggle.com/datasets/nelgiriyewithana/top-spotify-songs-2023?resource=download

🔥Spotify Developer App
🔗https://developer.spotify.com/

🔥Download Python
🔗https://www.python.org/downloads/

🔥David’s Deneb Showcase
🔗https://github.com/PBI-David/Deneb-Showcase

🔥Unit Chart Code
🔗https://stackoverflow.com/questions/75881301/convert-vega-deneb-gauge-to-work-in-powerbi

🔥Heatmap Code
🔗https://github.com/PowerBI-tips/Deneb-Templates/blob/main/templates/heatmap%20with%20bars%20-%20red%20themed.json

🔥Color Pallette
🔗https://www.color-hex.com/color-palette/53188
=================================

Looking for Power BI consulting?

Reach out to me on Linkedin:
🟢https://www.linkedin.com/in/injae-park/

Thanks for taking the time to watch this video.

Python code:
=====================================================
import requests
import pandas as pd

# Function to get Spotify access token
def get_spotify_token(client_id, client_secret):
auth_url = ‘https://accounts.spotify.com/api/token’
auth_response = requests.post(auth_url, {
‘grant_type’: ‘client_credentials’,
‘client_id’: client_id,
‘client_secret’: client_secret,
})
auth_data = auth_response.json()
return auth_data[‘access_token’]

# Function to search for a track and get its ID
def search_track(track_name, artist_name, token):
query = f”{track_name} artist:{artist_name}”
url = f”https://api.spotify.com/v1/search?q={query}&type=track”
response = requests.get(url, headers={
‘Authorization’: f’Bearer {token}’
})
json_data = response.json()
try:
first_result = json_data[‘tracks’][‘items’][0]
track_id = first_result[‘id’]
return track_id
except (KeyError, IndexError):
return None

# Function to get track details
def get_track_details(track_id, token):
url = f”https://api.spotify.com/v1/tracks/{track_id}”
response = requests.get(url, headers={
‘Authorization’: f’Bearer {token}’
})
json_data = response.json()
image_url = json_data[‘album’][‘images’][0][‘url’]
return image_url

# Your Spotify API Credentials
client_id = ‘your_client_id’
client_secret = ‘your_client_secret’

# Get Access Token
access_token = get_spotify_token(client_id, client_secret)

# Read your DataFrame (replace ‘your_file.csv’ with the path to your CSV file)
df_spotify = pd.read_csv(‘your_file.csv’, encoding=’ISO-8859-1′)

# Loop through each row to get track details and add to DataFrame
for i, row in df_spotify.iterrows():
track_id = search_track(row[‘track_name’], row[‘artist_name’], access_token)
if track_id:
image_url = get_track_details(track_id, access_token)
df_spotify.at[i, ‘image_url’] = image_url

# Save the updated DataFrame (replace ‘updated_file.csv’ with your desired output file name)
df_spotify.to_csv(‘updated_file.csv’, index=False)

===============================================
!!!! All curly brackets need to be angled brackets – youtube restricts angled brackets in this text

_Image html =
Var x =
CALCULATE(
MAX(‘updated_spotify_data'[cover_url]),
‘updated_spotify_data'[streams] = MAX(‘updated_spotify_data'[streams])
)
return

”
{!DOCTYPE html}
{html lang=’en’}
{head}
{meta charset=’UTF-8′}
{title}Image Cropping{/title}
{style}
.image-container {
width: 458px; /* Width of the container */
height: 140px; /* Height of the container */
overflow: hidden; /* Hide parts of the image that don’t fit */
border-radius: 15px; /* Rounded corners */
position: relative; /* Relative positioning for the child element */
}

.image {
object-fit: cover; /* Cover the entire container */
object-position: center; /* Center the image */
width: 100%; /* Full width */
height: 100%; /* Full height */
}
{/style}
{/head}
{body}
{div class=’image-container’}
{img src='”&x&”‘ alt=’Album Cover’ class=’image’}
{/div}
{/body}
{/html}
”
=======================================================

#powerbi #shortcuts #microsoft