Question 1

You are to analyze a dataset Campaign for this assignment. Research on customer behavior allows businesses to better understand their customers’ preferences. It also helps businesses to adapt their products to suit different consumers’ preferences, behaviors, and concerns. This fictitious dataset contains data on consumer demographics, product purchases, marketing tactics, and purchase channels. All data fields are described under the Glossary tab.

Question 2

Create a summary of the dataset in tabular format. It should identify the data type of each data field and summary measures. You should use Excel to perform the necessary data exploration steps, data cleaning for any data issues identified, and data transformation if applicable before creating the summary table. Illustrate your data exploration, cleaning, and transformation steps with screenshots and excel formula(s) if applicable.