The three links below are to database files containing fictional information about a non$-$profit organization. The first sheet is a list of supporters $($called Members$)$ and includes assigned member ID number and some demographic information about each of them. The second sheet, "Donation Database" is a list of donations for the year $2023.$ The third sheet, Regional List, is a list of regions and the states$/$territories assigned to each region. Using Power BI$,$ complete the following:

Data Preparation

Remove any duplicate records from the "Member Database" $(5$ points$)$

Separate the City, State, Zip column into three separate columns $-$ City, State, and Zip. $(2$ points$)$

Make sure all fields are formatted the same on both sheets. $(5$ points$)$

Clean up any errors in the data $-($e$.$g$.$ imputing missing data including City$)(13$ points$)$

Combine the three databases into one database. $(5$ points$)$

Create dummy variable$($s$)$ for the gender and an interaction term combining gender and donation total amount. $(5$ points$)$

Create four different summaries of the data, one for each of the following: $(10$ points$)$

Member Relationship Manager

Donations Manager

Regional Manager

Chief Marketing Officer

Complete a write$-$up: $(10$ points$)$

Interpret the summaries and provide insights as well as recommendations based on summaries.

Explain the different focus of each summary based on the intended audience.