Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #222: Where There's a Whale There's a Way

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: https://www.dailymail.co.uk/news/article-4965690/Humpback-whale-breaches-Sydney-Harbour-sunset.htmlSource: https://www.dailymail.co.uk/news/article-4965690/Humpback-whale-breaches-Sydney-Harbour-sunset.html

 

Every year whales around the world migrate from their feeding grounds to their breeding grounds. Some species travel an outstanding 12,000 miles round trip!

 

Use the data sets below to analyze migration movements for different whale species.

  • The file Whale_Migration_Data contains a list of whales whose migration patterns have been tracked from 2001-2003, and the total kilometers each whale swam on each day of their migration.
  • The file Whale_Pods contains a list of whale ids and pod ids, which indicates the pod each whale belongs to.
  • The file Whale_Species contains information about the whale species of each pod.

 

Find the total number of kilometers each pod swam for migration for each year, then find the average number of kilometers each whale in that pod swam (total kilometers / number of whales in the pod). Then, find the pod with the highest average kilometers swam per whale for each species for each year.

johnemery
11 - Bolide

Fun and quick challenge. Interesting data... too bad this isn't actual data!

Spoiler
Capture V3.PNG

 View my solution video here:

Spoiler
Blake
12 - Quasar

What is the difference between a marine biologist and a dog? 

 

Spoiler
One tags a whale, the other wags a tail. 

Check out my video solution below!

 

Spoiler
222.png

 

AngelosPachis
16 - Nebula

Challenge #222 is done! Nice & quick challenge to start the week

 

Spoiler
Annotation 2020-06-29 135338.png
Aaron_Harter
11 - Bolide

A Whale sized data set and challenge, solved with a minnow-mum amount of tools:

Spoiler
222.PNG
BradWerner
11 - Bolide
Spoiler
222_Complete.png
PhilipMannering
16 - Nebula
16 - Nebula

Had a whale of a time doing this

 

Spoiler
Challenge 222 - Snip.jpg
jasperlch
12 - Quasar
Spoiler
Capture.PNG
dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1593437170947.png

 




Wonder how many miles does this one have...
FXW2aP
WJJW-1
7 - Meteor
Spoiler
WJJW-1_0-1593437588115.png

 

I had a whale of a time doing this