Não perca: Inspire 2024, de 13 a 16 de maio de 2024, no The Venetian em Las Vegas! Inscreva-se agora mesmo.

Customer Story

Amway Adapts to Product Hierarchy Changes in Minutes


Amway Key Stats

Industry: Multi-Level-Marketing

Data Stack: Google Cloud, Google Cloud Dataprep, and BigQuery

Region: North America


Faster to update product hierarchy

450 Products

managed daily

Core Challenges

Amway manufactures over 450 different nutrition, beauty, personal care and home products, each of which needs to be carefully categorized and organized in its product hierarchy. Updates to the hierarchy need to be made daily as categories expand, business lines evolve, and new products develop. However, Amway’s original desktop-based model was complex and required numerous manual updates, ultimately proving itself slow and unsustainable. Amway smoothed out some of these kinks after switching to a virtualization solution, but the solution’s SQL-based transformations required too much hand-holding from the engineering team. Analysts and engineers had to communicate back and forth about data requirements until, days later, the outcome produced was as expected. Neither solution allowed for flexibility nor agile changes to the product hierarchy.

How Dataprep Solved this Problem

Amway migrated its data to Google Cloud BigQuery and centered its product hierarchy around Dataprep. The transition to a cloud-based, self-service data engineering technology has dramatically reduced time-to-insight—whereas before Amway would have to wait two to three days before a change could be realized, now it’s a matter of minutes. Much of this acceleration is credited to Dataprep’s ease of use. Analysts can easily obtain product hierarchy data and make direct changes without communicating back-and-forth with engineers. Plus, Dataprep has improved visibility into the product hierarchy with clear audit trails and data lineage. The result is a more streamlined and agile product hierarchy that can quickly respond to new changes each day.



More Agile Analytics

Amway was able to reduce time spent making changes to its product hierarchy from 2-3 days down to 5-7 minutes.

Reduced Resourcing Costs

Amway’s engineering team has been freed up to focus on more complex deliverables instead of responding to data requirements.

Improve Business Strategy

Amway analysts can now obtain data at different hierarchy levels and, using their unique business knowledge, remodel the hierarchy for the most profitable option.

Company Background

Amway is the world’s largest direct selling company* ($8.8B reported sales, 2018). It manufactures and distributes nutrition, beauty, personal care and home products, which are exclusively sold in 100 countries through Amway Independent Business Owners (IBOs).

Watch Video

Supply Chains to Data Pipelines: Modern Retail Analytics


We can update daily—it’s allowed us to reduce that time-to-insight as far as making changes. Because as you know, the product hierarchy needs to be updated daily. We have new items coming in and new changes to items, and, through this process, we can allow this to happen in a rapid way. … We don’t have to rely heavily on any technical staff to make this happen.


Kevin Schaefer, Sr. Data Engineer



Assess Your Analytics Maturity

Get a better understanding of where you stand on the analytics maturity scale – and where you want to be.



Recommended Resources

Customer Story
Taste the Feeling Coca-Cola Alteryx
Over 1.9 billion Coca-Cola beverages are enjoyed daily around the globe.
  • Cloud Products
  • Data Prep and Analytics
  • Designer
Learn More
Customer Story
Armor Express Uses Predictive Supply Chain Analytics to Help Protect More Lives
Armor Express took predictive modeling to the next level with real-time data feeds that inform supply chains — saving $500k through inventory optimization.
  • Data Science and Machine Learning
  • Supply Chain
  • Manufacturing
Learn More
Customer Story
From problem-solving designs to problem-solving analytics at MillerKnoll
MillerKnoll established an end-to-end analytics architecture to analyze disparate data, and a COE for workforce upskilling—making $300k in annual cost-of-good savings.
  • Sales
  • Supply Chain
  • Manufacturing
Learn More