Data Preparation Project Problem Statement: Dynamic Brands has been hired by General Mills to analyze their cereals against their competitors in terms of nutritional value, and likability. They have done research on the cereals and have conducted a survey on how individuals like the cereals. You are tasked with collecting the data and creating a single data set that you can analyze to help make some insights regarding the cereals and consumers. ou will be using the Tableau Data Prep tool to do so. The data you have: 1. Information about the cereals (cereals.csv) 2. Individual participant results of the survey (survey.xls) Attributes in the Cereal dataset... name: name of cereal mfr: name of the manufacturer of the cereal, values are: A = American Home Food Products G = General Mills K = Kelloggs N = Nabisco P = Post Q = Quaker Oats R = Ralston Purina typ: value is C or H for hot or cold cal: calories per serving protein: grams of protein fat: grams of fat sod: milligrams of sodium fiber: grams of dietary fiber carbo: grams of complex carbohydrates sugars: grams of sugars potass: milligrams of potassium wght: number of ounces in one serving cups: number of cups in one serving Attributes in the Survey dataset... Cereal: name of the cereal Name: name of the person, first followed by the last State: name of the state where the person lives Date: date the survey was conducted (4/11/2019 to 6/30/2019) Like: 1 (low) to 10 (high) What you need to do: 1. Rename the attributes so they are meaningful to you 2. Enhance the manufacture and cereal type coding to use their full names 3. In the Survey data set, break out the persons name into two attributes (first name & last name)

4. Clean each data set to arrive at a high quality (trustworthy) data set 5. Join the data sets together into a single data set (Excel) 6. Bring the data set into Tableau and create a simple visualization highlighting a certain aspect of the data