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...
Last week's solution has been posted HERE.
A university analyst has been asked to help with course and classroom resource planning. The university sends course times in military time format. The university analyst wants the fields Military Begin Time and Military End Time to display in standard, 12-hour increments. So, if a course ends at 16:30, he would like it to show as 4:30. He also wants to know what the elapsed time is between the two fields mentioned above. How long is each course? Minutes will be the time unit measured.
... View more
Last week's challenge can be found HERE!
You have been given some order information that contains a list of orders with SKUs and related quantities. Additionally, you have a data set with the total inventory for each SKU.
You have been tasked with figuring out how to consume all of the inventory with the least amount of orders. In other words, you have been asked to fill the largest orders for each SKU in descending order.
Additionally, only complete orders may be fulfilled. For example, if an order calls for 4 units of a SKU, and only 3 are left in inventory, you can't fulfill the order.
... View more
A solution to last week’s challenge can be found here.
Welcome to a special Weekly Challenge where we will send you on a scavenger hunt to find a hidden word!
This week the Alteryx Certification Team has put together a special challenge that will put your Core skills to the test! Using a dataset compiling a portion of the Core Certification passing exam attempts from the past two years, you will solve 7 clues to find the hidden word. And then, with the Bonus Challenge discover the ultimate message from the Certification team.
This dataset represents Community users from all over the world that have passed the Core Certification exam and earned their Core Badge. (Percentages have been randomly generated, they are not actual exam results.)
Hint
For each clue you answer, make sure to label the column "Answer".
Good luck!
... View more
A solution to last week's challenge can be found here.
In celebration of the Data Connections window and many other cool new features in the 2019.3 release, this challenge requires you to read in thousands of files across 15 different file formats: yxdb, sz, avro, csv, shp, gml, sav, json, mif, tab, xlsx, xlsm, qvx, sas7bdat, geo. Each file contains a single value. Report back the sum of all values.
Hint: suffix FileFormat yxdb 19 sz 16 avro 48 csv 0 shp 12 gml 31 sav 46 json 54 mif 10 tab 14 xlsx 25 xlsm 56 qvx 47 sas7bdat 45 geo 15
... View more
The solution to last week's Challenge can be found HERE!
It's that time of year again....the leaves are starting to change color, the smell of pumpkin spice is in the air, and the amount of daylight for @JoeM's post-work bike rides is getting smaller and smaller. Just how much daylight did we lose this month? Take this week's Challenge to find out! Using the Input data provided, calculate the amount of daylight for each day in September, as well as the day-to-day differences in daylight and the total difference from September 1 to September 30.
*If you'd like to use a dataset for your location, you can download data on sunrise/sunset times from this site: https://www.timeanddate.com/sun/usa/ for US-based users.
... View more