Welcome to the John Peel's Festive 50 Report!
This comprehensive Power BI dashboard analyses tracks in the BBC's annual Festive 50 Chart from John Peel's Radio show's countdown across multiple years.
After he died in 2004 the One Show and Dandelion Radio continued the Charts.
The ratings are my own personal values after listening to the tracks.
I've rated all years prior Peel's death in 2004.
Phil @stretcharm1.bsky.social
Note: Some artist and track data might be inaccurate as it was collected via API and 3rd party website lookups.
Main (Home Page)
The entry point to the report with key summary metrics and navigation options
Year Explorer
Explore data for a year of the Festive 50 countdown
Search
Find specific tracks or artists, then you can drill through to Artist/Track from this page
Track Deep Dive
Get detailed information about individual tracks
Artist Insight
Discover detailed information about individual artists
Artists with Most Entries
Rankings and analysis of artists by frequency of appearance
Artist Vs Artist
Compare two or more artists directly
Genre & Eras
Explore the musical diversity of the Festive 50 over time
Ratings
Analysis of my personal ratings for tracks in the Festive 50
Top
See the top-ranked tracks and artists in the Festive 50 in various categories
Moving Between Pages:
- Click the page buttons on the left of each page. The Current Page is Highlighted
Interactive Visualizations
- Click on chart bars/elements to filter the page
- Hover over data points to see detailed information
- Multiple visualisations are linked - selecting in one affects others on the same page
Drill-Through Pages: Certain pages are "drill-through" destinations:
- Track Deep Dive: Right clicking a track/title on a table/matrix
- Artist Insight: Right clicking an artist name on a table/matrix
- These pages automatically filter to show information for your selected item
- The "Back" icon button on the "drill-through" returns to your previous page
Filtering Data:
- Most pages have filters at the top or side
- Click a filter value to include/exclude it
- Use search boxes in filters to find specific values that contain the given text
- Multiple selections are usually possible
Key Columns:
- Artist: The performing artist
- Title: Song/track name
- Year: The year of the Festive 50 countdown
- Track #: The position in that year's countdown (1-50). Some years are not out of 50
- Album: The album the track appears on
- Genre: Musical genre classification
- Genre Group: Broader genre categorisation
- Rating: My Personal Rating (0-5 scale)
- Duration: Track length in minutes
- Links: Various Links to the Websites for Artists/Tracks or Videos
- Broadcaster: BBC John Peel Show, BBC One Show, Dandelion Radio
eyJrIjoiOGRmMzM1NzctNjg3NS00MTI1LTljOGMtYzNiZWY0OWJiMmE4IiwidCI6ImEwYTcyYzIzLTdlMWEtNGYxOC05NDU4LTlhNzUyYTEzMTg1NCJ9&pageName=ebf58016213802100340
