Alteryx Academy

A solution to last week’s challenge can be found here. calendar.png This week's challenge can be solved using either Designer Desktop or Designer Cloud.   Almost any data project will include dates. Working with dates is a common task and is important for downstream tasks such as reporting. In this week's challenge, we are going to cover a common date manipulation that many will encounter.   In this scenario, we have a column of date data that is in the format of MM/dd/yyyy. We want to reformat that data to yyyyquarter. Your goal for this challenge is to convert the date format from MM/dd/yyyy to yyyyquarter. As an example, change 2/15/2023 to 2023Q1. ... View more

A solution to last week's challenge can be found here.   To solve this week's challenge, use Designer Cloud or Designer Desktop. This challenge comes to us from @randall_king    Haven't heard about Designer Cloud yet? Watch a demo. In this weekly challenge, you need to clean and format data; sort data; and create a calculated field.   Your high school-aged child is planning on attending college after graduation. They do not know what they should choose as a major, so being the great parent you are, you want to steer them in the right direction. Based on this dataset, determine which majors have an employment rate equal to or higher than 80%. If you suggest these areas of study to your child, you may have the best chance of making sure they don't move back into your house after college graduation! For this challenge you should: 1. Split the data into columns on the comma delimiter. 2. Convert the first row of data into a header. 3. Assign appropriate data types to numeric columns. 4. Create a column that calculates the percent (rounded up to the nearest whole number) of students who are employed. Use the Employed and Total columns for your calculation. 5. Sort the data in descending order. 6. Filter the majors with an employment percentage equal to or higher than 80%.   Data Source: www.kaggle.com/datasets/tunguz/college-majors   ... View more

A solution to last week’s challenge can be found here.    To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic.    According to the Harvard School of Public Health, tea and coffee are the two most consumed beverages on the planet after water. They are brimming with antioxidants and other biologically active substances that may benefit your health.     For this week's challenge, we will use a dataset containing information about the sales of coffee and tea in the USA for a 6-month period.     Based on the sales of each product, determine the following:    Which state is the biggest consumer of regular coffee? Which state is the biggest consumer of decaf coffee? What type of coffee drink is the most popular? Which state is the biggest consumer of regular tea? Which state is the biggest consumer of decaf tea? What type of tea drink is the most popular?   Source: https://data.world/2918diy/coffee-chain  ... View more

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Desktop, Designer Cloud, Designer Experience, or Designer Cloud, Trifacta Classic.   Over the years, Barbie, the doll made by Mattel, has had a lot of different jobs! She has been super busy. Did you know she ran for President of the United States 10 times? Quite impressive!   This dataset complies a list of Barbies that were released from 1959 through 2020. It includes the career name and type of career for that Barbie.   For this challenge, first determine which career Barbie had more than twice between the years 2017 and 2019. Next, calculate by job type how many different types of jobs Barbie held over the years from 1959 through 2020, including the percentage of each.   Data Source: https://data.world/judkacag/barbies-careers-1959-2020  ... View more

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