Amway, a multi-level-marketing company, manufactures over 450 different nutrition, beauty, personal care, and home products. Each of these products needs to be meticulously categorized and organized in its product hierarchy. The hierarchy requires daily updates as categories expand, business lines evolve, and new products develop. However, Amway’s original desktop-based model was complex and required numerous manual updates, proving itself slow and unsustainable. Amway attempted to smooth out some of these issues by switching to a virtualization solution, but the solution’s SQL-based transformations required too much involvement 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.
Read More