Weekly Challenge Index & Welcome (Page 2)

[AYXAcademy]

Welcome to the Weekly Challenge. Each week we will post a use case where you can put your Alteryx skills to the test. You'll be able to share your answers and collaborate with other challengers to arrive at an answer. Participation will be rewarded - just make sure you are attaching your Alteryx workflows to your responses!

Interested in keeping track of which challenges you have completed?
Download this workflow created by @Hannah_Lissaman, @Alekh, and @mceleavey.
or try this app to download your unsolved challenges. (Created by: @LordNeilLord)

Top Challengers (2023-12-05):

Rank	Challenger	Challenges Completed
1	@AkimasaKajitani, @Kenda, @PhilipMannering, @RWvanLeeuwen, @patrick_digan	401
2	@JosephSerpis, @Qiu, @RolandSchubert, @gawa, @ggruccio	400
3	@TonyAndriani, @Watermark, @ed_hayter	398
4	@JamesCharnley, @alacoume, @mmontgomery	397
5	@LiuZhang	396
6	@ahsanaali, @rmassambane	395
7	@ARussell34	394
8	@binuacs	390
9	@acarter881	382
10	@FrederikE	380

Top Solvers in the Last 30 Days:

Rank	Challenger	Challenges Completed
1	@ds_tomalexsmith	46
2	@AndrewDMerrill, @shrestha_nitesh	40
3	@RasmusFormo	29
4	@Data-Analyst23	28
5	@olivier_newman	25
6	@Matthew	24
7	@DaisukeTsuchiya, @vakachiranjeevi	23
8	@danielprince, @olga_strubbe	22
9	@Rob-Silk	21
10	@ricki	19

