Challenge 1 – Solution – Preppin’ Data

In Rosh Khan’s solution post, you’ll see the reasoning behind custom splits (e.g., breaking “Name” into “Game Title” and “Developer”), the importance of cleaning punctuation and spaces, the conversion of foreign-currency sales into GBP via a separate lookup file, and the logic behind filtering for only 5-star games. If you’re using tools like Tableau Prep (or any ETL/data-cleaning tool) and want to elevate your game, this solution post is a practical, real-world blueprint to follow or adapt.