sdw-online/top_uk_youtubers_2024 — reverse-engineered prompt

Build me a simple data portfolio project around the top UK YouTubers in 2024, using the Kaggle Excel dataset mentioned in the readme. I want it to feel like something a Head of Marketing could actually use to decide which creators are worth partnering with.

Please take the raw spreadsheet, clean it in SQL Server, keep just the useful fields, extract clean channel names from the messy first column, and create a final view with channel name, total subscribers, total views, and total videos. Add a few basic data quality checks so it is clear the cleaned data is valid.

Then turn that into a Power BI dashboard with clear visuals and scorecards that answer practical questions like who has the most subscribers, most views, most uploads, best average views per video, views per subscriber, and engagement per video. I also want a polished README that explains the goal, data source, process, findings, and recommendations, with a mockup or screenshots if possible. If you need small missing details, look up the current docs online and make sensible choices.