Maveryx Academy

A solution to last week's challenge can be found here.    This week's challenge was submitted by @AShapiro  - Thanks for your contribution!   What’s your favorite flavor of ice cream? Hard to choose just one? With ranked choice voting (RCV), you don’t have to! With RCV, you can rank your favorites in order of choice. For this week’s challenge, we have the results of a Favorite Flavors of Ice Cream poll. Build a workflow to conduct a RCV to find the voters’ favorite flavor and the total number of voting rounds. If a flavor receives more than half of the first choices, that flavor wins. If not, the flavor with the fewest first choice votes is eliminated. For voters who picked that flavor as their “Number 1”, their votes shift to their next choice. The process continues until a flavor has more than half the votes. Click here for a video explanation of RCV. ... View more

  A solution to last week's challenge can be found here.   This challenge comes to us from our ACE @Kenda . Thank you for your contribution, Kenda!   Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.   Father's Day is an annual celebration in the United States, observed on the third Sunday of June. As a result, the exact date of this holiday varies each year, meaning it is not fixed to a specific calendar date.   This week, we are providing a dataset that includes only the year, and your challenge is to determine the exact date on which Father's Day occurs in each year.   Have fun with the challenge and happy Father's Day to all the dads solving this challenge! ... View more

A solution to last week's challenge can be found here.     This challenge comes to us from @EW  - thank you for your contribution!   A group of friends can't decide on a movie theater at which to see a movie. Given the locations of their apartments and major movie theaters in the area, determine the top three movie theaters to minimize total distance traveled in one direction.  Create a map with the theater and home locations.    Source: GIPHY     ... View more

A solution to last week’s challenge can be found here.  Source: https://commons.wikimedia.org/wiki/File:Combination.png   This week's challenge was submitted by @Kenda  - Thanks for your submission!   Mathematicians and statisticians often work with permutations and combinations. In this challenge, we will focus on the latter. You are given 15 unique variables. The goal is to create a list of each of the combinations containing 3 variables (that is, 15C3). Remember, with combinations, order does not matter and the same variable cannot show up more than once in a given combination.   Since @Kenda is vertical user, this week's challenge is also a vertical workflow! ... View more

A solution to last week’s challenge can be found here. It's vacation time. Will your flight leave on time?    Are you getting ready for vacation and worrying about the long hours of delay at airports? This is always in the back of our minds as we make a flight reservation, isn't it? Let's look at how bad flight delays were in the summer of 2021, which officially started on June 21 and ended on September 22. Based on the dataset Flights_2021, which contains a random sample of all the flights in 2021, and the two tables provided, let's find the following information:   1. What were the five top airlines with more delays that summer? 2. What Airline had the longest delayed time that summer? On what date? 3. What were the top five airports with more flights delayed that summer? 4. How many flights were canceled that summer?   Note: CRS_Dep_Time= Scheduled Departure Time (local time: hhmm) Dep_Time: Actual Departure Time (local time: hhmm) Dep_Delay: Difference in minutes between scheduled and actual departure time. Early departures show negative numbers.     Thank you for your comments, this challenge has been updated. ... View more