Power BI dashboard
- Category: Data Analysis
- Client: Test purpose
- Project date: 05/19/2024
- Project URL: Click here
Portfolio detail
Excited to share my newest project with you - The End-to-End Spotify Data Analysis Advanced Power BI project! 📊
In this project, I leveraged a variety of Azure and Microsoft technologies to analyze and visualize Spotify data. 🎵 Here's a detailed breakdown:
- Microsoft SQL Server as the on-prem Database.
- Utilized self-hosted integration runtime to connect the on-prem database to the cloud.
- Used Azure Data Factory as the ETL Tool.
- Stored data in Azure Data Lake Gen 2.
- Used Azure Databricks for data cleaning and preprocessing.
- Integrated Azure Synapse with Power BI for seamless data connection.
- Developed an interactive dashboard using Microsoft Power BI.
- Secured secrets and keys with Azure Key Vault.
Check out the repository for all the project files:
During preprocessing, I enriched the dataset by adding links to song covers using Python scripts and Spotify Developer API keys, combining advanced data enhancement techniques with Python and ChatGPT. The final dataset was enhanced for better insights and visual appeal.
Key Features:
- 💠Enriched Dataset with ChatGPT & Python
- 💠Glassmorphism Background
- 💠Advanced Power BI Building
- 💠HTML Cover Art
- 💠DENEB Visuals
Resources: