Reference no: EM133446871

Question

PART A

You have been provided with a data set which includes details of clients of a doctor's clinic. As you review the data set, you note that the information provided is: name, date of birth, street, city, postcode, mobile phone number, current age, date of last visit. As you review the data you realise there are some issues with the quality of the data as follows: The current age is missing for some clients The postcode is missing for some clients For each of the above issues, how would you deal with each issue while undertaking the data cleaning process?

PART B

Your client, an e-commerce business, Electric Retailers (ER) sells accessories for electric scooters, electric bikes and mobility scooters. ER sells exclusively online via eBay, Shopify, Amazon, Facebook and Instagram and has quickly built their business over two years since opening to a turnover of $750,000 in its second year. ER has asked you to assist them in analysing their sales channels and the sales of each individual stock item on those sales channels to determine if they should continue to sell all products on all sales channels or should they be more targeted.