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.

Question 3

Employ visualization techniques and create one (1) dashboard that includes at least three (3) professional graphical charts that provide helpful information about the dataset. Produce the charts and the dashboard using Power BI. Provide a screenshot of each produced graph and the dashboard. Use up to 200 words to explain how the chart and dashboard are produced and how the dashboard generates and communicates the insights.

Question 4

Develop a proposal for a business analytics solution to address the problem identified in Question 1. It should contain a discussion of the appropriateness of two (2) business analytics techniques to use, including one (1) spreadsheet analysis and one (1) data mining technique, and explain how various steps
of the business, analytics processes are applied in this business analytics
initiative.