Please be creative and provide any reports, graphs, dashboards, mathematical analysis as you see necessary to provide as many interesting insights as you can discover.<\/p>\n
Here\u2019s a list of things you may consider when composing your paper:<\/p>\n
1. Covert the \u2018Date of Transaction\u2019 column in the Transaction table to the standard datetime format.<\/p>\n
2. Merge two tables into one spreadsheet. (hint: v-lookup function in excel)<\/p>\n
3. Check the distributions of each column. Clean the dataset if there is a wrong record or outlier.<\/p>\n
4. What is the revenue trend over the months of the music store?<\/p>\n
5. Is the music store getting enough visitors?<\/p>\n
6. How many of the visitors are buying?<\/p>\n
7. Are men and women different in terms of total revenue, total visits, total transactions, or the number of albums purchased?<\/p>\n
8. Are men and women different in terms of average revenue, visits, or transactions per customer?<\/p>\n
9. Are men and women different in terms of revenue and transactions each month?<\/p>\n
10. The ultimate goal of the music store is to increase sales. Do you have any marketing strategy for the music store?<\/p>\n","protected":false},"excerpt":{"rendered":"
Please be creative and provide any reports, graphs, dashboards, mathematical analysis as you see necessary to provide as many interesting insights as you can discover. Here\u2019s a list of things you may consider when composing your paper: 1. Covert the \u2018Date of Transaction\u2019 column in the Transaction table to the standard datetime format. 2. Merge […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[316],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/7827"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=7827"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/7827\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=7827"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=7827"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=7827"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=7827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}