Author: Suzanne McCartin (@SMCCARTI) , Sr. Ops Reporting Analyst
Company: Nike, Inc.
Awards Category: Name Your Own - Get Back In Time
Describe the problem you needed to solve
My two my personal favorite Nike values are 'Simplify and Go' and 'Evolve Immediately'! In Nike Apparel Global Product Creation Operations. Our immediate need was to replace a critical and core data set on a tight timeline. Making sure our product creation centers didn't lose buy tracking visibility. Buy readiness is the measure and metric for garment commercialization. Do we have everything we need to purchase? This was just the beginning...
Describe the working solution
The buy ready metric process was implemented using a combination of tools and the first step was to replace the one data source, adding Alteryx to the tool mix. The build process was then reconstructed and migrated to Altetyx using blending and in-database tools. Going from about a 5 hour process to 1 hour.
The next follow up solution was to upgrade the report generation processes. The first solution was one process for each output, and each one had its own data collection process. Each of these solutions was moved to one workflow using the same data collection process. Allowing me to enforce Nike's single version of the truth mantra! This solution has all kinds of data cleaning , mapping, and shaping.
Describe the benefits you have achieved
The first round benefit was getting the upgrade done and we did so with improved accuracy and data visibility. The real benefit was to allow the process to get us back to the future and we are lined up to better collaborate with IT and move to Tableau and other new platforms!