Melissa and Doug, Wilton, Connecticut,, is a privately held American manufacturer of children’s toys with about 1,000 employees worldwide. Melissa and Doug has experienced steady growth since the 1980’s and was operating the business with a homegrown ERP and Warehouse Management system with ad-hoc reporting capabilities using Tableau. 2020 brought changing business requirements and MnD experienced a difficult time accommodating them due to an inflexible Data Management architecture.

Myers-Holum, Inc (MHI) provided the strategic recommendation to implement an improved Data Management platform using Google Cloud with Looker for their data modernization efforts. We worked with the business to document future state KPI requirements, facilitated a data governance program, and defined their future state BigQuery EDW architecture using Cloud Composer, Cloud Storage, BigQuery SQL.

New requirements came along at the end of the implementation project to report across newly created channel hierarchies, sales hierarchies, and region hierarchies. The newly built Data Management solution allowed for a quick implementation of the new requirements to satisfy business needs to respond to the changing business landscape of 2020.

“The newly built data management solution  allowed for a quick implementation of new requirements that satisfied the business need to respond to the fast-changing landscape in 2020”  Chris Conway, CTO, Melissa and Doug