Learn how to use Python, ChatGPT, HTML, DENEB to make this report.
🟢Skip the python with the enriched Dataset: 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
🔗 • Code Interpreter for D...
🔥Power BI Backgrounds
🔗 • Transform your POWER B...
🔥Bravo in Power BI
🔗 • Make 1000+ DAX MEASURE...
🔥Ahmed's Portfolio
🔗photos.google.com/share/AF1Qi...
🔥Dataset
🔗www.kaggle.com/datasets/nelgi...
🔥Spotify Developer App
🔗developer.spotify.com/
🔥Download Python
🔗www.python.org/downloads/
🔥David's Deneb Showcase
🔗github.com/PBI-David/Deneb-Sh...
🔥Unit Chart Code
🔗stackoverflow.com/questions/7...
🔥Heatmap Code
🔗github.com/PowerBI-tips/Deneb...
🔥Color Pallette
🔗www.color-hex.com/color-palet...
=================================
Looking for Power BI consulting?
Reach out to me on Linkedin:
🟢 / 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 = '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"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"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