PreppinData

Introduction

This week's challenge came from a YouTube video that Jenny stumbled across: Who Is Pokemon’s LEAST Favorite Pokémon?

The logical steps applied in the video felt like they were screaming out for a Preppin' Data challenge to verify the results! But be warned, the answer to this challenge will differ from the conclusion of the video, due to differing datasets.

Requirements

The requirements for this week's challenge can be found here - 2021: Week 25 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!

Introduction

This week Prep Air are looking into their Net Promoter Score (NPS) and how this compares with a variety of other new airlines. NPS usually takes the form of asking customers "How likely ae you to recommend this company on a scale of 0-10?" You then subtract the detractors of your company from the promoters and end up with a score between -100 and +100. The higher the NPS, the better!

Requirements

The requirements for this week's challenge can be found here - 2021: Week 23 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!

Introduction

It's the final week the of the fundamental challenges, and we are turning our focus to Joins! The challenge is looking at Bike accessories but this time seeing if we have met our target for each quarter.

Requirements

The requirements for this week's challenge can be found here - 2021: Week 4 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!

Introduction

We are continuing with building on the fundamentals of Tableau Prep by introducing the Pivot and Union tools. The challenge takes a look at the Bike Accessories that each of our stores have sold.

Requirements

The requirements for this week's challenge can be found here - 2021: Week 3 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!

Introduction

It's the final challenge of 2020 and we are taking a look at how our star signs have changed due to the introduction of a 13th star sign, Ophiuchus. Can you work out if your star sign has changed?

Requirements

The requirements for this week's challenge can be found here - 2020: Week 53 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!

Introduction

This week the challenge comes from community member @Kate Brown​ ! She has created a viz about the history of the US Women's Championship Golf and the challenge is to prepare the data in Tableau Prep so creating the polygons is easier in Desktop.

Requirements

The requirements for this week's challenge can be found here - 2020: Week 52 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!

Introduction

The NBA is finally back on the 22nd December! The challenge this week is to work out how many hours each of the 30 NBA teams will spend on planes this season flying around North America.

Requirements

The requirements for this week's challenge can be found here - 2020: Week 51 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!

Introduction

Secret Santa is a bit more difficult this year, without everyone being able to gather together and pick names out of a hat. Never fear though, we can randomly assign Secret Santas to their Secret Santees with the Power of Prep! 

Requirements

The requirements for this week's challenge can be found here - 2020: Week 50 | Preppin Data

Solution

The solution will be available below, but please post your solutions and questions!