Learn

Learn how to download files from SharePoint to speed up your Alteryx Designer workflows. ... View more

  Hello, Community Members!   A solution to last week’s challenge can be found here.   Financial analysts often need to consolidate data from various sources. This week's challenge focuses on using Alteryx functions in financial planning and analysis (FP&A) projects.   The first dataset includes sales information for various countries and business segments for the years 2022 and 2023, with the sales figures recorded in each country’s local currency. The second dataset provides the conversion rates from the countries’ currencies to euros.   Your first task is to create a final table that includes the segment, region, and total sales in euros for both 2022 and 2023. (Tip: Remove any columns where the sale price is null.) For the second part of the challenge, calculate the year-over-year variation per segment (2022–2023 in euros) and identify the segments that experienced negative variations across all three regions: Europe, Asia Pacific (APAC), and the USA.   Need a refresher? Review the following lessons in Academy to gear up: Summarizing Data Changing Data Layouts Happy solving!   The Academy Team ... View more

Hello Community Members!   A solution to last week’s challenge can be found here.   It's time to put your spatial skills to the test again! This challenge, submitted by Claire McCollough (@clmc9601), will challenge you to use the Designer Spatial palette efficiently.   You are provided with two datasets. The first dataset contains polygons representing the counties of Maine, a state in the USA. The second dataset contains a polygon representing the Gulf of Maine, located in the nearby waters of the Atlantic Ocean.   Your tasks are to: Identify which Maine county has the longest coastline on the Gulf of Maine. (Exclude any islands smaller than 5 kilometers.) Determine which county has the most small islands. (An island is considered small if it is less than 5 square kilometers.) Need a refresher? Review the Spatial Analytics lessons in Academy to gear up.   Happy solving!   The Academy Team ... View more

A solution to last week’s challenge can be found here.   This challenge was developed in collaboration with some Alteryx users, and we would like to thank @biosartorelli, @lemuelcastro, @Malvim, @nicolas_colombo and @silvestremoreira for taking time out of their busy schedule to think of a great challenge for this special time of the year. Thank you!   Every year Santa Claus gets his sleigh and helpers (reindeers and elves) and goes around the world distributing presents to those who behaved well. Did you behave well this year? Is Santa going to leave your present under the Christmas tree? This challenge will bring you the answer!   You goal is to figure out Santa’s route for the night of December 25th and what time he is going to pass through the city closest to you! He should take 24 hours to go around the globe (leaving North Pole at 00:00:00am) delivering the presents but be aware that the route is very well hidden, and you will be able to find it if you analyze your datasets carefully. When you find the route as well as the time, use your reporting skills to figure out the delicious recipe Santa left you.   As a bonus, would you be able to find out what time he will be at your city exactly?   Enjoy the season and this challenge! ... View more

A solution to last week’s challenge can be found here. Now that you have created a map of the marathon route in Part 1 of challenge #341, add details to your map: - Create a start point in green. - Designate the route in red. - Create a legend in the lower-left corner for the start point and the route. Use an 11 x 6-inch card size. Add the following numerical information in the upper-right corner: - Marathon distance - Route time - Average speed Hint: Respect the formatting of the caption objects.   Check out our newly rebranded course, Spatial Analytics. ... View more