Power Query Data Transformation & Modeling

Yahli

Yahli R

Raw dataset with over 25 unstructured columns
Raw dataset with over 25 unstructured columns
Fact and song dimension tables after transformation
Fact and song dimension tables after transformation
Normalized artist data and many-to-many bridge
Normalized artist data and many-to-many bridge
Power BI dashboard created with the cleaned model
Power BI dashboard created with the cleaned model
Like this project

Posted Apr 20, 2025

Used Power Query to clean, split, and model Spotify chart data into a star schema, including a bridge table, then used it to built a Power BI dashboard.

Likes

0

Views

3

Timeline

Feb 1, 2025 - Feb 28, 2025