Region: North America
Industry: Retail and Consumer Goods
Department: IT
Company Background: Amway is an American multi-level marketing company that sells health, beauty, and home care products. The company was founded in 1959 by Jay Van Andel and Richard DeVos and is based in Ada, Michigan. Amway and its sister companies under Alticor reported sales of $8.9 billion in 2019.
Data Stack: Google Cloud, Google Cloud Dataprep, and BigQuery.
Global Procurement at Amway began its journey with Alteryx by purchasing 2-licenses in October of 2015. We generated instant value from this tool, and knew there was so much untapped potential. A few short months after our initial purchase, we started hosting internal Alteryx enablement sessions to spread the word throughout our organization. It wasn’t long before we were up to 10 licenses. As our scope continued to expand, IT got involved and pursued a mini-trial that included Server for the remainder of 2016. In 2017 we purchased the full year pilot to drive even greater user adoption. Today, we have over 30 users and growing!
As our user base and experience with Alteryx grows, we have evolved from diverse data blending to language translation and normalization. We are moving from old legacy tools like Access and Excel, into the modern world of Analytics with Tableau and Alteryx. We are structuring data that we once thought to be impossible, and even built out applications to search online eBay and now Amazon. We are pushing into the world of predictive analytics. Models are being developed and geospatial tool-sets are being examined. Most of these were pipe dreams before we were introduced to Alteryx. Now we are making these things come to life and blazing a trail for Analytics at Amway.
We found Alteryx through Tableau. It started with simple Data blending and Tableau data automation, but grew from there:
We are using a wide range of data sources including excel, access, SQL Server (In DB tools), Oracle (In DB tools), SharePoint, Google Sheets, eBay, and Amazon. Most of our data sets are published directly to Tableau Server. We have Server up and running to automate most of our Tableau Dashboards. Alteryx Gallery for deploying Apps is our next project to tackle.
Alteryx is the engine that is driving our team to new levels. We are automating all of our scorecards from a data perspective. We are able to provide daily insights on the health of our supply chain verses monthly reporting. Here are a few of the major projects we accomplished inside of Alteryx.
1. Automated over 20 data processes, eliminating over 350 hours of data prep, and saving over $80,000 annually.
2. Using Alteryx we are able to automate the translation of data. We operate in over 100 countries. Using Alteryx we developed a workflow that can go through our data and translate it automatically using Google translate. We plan on deploying this on our Server as an App for others to leverage.
3. Jordan Howell eliminated a custom Access Database that cost us $3 Million dollars to build. This process eliminates 40 hours a month in manual data preparation due to the database, and will save us $24,000 a year. In 3 weeks he was able to recreate the database in Alteryx.
4. eBay and Amazon web scrapping to effectively audit Amway products that are being sold on these sites. Before Alteryx we manually accomplished this, and we would only get 1-10% of the total products on the sites (We had trouble answering questions at a Macro level about how many products). After Alteryx we can do this in seconds and have 100% of the products. Allowing users to focus on delivering insights from the data and not having to pull it!
Region: North America
Industry: Retail and Consumer Goods
Department: IT
Company Background: Amway is an American multi-level marketing company that sells health, beauty, and home care products. The company was founded in 1959 by Jay Van Andel and Richard DeVos and is based in Ada, Michigan. Amway and its sister companies under Alticor reported sales of $8.9 billion in 2019.
Data Stack: Google Cloud, Google Cloud Dataprep, and BigQuery.
[CUSTOMER STORY] Amway Adapts to Product Hierarchy Changes in Minutes
Read More[WHITE PAPER] Fight Fraud, Waste, and Abuse with Analytics Automation
Read More[WEBINAR] Breaking the (Supply) Chain: Analytical Hurdles of Safety Stock Optimization
Read More[WEBINAR] Breaking the (Supply) Chain: Amway’s Analytics Strategy for Stock Optimization
Read Morelargest consumer packaged goods companies use Alteryx
Kingfisher
Kingfisher Transforms People Analytics with Alteryx
Kingfisher, a London-based home improvement company, leverages Alteryx for people analytics. Their goal is to attract and retain talent while enhancing employee satisfaction
Read MoreCoca-Cola Company
Taste The Feeling: Coca Cola + Alteryx
Over 1.9 billion Coca-Cola beverages are enjoyed daily around the globe.
Read More