Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

New Associate Project Thread

WillM
Alteryx Alumni (Retired)

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

 

  1. Choose a representative to post on behalf of your team
  2. Share your project and any background you'd like in your post, and make sure to @mention each teammate and include files as well as links to data sources you've used (Format example below)

    Team Number | Date | Team Members
    -Project Description - Use this space to tell your story about what you wanted to accomplish with your project, what questions you asked, etc
    -Data Sources used
    -Files for your workflow

  3. Keep an eye on any responses you get, you might learn some really great stuff from the community at-large

 

COMMUNITY MEMBERS

 

  1. If you have time and interest, take a look at the projects submitted by the new Associates
  2. If you're impressed, like their post and give them any feedback you have, just make sure to @ mention the team members. This is a great chance to start a dialogue!

 

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.

 

Will Machin
Community Management Team Lead
Alteryx
37 REPLIES 37
JJI
Alteryx
Alteryx

Team Number 1. | Jan. 14, 2021 | @Staon@TomasS@VojtechFried@JJI 

 

- How the opening move influence your change to win in chess

- Output to html and pdf

- 20000 chess matches from Kaggel

mztokyo
Alteryx Alumni (Retired)

@JinLiThong

 

-Project Description:
UK and US Best Selling Albums

We enjoy music and wanted to compare the best selling/highest ranked albums in the UK and the USA.

-Data Sources used:


USA Best Selling Albums
https://www.digitalmusicnews.com/2018/12/26/100-best-selling-albums-artists-2019/


UK Best Selling Albums
https://www.officialcharts.com/chart-news/the-best-selling-albums-of-all-time-on-the-official-uk-cha...


We are posting this because we would love to learn how to handle the data cleansing with fewer REGEX statements.
Or a completely different way to handle the data.

Lots of Learning opportunities for data preparation and blending.

1. A hyphen in the album name (same as other delimiter)
2. US Artist name included "The". But the UK artist name did not in "The". Ex. "The Beatles" and "BEATLES".
3. UK Artist name was all caps. US Artist name was in Title format
4. Some hidden spaces and delimiters were not easily/automatically found
5. Regex functionality is very powerful but still requires some effort.
6. It takes a little effort to properly word/phrase your search in community.


Interesting observations:
Surprised that the below UK artists did not make the UK Ranking.

Led Zeppelin (four albums in the US), Elton John, Def Leppard, The Rolling Stones, Eric Clapton, AC/DC

There is a large difference between the ranking the artist achieved in the UK and the US.

We hope all of you enjoy and discover some other surprises.

RyanRo
Alteryx Alumni (Retired)

Team 3 | Feb 11th, 2021 | @TylerH @sarahwelch 

 

Project Description: How have the price + quality/rating of red wine trended globally over the last 10 years?

 

Data Sources:

  • Global wine price + rating data (Kaggle)
  • Country-level spatial data (ESRI)
pcan415
Alteryx Alumni (Retired)

Team 5 | 2/11/2021 | @johnfree , @victoriadimarco , @pcan415 , @Nelson8 

 

-Project Description:

Challenge #15: Warehouse Shipped Miles

 

We calculated the total shipped miles per item. The products were available from 3 different warehouses, lat/lon data is provided for each warehouse and each store location.

 

Our goal was to find the total distance travelled in miles for each item based on it being shipped from the closest warehouse

 

Enjoy!!

gouthamiunnava
Alteryx Alumni (Retired)

  @OleksandrVlasov  @PavelPankov 

 

Team# 1 | 11/02/2021 | Pavel Pankov, Oleksandr Vlasov and Gouthami Unnava


Project Description:

We extracted the tweets mentioning Alteryx in the last 7 days and did a sentiment analysis on the data

 

Data Sources:
Twitter data extracted using twitter API

matthewdemas
Alteryx
Alteryx

 

jvansickle
Alteryx
Alteryx

Team 4 | 03/11/2020 | @Gabrie11a@Angela_Menegassi, @Marootian , @jvansickle 

 

We decided to investigate whether there is a correlation between economic freedom and happiness of a country. We also investigate some specifics of the happiness metrics seeking a more clear indicator of happiness. We also mapped the top 15 happiest countries to visualize whether the happiest countries are or are not in the same region.

 

We have four separate data sources:

- Happiness Data

- Economic Freedom Data

- GDP per capita

- world_coordinates

marisabaptista
Alteryx
Alteryx

Team 3 | 3.11.2021

This project was completed by @JPKribs@marisabaptista@aihua and @DanM-CO

 

Between Hulu, Netflix, Disney+, and Amazon Prime, which is the best streaming service based on several personal preferences? 

 

What is the best streaming platform based on the following: 

 

Workstream:

  • Language requirement 
  • TV vs. movie preference
  • Genres 
  • Chosen recognized actors/actresses
  • New content vs classic content  
  • IMDB rating minimum 
  • Family content requirement 

Based on the preferences chosen above, the output would reflect the total content that fits your requirements and how well the average content fits your requirements. This analytic app will determine the best streaming service for you! 

 

 

 

 

 

 

vladimirkroupa
Alteryx
Alteryx

Team 1 - Igor Nikonenko, Jakub Mahnert, Lukas Sladky, Vladimír Kroupa

 

Sentiment analysis of movie plots

 

Questions asked:

 

Given only "famous" movies - movies where at least one of the actors is an academy awards winner:

  • What are the most common words in all the movie plots?
  • What are the most common words in movie plots with positive sounding plots?
  • What are the most common words in movie plots with negative sounding plots
  • Which movie directors are associated with the most positive sounding plots and which are associated with the most negative sounding ones?
  • Which movie genres in general contain movies with the most positive sounding plots and which contain the most negative sounding ones?

 

Main tools used:

  • Sentiment analysis
  • Word cloud

 

Input data:

# Team 7 4/15/2021: 

@edward_vetterdrake@theglenjamin@harperschmidt, Haig Douzdjian

 

# Project Description:

Spotify metadata provides a lot of information about their tracks describing different aspects of songs such as acousticness, liveness, and danceability, among others. We decided to answer the question of "What country has the "danciest" music?". 

 

# Data Sources used:

  - SpotifyTopSongsByCountry - May 2020.csv

  - Spotify 1.2 M Songs.csv

Labels