ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

New Associate Project Thread

JJI
Alteryx
Alteryx

Team Number 1. | Jan. 14, 2021 | @Staon@TomasS@VojtěchFried@JJI 

 

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

- Output to html and pdf

- 20000 chess matches from Kaggel

mztokyo
Alteryx
Alteryx

@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
Alteryx

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)
patrickcanepa
Alteryx
Alteryx

Team 5 | 2/11/2021 | @johnfree , @victoria_perkins , @patrickcanepa , @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
Alteryx

  @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

 

johnvansickle
Alteryx
Alteryx

Team 4 | 03/11/2020 | @Gabrie11a@Angela_M_Burks, @Marootian , @johnvansickle 

 

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
5 - Atom

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