Preppin' Data

Welcome to Preppin' Data 2020 Week 14. Fun fact: DS14 started at the Data School a year ago today! It seemed only fitting that a member of DS14 should therefore come up with this week's challenge. So, this week we're thinking about how to get your data in the right structure to build spider charts (aka radar charts) in Tableau Desktop. What better data to use than the measurements of actual spiders? The data comes from figshare.com  and contains information about 2,841 different spiders - preferable to going out and collecting the data for ourselves. Ultimately, the goal would be to be able to create something like this (but no obligation to do so!): Link to the viz Requirements Input data . Filter out any specimen that doesn't have a measurement for each trait or those with '*'s against measurements. Clean up fields containing '_'s. We only want to consider species for whom the measurements of at least 10 different specimens were record...

This week we're making big use of the profile pane to help complete a C&B Suds Co logic grid puzzle! You can read more about this type of puzzle here:  https://logic.puzzlebaron.com/ The Challenge The helpful details they left. Last night one of our order takers at C&B Suds Co decided to scribble down the last orders of the day rather than actually input them on the system before they left for the night. The wrote down a series of notes to help them remember the order details but unfortunately they've been quarantined with the coorslightavirus and now we have to figure out who ordered what and what their order priority was. We have all the titles, last names, products, and order priorities but not how these match up. Using the clues below help us figure this out! Only the customer with the highest priority has a title and last name that begin with the same letter. Bevens' priority is directly after Dimmadome. Neither of these people ordered the ...