Investigate the relationship between sales and pricing of your yogurt brand (Chobani) and the pricing of a competing brand (Yoplait)
You are a demand planner for Chobani, a large yogurt manufacturer, and would like to investigate the relationships between sales and pricing of the Chobani yogurt brand and the pricing of its primary competing brand Yoplait.
Weekly sales for the Chobani yogurt brand across several grocery chains has been exported to an Excel spreadsheet. The file is named Yogurt_Sales_Data.xlsx. Weekly pricing of Chobani and competing brands across the grocery chains has also been generated. This file is named Yogurt_Pricing_Data.xlsx.
The goal is to prep the two files, blend the data to create an analytical dataset (i.e. Modeling Table) and analyze the data to gain insight into the relationships of pricing and sales. Please summarize the relationship in a comment tool.
Help on make a workflow.
