This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
A solution to last week's challenge can be found here."Sweet Pets" by Gallery Sweet Spot is marked under CC PDM 1.0. To view the terms, visit https://creativecommons.org/publicdomain/mark/1.0/
Find My Pet US is a platform that helps animal owners find their lost pets in animal shelters in the United States. Find My Pet US wants to expand its business. A data analyst hired by the company is researching various scenarios.
One of the scenarios investigated by the data Analyst includes the following two conditions:
• Pet owners who are offering a reward equal and over $2,700, and; • Pet owners living within 500 miles from the shelter where the pet is.
The dataset “Pet_info” contains information about the pets. The dataset “Animal_Rewards” lists the rewards associated with the animal ID. The dataset “Owner_Info” provides information about the owners.
Use the datasets to find out which animal owners to target based on the two conditions of this scenario.
I typically run workflows frequently as I'm building them to make sure the data is flowing through as expected. This week, I added the additional challenge of adding all of my tools to the canvas before hitting ctrl + r. To my surprise, I was successful in solving this challenge with only this one run!