Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
Hi Maveryx,
We posted the solution JSON file to Cloud Quest #5. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below.
Let’s dive into this week's quest!
Download the provided JSON start file and upload it into your Analytics Cloud library. For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article .
Scenario:
This week’s quest revolves around data provided about standardized math exams administered in New York City Public Schools from 2013 to 2019. Download the provided district_math_results.csv dataset and reconnect it in your starting workflow file. Ensure that the Interpret Column Datatypes checkbox is not selected in the Input Data tool options. The dataset includes details on the district, grade, year, category (male/female); the number of students who took the test; and the percentage of students who achieved each level, with Level 4 being the highest.
You have two tasks:
Calculate the change, by district, in the percentage of 8th grade female students who achieved a Level 4 score in 2019 compared to 2013.
Identify the top three districts that showed the most significant improvement in the Level 4 percentage over the same period.
Hint: Configure the Cross Tab tool to create a new column based on the Year field, labeling the columns as Year 2013 and Year 2019. The Level 4 percentage should serve as the value for these columns, using the Use First Value method. Ensure the data is grouped by District.
A combination of the Sample, Filter, Cross Tab, Formula, and Select tools should solve your problem, but not necessarily in this sequence.
A combination of the Sample, Filter, Cross Tab, Formula, and Select tools should solve your problem, but not necessarily in this sequence.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:
Getting Started with Designer Cloud
Building Connections in Designer Cloud
Building Your Workflow in Designer Cloud
Once you have completed your quest, go back to your Analytics Cloud library. Download your workflow solution file. Include your JSON file and workflow screenshot as attachments to your comment.
Here’s to a successful quest!
Source: https://infohub.nyced.org/docs/default-source/default-document-library/2014-15-to-2022-23-nyc-regents-overall-and-by-category---public.xlsx
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
In April, we celebrate Earth Month, a time dedicated to raising awareness and taking action for environmental conservation and sustainability.
This weekly challenge delves into temperatures, highlighting their crucial role in our planet's health. The dataset presents comprehensive information on global temperature records, covering various countries worldwide. It includes average temperature records in Celsius for major cities from 1743 to 2013.
To solve this challenge, we will be concentrating on the data from 1950 onwards.
Your tasks are as follows:
Determine which cities have average temperatures greater than or equal to 25 degrees.
Among the cities identified in the previous task, identify the country with the highest number of such cities.
Examining all countries within the dataset, pinpoint the year with the highest average temperature and the year with the lowest average temperature across the globe.
Need a refresher? Review these lessons in Academy to gear up:
Sorting Data
Separating Data into Columns and Rows
Summarizing Data
Source: https://www.kaggle.com/datasets/maso0dahmed/global-temperature-records-1850-2022
Good luck!
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge was submitted by Patrick Digan (@patrick_digan) an Alteryx ACE and also an active Community member who has contributed to many challenges before. Thank you, Patrick!
This week’s challenge is inspired by a special day that just passed: Pi Day! Not the delicious treat, but the number with an infinite sequence of non-repeating decimals: 3.14, which is celebrated on March 14.
In honor of pi, this week your task is to find all 13 numbers less than or equal to 100,000 that are equal to the n th power of the sum of their digits. For example, 81 is a 2-digit number, so n=2, and (8+1) 2 = 81; therefore, it falls under the category we are looking for.
For the input, use the Generate Rows tool to generate numbers from 0 to 100,000.
Bonus question: If you want to take your skills to the next level, you are invited to find all 17 numbers that are equal to any n th power of the sum of its digits. For example, 4,913 works for this. While it will fail for the first task because (4 + 9 + 1 + 3) 4 = 83,521, the number 4,913 works well for the bonus question since (4 + 9 + 1 + 3) 3 = 4,913.
Need a refresher? Review these lessons in Academy to gear up:
Summarizing Data
Creating Regular Expressions
Good luck!
... View more
A solution to last week’s challenge can be found here.
This challenge was submitted by Jifeng Qiu (@Qiu) , a dedicated member of our Community. Qiu is the first person to earn our new Weekly Challenge Contributor Badge and will also receive special swag from Academy soon. Congratulations, Qiu, and we eagerly await more challenges!
The Academy Awards, officially known as the Oscars, honor artistic and technical merit in the film industry. The 96th Academy Awards 2024 is scheduled for Sunday, March 10, 2024, and will recognize movies released in 2023.
The first dataset contains information about movies nominated for the award from 1928 to 2023. The second dataset contains information on actors and actresses who were nominated for the 2024 Oscars and their respective movies.
For this challenge, only focus on the winner of the actor, actress, supporting actor, or supporting actress categories.
Your task this week is to find:
Actors/Actresses with eight or more nominations.
Actors/Actresses who have eight more nominations than they have total awards (do not consider nominees with zero awards).
Actors/Actresses who won every time they were nominated.
Actors/Actresses with five or more nominations who have never won.
2024 nominees who have won before.
Need a refresher? Review these lessons in Academy to gear up:
Joining Data
Filtering Data
Summarizing Data
Sources:
https://www.kaggle.com/datasets/unanimad/the-oscar-award
https://www.oscars.org/oscars/ceremonies/2024
Lights, Camera, Action!
... View more
A solution to last week’s challenge can be found here.
Hi there!
In Weekly Challenge #324, you calculated totals and subtotals using a dataset of food items. For this challenge, calculate totals and subtotals using a dataset from an office supply inventory. Start by categorizing the items under "Computer" or "Standard" to help you calculate the totals and subtotals.
Hint How to Generate and Format Totals and Subtotals https://community.alteryx.com/t5/Engine-Works/How-to-Generate-and-Format-Totals-and-Subtotals/ba-p/916853
... View more