Spartan Nash has business interests in various sectors related to the wholesale and retail distribution of food and consumer products. As a result, each area generated a vast volume of data each year, which was essential for gaining an overall understanding of the business.
BCG was brought in as 3rd party consultancy in order to help provide increased visibility into the operating business metrics. At the time, they produced a first iteration of an ETL pipeline based on Alteryx that would create these consolidated metrics for analysis. However, the existing architecture was outdated and resulted in data quality issues that entangled effective analysis and key business decision-making.
This unreliable data made it difficult for the organization to gain accurate insights and make informed decisions, leading to potential missed opportunities and decreased competitiveness in the market.
They needed a top-notch, resolutive tech partner who could assess their current workflow processes on Alteryx (ETL) to identify inefficiencies or areas for improvement.
The optimization ¡developed by Moonshot involved refactoring and modifying ETL workflows to make them more efficient and easy to maintain. Through collaboration with key stakeholders and extensive analysis, Moonshot proposed milestones to achieve significant improvements in data processing.
The team built the necessary Snowflake tables to store the Alteryx workflow output. With the partnership between team members from Moonshot and SpartanNash, they confirmed that the data loaded into Snowflake was accurately retrieved by PowerBI and met the necessary criteria for generating the required reports.
The workflows were refactored into easy-to-change silos, with each workflow responsible for a single area of business logic. Moonshot's team combined all the necessary steps in the correct sequence to deliver effective workflows that streamlined the Spartan Nash process.
The project delivered well-documented Alteryx workflows, explaining each business logic unit's purpose and method. The project team recommends that SpartanNash avoids using SharePoint inputs in Alteryx to minimize the time investment in configuration, maintenance, and workflow execution.
Establishing a standard schema for data structures used by all departments is recommended to simplify the business logic and help optimize workflows.
The optimization resulted in more efficient, easier maintenance, and well-documented workflows on Alteryx that explain the purpose and method of each unit of business logic. After the partnership, the team also identified potential risks, reported some of the current technology's limitations, and delivered detailed recommendations, technologies, and platforms to optimize future workflows.
"Good working with you guys – smart team." Benjamin Smith (Director of Data Analytics)