ブルーの六角形模様
Customer Story

Automation at Amway Results in Over $80,000 of Savings Annually

ブルーの六角形模様

Amway Key Stats

Industry: Construction
Department: Business Intelligence
Retail: North America
Alteryx

Overview

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 E-bay 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.

Describe the problem you needed to solve

We found Alteryx through Tableau. It started with simple Data blending and Tableau data automation, but grew from there:

  • Automating Manual Scorecards/metrics
  • Translation Macro using Google Translate
  • E-Bay Web Scraping
  • Amazon Web Scraping
  • Commodity Predictive Modeling
  • Spatial

Describe the working solution


We are using a wide range of data sources including excel, access, SQL Server (In DB tools), Oracle (In DB tools), SharePoint, Google Sheets, E-bay, 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.

Describe the benefits you have achieved

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.
    • These savings are simply based on time savings. Factor into it the ability to run these workflows daily and deliver insights to our users and this is very conservative.
    • These workflows are now reusable processing engines that we can continue to enhance and build off of.

  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. E-bay 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!

Share the insights with your team

Analytic Automation that adds up

With Alteryx Analytic Process Automation™, organizations can realize top-line growth, bottom-line savings, risk reduction, and efficiency gains.
roi-calculator

Put your data to work

86% of new Alteryx users deliver business value in their first week. Join thousands of practitioners who are breaking data barriers and dragging and dropping their way to insights.
ノートパソコンで作業している従業員
マクラーレンのレーシングカー
お客様事例
5 分で読む

データ分析の高速化により、勝利を手中に収めるマクラーレン・レーシング

週末に開催される F1 レースは年間 20 戦以上にも及び、1 レースあたり 1.5TB ものデータが生成されるため、こうした膨大な量のデータの効率的な収集、処理、活用を可能にするソリューションは欠くことのできない存在です。
マクラーレン F1 チームでは、Alteryx Analytics Automation Platform を使用して、サーキット内外で戦略的な意思決定を加速させています。

サプライチェーン
アナリティクスリーダー
ビジネスインテリジェンス/分析/データサイエンス
今すぐ読む
Apter Streamlines Customer Tax Projects with Alteryx
お客様事例
5 分で読む

Apter 社が Alteryx + UiPath で顧客の税務プロジェクトを効率化

税務コンサルティング会社の Apter 社は、完全に自動化されたエンドツーエンドの税務管理ソリューションをわずか 3 週間で構築しました。

リスク低減
UiPath
ビジネスリーダー
今すぐ読む
Roquette 社の動的コンテンツ
お客様事例
5 分で読む

Roquette 社におけるデータ文化の醸成

植物由来の原材料の世界的リーダー企業が Alteryx の導入により、戦略的な意思決定を大規模に実現。

アナリスト
データサイエンティスト
ビジネスリーダー
今すぐ読む

Experience the power and ease of Alteryx

無料トライアル