#	Challenge Name	Level of Difficulty	Main Subject	Certification Level
402	Parsing Equipment Tags	Intermediate	Data Parsing	Advanced
401	Auto Insights Special Edition – Team 4 Performance Analysis	Basic
400	A Thanksgiving Challenge to Keep You Occu-pied	Difficult	Spatial Analysis	Advanced
399	Auto Insights Special Edition – Sales Spotlight, Regional Performance	Intermediate
398	Generating Time Intervals	Intermediate	Data Preparation	Core
397	Auto Insights Special Edition – Financial Insight: Spend Analysis	Intermediate	Data Analysis
396	Analyze the Ultimate Motorsport: Formula 1	Basic	Data Preparation	Core
395	Bone-Chilling Horror Movies	Intermediate	Data Analysis,Reporting	Advanced
394	Fantasy Football	Basic	Data Preparation	Core
393	Find the Best Yarn	Basic	Data Preparation	Core
392	Calculate Climate Extremes	Intermediate	Parse,Data Analysis,Data Preparation	Advanced
391	Which Combinations of Pokémon Types Do Not Exist?	Basic	Data Analysis	Core
390	Top US Cricket Players	Basic	Data Preparation	Core
389	Password and Security Violations	Intermediate	Data Parsing	Advanced
388	Meteorite Impact Sites	Intermediate	Spatial,Data Parsing	Advanced
386	Shed Light on a Bank’s Risky Business	Intermediate	Data Preparation,Macros	Advanced
385	Volcanoes in 2023	Intermediate	Spatial,Data Parsing	Advanced
384	Uncover Tennis Stats Upsets!	Basic	Data Analysis	Core
383	Data Parsing Delight!	Difficult	Data Parsing	Advanced
382	Life Changing Virtual Reality!	Basic	Join,Data Preparation	Core
381	Average Monthly Sales with a Twist	Intermediate	Transform	Core
380	Inspire 2023 Grand Prix (Round 3)	Difficult	Predictive Analysis	Advanced
379	Inspire 2023 Grand Prix (Round 2)	Intermediate	Spatial	Advanced
378	Inspire 2023 Grand Prix (Round 1)	Basic	Data Preparation	Core
377	Video Game Sales Insights	Basic	Data Preparation,Transform	Core
376	Unlock Insights from FIFA Women’s World Cup Data!	Basic	Join,Data Preparation	Core
375	When is Father’s Day?	Basic	Data Preparation	Core
374	Using Iterative Macros	Intermediate	Macros	Advanced
373	Fish and Chips, Anyone?	Intermediate	Data Preparation,Transform	Core
372	A Header Reference Dataset from Excel Header Reference Letters	Intermediate	Data Preparation	Core
371	Generate Corporate Email Addresses	Intermediate,Difficult	Parse,Join,Apps	Advanced
370	Buzz Buzz	Basic	Parse,Transform	Core
369	Formula 1 Grand Prix (In)efficiency	Intermediate	Spatial,Macros	Advanced
368	Time Zones	Intermediate	Parse	Core
367	Manipulating Dates – End of the Month	Intermediate	Data Preparation,Transform	Core
366	Three Columns Are a Crowd	Intermediate	Data Preparation,Transform	Core
365	LEGO® My Data!	Basic	Join,Data Preparation,Apps	Core
364	Career-Minded Barbie	Basic	Data Preparation	Foundation
363	Coffee or Tea? That’s the question.	Basic	Data Preparation	Core
362	Capital Gains Tax when Selling a Home	Intermediate	Data Preparation	Advanced
361	Cross Joins at Bedtime	Difficult	Join,Data Preparation,Transform	Advanced
360	Goodbye, Michael! (Part 2)	Basic	Data Preparation	Foundation
359	Manipulating Dates	Basic	Parse,Preparation	Core
358	Goodbye, Michael! (Part 1)	Intermediate	Join,Data Preparation,Transform	Core
357	College Majors in High Demand	Intermediate	Data Preparation,Transform	Foundation
356	Spelling Bee	Intermediate	Preparation,Join,Transform	Core
355	Analyze the Olympic Games	Basic	Data Preparation	Foundation
354	Analyze the World Cup Location	Basic	Spatial,Preparation	Advanced
353	A Pokémon Tournament	Intermediate	Parse,Developer,Join,Data Preparation,Transform	Core
352	Circular Embedding	Intermediate	Spatial Analysis,Parse,Join,Data Preparation,Transform	Advanced
351	Uber Pickups in New York	Basic	Parse,Data Preparation,Transform	Foundation
350	Create a Christmas Card	Intermediate	Join,Data Preparation,Reporting,Apps	Advanced
349	Analyze the World Cup Event	Intermediate	Parse,Join,Data Preparation,Transform	Core
348	Reorder a List of Names	Basic	Preparation	Foundation
347	Map Messi and Ronaldo's Goals (Part 2)	Intermediate	Spatial,Parse,Preparation,Reporting,Transform	Advanced
346	Map Messi and Ronaldo's Goals (Part 1)	Intermediate	Preparation,Join,Transform,Data Parsing	Core
345	World Cup Sweepstakes (Part 2)	Intermediate	Parse,Preparation,Join,Reporting	Advanced
344	World Cup Sweepstakes (Part 1)	Intermediate	Parse,Preparation,Join,Transform	Core
343	Average App Cost	Intermediate	Parse,Preparation,Transform	Core
342	A Marathon in Paris (Part 2)	Intermediate	Spatial,Parse,Data Preparation,Reporting	Advanced
341	A Marathon In Paris	Basic	Spatial,Parse,Data Preparation	Advanced
340	Say Cheese (Part 2)	Basic	Preparation,Transform	Core
339	Say Cheese Part 1	Basic	Parse,Preparation,Transform	Core
338	Let's Summarize!	Intermediate	Parse,Preparation,Transform	Core
337	Create a New List from an Existing List	Basic	Parse,Data Preparation	Foundation
336	Valuable Technical Skills	Basic	Join,Data Preparation,Transform	Core
335	Movie Decisions	Basic	Join,Data Preparation,Transform	Core
334	Literacy Practice	Basic	Data Preparation,Transform	Core
333	Remote or Not Remote	Intermediate	Data Analysis,Data Preparation	Advanced
332	The more ice cream, the better!	Intermediate	Parse,Join,Data Preparation,Transform	Advanced
331	Time for College!	Basic	Data Preparation,Transform	Core
330	Check out the weather	Basic	Parse,Join,Data Preparation,Transform	Core
329	Near Earth Objects	Intermediate	Parse,Data Preparation,Transform	Advanced
328	Booking a Flight? Think Twice!	Basic	Join,Data Preparation,Transform	Advanced
327	A place to stay	Intermediate	Parse,Data Preparation	Advanced
326	Totals and Subtotals Part 2	Basic	Data Preparation,Transform	Core
325	How many hot dogs can you eat?	Intermediate	Data Analysis,Data Preparation	Advanced
324	Totals and Subtotals	Basic	Data Preparation,Reporting,Transform	Advanced
323	Analyze books Availabilities	Intermediate	Join,Data Preparation	Advanced
322	Good Ladies Heist	Intermediate	Parse,Data Preparation	Core
321	Eurovision	Intermediate	Parse,Data Preparation	Advanced
320	Women Representation in Politics	Basic	Data Preparation,Reporting	Advanced
319	Sports Spots	Intermediate	Data Analysis,Data Preparation	Core
318	My first dog	Basic	Data Preparation,Reporting	Advanced
317	Blowing in the Wind - Part 2	Intermediate	Parse,Reporting and Visualization	Advanced
316	Blowing in the Wind - Part 1	Basic	Parse,Data Preparation	Advanced
315	The One Where Everyone Talked	Intermediate	Macros	Advanced
314	Hot Real Estate Markets	Intermediate	Data Analysis,Data Preparation	Advanced
313	Base Converter	Difficult	Apps,Macros	Advanced
312	Hours, Minutes and Seconds	Basic	Data Preparation	Core
311	Finding Whale Sharks	Basic	Spatial	Advanced
310	Maintenance Schedule	Intermediate	Data Analysis,Data Preparation	Advanced
309	Movie Catalogue	Basic	Data Preparation,Reporting	Advanced
308	Size it up	Basic	Preparation,Data Preparation	Core
307	Round-robin	Intermediate	Apps,Macros,Interface	Advanced
306	Corporate Superhero	Basic	Preparation,Reporting and Visualization,Data Cleansing,Join,Transform	Advanced
305	International Bank of Awesome Data - Part IV	Basic	Reporting and Visualization,Data Preparation,Reporting	Advanced
304	International Bank of Awesome Data - Part III	Intermediate	Reporting and Visualization,Data Preparation,Macros,Interface	Advanced
303	International Bank of Awesome Data - Part II	Intermediate	Join,Macros,Interface	Advanced
302	International Bank of Awesome Data - Part I	Intermediate	Data Analysis,Data Preparation	Advanced
301	New Year's Resolutions	Intermediate	Preparation,Reporting and Visualization,Data Preparation,Reporting,Transform	Advanced

[karlhansen]

Admins -- do you have a link to the first page, and a link on the first page to the second page?  Am I just missing these links?

[zacky546]

Hi!

Where do Ifind the list of challenges from # 1 - #300?

[cenviity]

Hi admins, just adding on to the comments above. It seems page 1 of the Weekly Challenges (#1 to #300) is no longer accessible at its original URL: https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275

Update: Page 1 above is now accessible again! Thanks, admins.

[vasavik_1]

In weekly challenges 

[rohityaman]

Attached workflow is modified version of the tracker workflow created by @Hannah_Lissaman, @Alekh, and @mceleavey. I have added the url for "weekly challenges - Page 2" too, to include all weekly challenges till date and to build the consolidated view of challenge completion status.

[efayne]

Excited to start working on the Weekly Challenges!

[AYXAcademy]

Hello Weekly Challenge Community,

We're experiencing issues recording Weekly Challenge #387 on our Index page. Rest assured, we're actively working on a solution. Thank you for your patience.

Best regards,

The Academy

[Erin]

Oops disregard this comment.

[shrestha_nitesh]

Link to the first page: https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome-Page-1/td-p/482...