Alteryx Academy

Congratulations on completing Exercise 1!    When you are ready to submit your solution, click "Reply" to this post and upload your workflow.   You may also download and review the attached solution. ... View more

Last week's solution is now up - find it here!   This week, we are looking at a few accounts. In this set of data, there are 4 accounts. The first row of every account represents the number of credits/debits against the account, and the second row represents the actual credits and debits paid against the account in the order they were paid. Your task is to find the credits and debits where the sum of debits and credits BEFORE any transaction is equal to the sum of debits and credits AFTER it. Please count the transactions from 0 to match the answer. Below is a picture that illustrates the logic of which transactions should be captured. The picture represents the second account.   Sample logic: ... View more

A solution to last week's challenge can be found here!   This week's Challenge come to us from @T_Willins!    Your tax group has advised you that the information they need is available only in a .TXT report. To properly import the data into a subsequent system, they need the data filtered and in a specified format.   First, match the ID no. from the totals rows to the corresponding detail lines. Then filter to only detail rows with a tax codes of P1 or P9. Format, sort order and field names on the output file must match the given output for the file to load correctly.       ... View more

A solution to last week's challenge can be found here.    This week's challenge was submitted by @BeginnerMindset  - Thank you for your submission!   When we’re building spatial models or performing geospatial analysis, we often need to work with centroids; in general terms, this can be defined as the centre of mass for the polygon assuming uniform density. In other words, it’s just “a dot in the middle” of whatever unit of geography we are using. However, it is usually important that we use a population-weighted centroid, which might be quite different. We’re also interested in the demographics (eg. age, life-stage, affluence) - we want to know “who lives where” and ultimately “where do our target customers live?”   This is a three part challenge:    1. Map the (unweighted) centroids of each country in the UK (Beginner)    2. Map the population-weighted centroids for England and Wales. How far away are they from the unweighted centroids (in miles) and which cardinal direction? (Intermediate)    3. Investigate how the Over 65s are spread across England and Wales. (Advanced)        a) First calculate the percent of Over 65s within each Local Authority (LA).        b) Create a thematic map to pick out the patterns. Modify the settings (colours, bands, borders) to paint a clearer picture. Include a title and a footer for the ONS copyrights.        c) How does the proportion of Over 65s correlate with population density. Create a scatterplot and calculate the Pearson and Spearman correlations. Is there a strong relationship? Is it linear?   Note: all the data is from the ONS (Office for National Statistics) and is released under the terms of an Open Government License, so it is vital to include any relevant copyright statements if reproducing any maps or analysis that utilise this data. See full details here: https://www.ons.gov.uk/methodology/geography/licences ... View more

A solution to last week's challenge can be found here.    This week's challenge was submitted by @CharlieS - Thank you for your submission!   Each of the states in the USA have a proud history and unique culture. They also have unique two letter abbreviations. Inspired by this NPR Sunday Puzzle, use the two letter abbreviations from four states that border each other to create eight letter words.   One input contains spatial objects for each state and the other contains eight letter words. Find the possible combinations given the constraints above. ... View more