Alteryx Academy

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by our ACE Carolyn Canterman (@Carolyn). Thank you, Carolyn for your submission!   The Sarbanes-Oxley Act of 2002 (SOX) is a U.S. federal law enacted to protect investors by improving the accuracy and reliability of corporate disclosures. Under SOX, companies must implement internal controls over financial reporting.   These controls are categorized as: Key Controls – considered critical for financial reporting and subject to stricter review Non-Key Controls – important, but with less scrutiny   Each SOX control requires: A Preparer, who performs the analysis. A Reviewer, who independently reviews the work.   Both the Preparer and Reviewer must sign off by entering their name and date. This sign-off process is logged as evidence of proper control execution.   You are an auditor reviewing the SOX Control Sign-Off Log for accuracy and compliance.   You will be provided with three input files: The SOX Control Sign Off Log, evidencing the Preparer and Reviewer sign off for each Control, for two different months. Information on the employees. List of issues that you are checking for.   Use the Issue Rule List to validate each Control entry. A control has an issue if it violates any of the following rules: Both Preparer and Reviewer must be present, and they must be different individuals. Sign-off dates must follow proper sequence: Both Preparer and Reviewer must have a date. Reviewer date must be within 5 days after the Preparer date (inclusive). Reviewer date cannot be before the Preparer date. If the SOX Control is marked as a Key Control, the Reviewer must be a manager.   Your Tasks   Task 1: For each Control in each Period, count how many issues are present according to the rules above. Note: If information is missing or unclear and you cannot determine whether there’s an issue, do not count it as an issue.   Task 2: Which Period had more total issues — March 2025 or April 2025?   Task 3: Task 3: Across both periods, which control had the most issues in total?   Bonus Task: Which person is associated with the most total issues across all controls and periods?   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Download Start File Download Solution File ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Guilherme Dias, @3I_ATLAS . Thank you, Guilherme, for your submission!   This challenge is designed to test your advanced Alteryx Designer skills, particularly in app development, data manipulation, and logic handling.   You've just landed a high-profile client who operates a casino, and they’re curious to see how Alteryx stacks up against a human dealer. Your task is to build an Alteryx Analytic App that simulates card dealing in a casino setting.   You’ll be provided with two datasets: One containing suit symbols and names One containing card values (2–10, J, Q, K, A)   You recently got a new high-profile client who runs a casino. They want to run some simulations to see how Alteryx would compare against a human dealer. This is a APP-based challenge where you can test your more advanced skills in Alteryx Designer.   Your first dataset contains the suit and suite names, and you second dataset contain the card values (2-10, J, Q, K, A).   Task 1: Build the Full Deck Using the two datasets, generate a complete standard deck of 52 playing cards by combining all card values with each of the four suits.   Task 2: Develop an Alteryx App that: Randomly shuffles the deck. Prompts the user to input: The number of players (between 2 and 10) The number of cards to deal to each player (between 1 and 13) Distributes cards accordingly: Each player receives the specified number of cards The remaining cards are placed in a separate draw pile (output dataset) Notes: You may assume that users will enter only valid combinations (i.e., the total number of cards dealt will not exceed 52). A macro is available to shuffle the cards, if needed.   Task 3: Sort Each Player’s Hand by Custom Rules Implement custom sorting logic for each player's hand based on the following criteria: Suit Frequency: Suits with fewer cards in hand appear first. Lowest Card Tiebreaker: If two or more suits have the same number of cards, the suit with the lowest-ranking card comes first. For example, a hand with 6♣-A♣ comes before Q♠-K♠ because 6 < Q. Suit Priority: If the lowest cards are the same, use this suit priority as a final tiebreaker: Spades (♠), Hearts (♥), Diamonds (♦), Clubs (♣)   Example: For the hand K♦, 2♠, 6♠, 2♣, K♣: Suits with 2 cards: Spades and Clubs Both have a lowest card of 2 Suit priority applies: Spades come before Clubs   Final order: 2♠, 6♠, 2♣, K♣, K♦   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment. Good Luck!   The Academy Team   Download Start File Download Solution File ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by our ACE Calvin Tang, @caltang . Thank you, Tang for your submission!   Organizations often deal with poorly formatted financial data stored in fixed-width flat files, which creates inconsistencies and makes analysis difficult. In this challenge, you will work on cleaning and standardizing transaction records containing account numbers, customer names, transaction types, and amounts. The goal is to improve data quality, enable efficient management, and support better financial decision-making.   Develop a workflow in Alteryx to:   Clean and format the data, then calculate the total for deposits and withdrawals. Use the Interactive Chart tool to create a graph that displays the total deposits and withdrawals.   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Download Start File Download Solution File   Source: Dataset generated by AI (POE). ... View more

A solution to last week's challenge can be found here.    This week's challenge focuses on a group of relatives and their birthdays. Of the six family members, we have one person's date of birth and a series of clues to calculate the others. Provide the DOB for all family members and the day of the week s/he was born. ... View more

A solution to last week's challenge can be found here.    Palindromes are words that are spelled the same backwards as forwards. They aren't inherently better than other words, but they have a special name and we think that counts for something! Speaking of counting...   For this week's challenge, count the number of palindromes in the provided dataset. Also, find the most common starting letter for the palindromes and count the number of palindromes that begin with that letter. ... View more