This thread will function as a space to share all the projects from Alteryx Associates during Bootcamp training. It will consist of two aspects that will complement each other. Projects will be posted by a member from each team allowing community members to offer feedback, as well as vote on their favorite projects by liking those posts.
ASSOCIATES
COMMUNITY MEMBERS
We hope that this thread will be a fun way for new Associates to get involved in the community and make some connections with all of you that are here already, and we also hope that it allows our thriving community members a chance to meet some new folks at Alteryx! If you have any questions, feel free to reach out to me and I'll be more than happy to answer.
Team 5 | 14 September 2020 | @cshutto, @fbrunholi @MartyFlanders
Project Description: We wanted to find what are the three highest counties per state for Covid-19 cases per capita. We often hear about where there are high numbers of cases, but we wondered about the cases per capita for a county.
We found that the counties with the highest cases per capita don't always correlate to the counties with the highest population.
Team 4 | September 14, 2020 | @AndreiKarabelnikau @gfilla
Project Description - Understanding usage patterns and trends for the bike sharing service in Chicago (Divvy) . We explored 2019 data which provided observations for each ride / rental along with information on the type of rider such as birth year, gender, and user type. For our project, we sought to answer these questions:
Data Sources used
Note: This project was originally completed with full 2019 data and reduced to 2H (Q3/Q4 data) due to data size limitations for uploading and sharing to the community. If you are interested in analyzing the full 2019 data set, you can easily download the Q1/Q2 2019 files from the link above and connect them to the Join tool in the workflow.
10/12/2020 | @chase-zieman @ErinColton
Team: @Sergiy
- Project description:
Based on solar power plants generation data find out the following:
1. Predict generation for next 2 weeks for both plants
2. Is there any correlation between air temperature and generation productivity
3. Are there solar panels behaving abnormally (e.g. generation was two times less than average that day on that plant)
- Data source used:
kaggle.com
Team 1 | 9 November 20 | @brianflynn @tonygagliardi @sstall , @matt_griffis
-Project Description -
For our project we chose to answer the question posed in Weekly Challenge #106: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-106-How-Long-were-the-Lights-On/td-p/142...
Initially our workflow squirreled away from us, we had four nasty formulas in a row just to get the times into a different format, but then we discovered the Date-Time tool. It was pretty much smooth sailing from there. We ended up with two solutions and both are posted below.
-Data Sources used-
Provided by challenge.
-Files for your workflow-
See attached.
Team 3| Dec. 3, 2020| @bonej , @AshleyM
Project Description:
We wanted to look at data to determine which movie streaming service has the best movies based on ratings from Rotton Tomato and IMDb. We then wanted to explore if this changed with age (over 18, and under 18).
Data Sources Used:
MoviesOnStreamingPlatforms from Kaggle
- Project Description : Summarizing Top 100 Best Soccer Players' Nationality and adding columns of "Number of Players", "Average Overall Score" and "Average Value".
- Data Sources used : FIFA 19 complete player dataset (https://www.kaggle.com/karangadiya/fifa19)
Team 7 | 1/14/12021 | Mark Andre Luke Haberer Michelle Walker Steve Tso
Posting our boot camp project here.... hopefully the data comes along....
If not original data can be found here: https://www.kaggle.com/rohanrao/formula-1-world-championship-1950-2020
The goal of the workflow is to predict how a driver may have performed had they continued racing.
I was not able to get this to actually function, but if anyone in the community wants to take a stab please feel free.
Team 5 | 1/14/2021 | Regina Brown, Andy Neal, William Jette, Frank Lanasa, Andrew Crane