patrón hexagonal azul
Historia de cliente

La automatización en Amway genera más de USD 80.000 de ahorros anualmente


Amway Key Stats

Industry: Construction

Departamento: Inteligencia Empresarial

Retail: North America

Descripción general

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 la solución funcional

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 los beneficios que has obtenido

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!

Comparte insights con tu equipo

Leer la historia completa en la Comunidad

Recursos recomendados

Historia de cliente
Gregory Welteroth mejora el ROI en marketing con Alteryx
GWA ayuda a los clientes a ganar una ventaja competitiva al usar los insights de datos para llegar a más clientes potenciales.
  • Automatización de analítica
  • Automatización de procesos
  • Líder de analítica
Más información
Historia de cliente
Toyo Engineering automatiza procesos de ingeniería complejos con Alteryx
Toyo Engineering usa Alteryx para ahorrar tiempo, mejorar la calidad del diseño y reducir el riesgo en la construcción de grandes plantas químicas.
  • Automatización de analítica
  • Automatización de procesos
  • Líder de analítica
Más información
Historia de cliente
Siemens Energy democratiza los datos para respaldar la digitalización
Empresa de energía global impulsa la transformación digital y ahorra miles de horas de trabajo manual.
  • Automatización de procesos
  • Líder comercial
  • Inteligencia de negocios/Analítica/Data science
Más información