Chat with us, powered by LiveChat Use business knowledge, data analytics method, and data visualization skills to analyze the sales data from a music store. You can use any statistical tools you like, e.g. - Writeedu

## 04 Mar Use business knowledge, data analytics method, and data visualization skills to analyze the sales data from a music store. You can use any statistical tools you like, e.g.

Use business knowledge, data analytics method, and data visualization skills to analyze the sales data from a music store. You can use any statistical tools you like, e.g. Excel, Python, R.

Dataset
The dataset records the sales revenue of a music store from January 1997 to June 1998. The dataset has two tables: Transactions and Demographics.

Transactions Table
Explanation of columns:
Customer ID: the unique ID of each customer.
Date of Transaction: the date that the customer purchased the album.
# of Albums: the number of albums that the customer purchased.
\$ Sales Revenue: the revenue of each transaction.

Demographics Table
Explanation of columns:
Customer ID: the unique ID of each customer.
Gender: gender information of each customer.
Total Visits: the total number of visits of each customer to the music store.

Requirements:

Please be creative and provide any writeups with graphs, dashboards, mathematical analysis as you see necessary to provide as many interesting insights as you can discover.

Here’s a list of things you may consider when composing your writeup:

1. Covert the ‘Date of Transaction’ column in the Transaction table to the standard datetime format.

2. Merge two tables into one spreadsheet. (hint: v-lookup function in excel)

3. Check the distributions of each column. Clean the dataset if there is a wrong record or outlier.

4. What is the revenue trend over the months of the music store?

5. Is the music store getting enough visitors?

6. How many of the visitors are buying?

7. Are men and women different in terms of total revenue, total visits, total transactions, or the number of albums purchased?

8. Are men and women different in terms of average revenue, visits, or transactions per customer?

9. Are men and women different in terms of revenue and transactions each month?

10. The ultimate goal of the music store is to increase sales. Do you have any marketing strategy for the music store?

11. Provide the finished dataset with your analytic results as the attachment in addition to the written assignment.

Submitting requirement:

The cover page and reference page/s are not included in the above-stated page requirement. These should be in addition to page requirements.

Format in proper APA 7th Edition style.

A minimum of three outside peer-reviewed sources for your references

## Transactions

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

Do you need help with this question?

Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.

WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.

With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Chat with us today! We are always waiting to answer all your questions.

 Customer ID Date of Transaction # of Albums \$ Sales Revenue 1 19970101 1 11.77 2 19970112 1 12 2 19970112 5 77 3 19970102 2 20.76 3 19970330 2 20.76 3 19970402 2 19.54 3 19971115 5 57.45 3 19971125 4 20.96 3 19980528 1 16.99 4 19970101 2 29.33 4 19970118 2 29.73 4 19970802 1 14.96 4 19971212 2 26.48 5 19970101 2 29.33 5 19970114 1 13.97 5 19970204 3 38.9 5 19970411 3 45.55 5 19970531 3 38.71 5 19970616 2 26.14 5 19970722 2 28.14 5 19970915 3 40.47 5 19971208 4 46.46 5 19971212 3 40.47 5 19980103 3 37.47 6 19970101 1 20.99 7 19970101 2 28.74 7 19971011 7 97.43 7 19980322 9 138.5 8 19970101 1 9.77 8 19970213 1 13.97 8 19970617 3 45.29 8 19970703 2 36.76 8 19971116 1 2.99 8 19971116 7 50.43 8 19971225 1 13.99 8 19980329 2 24.46 9 19970101 2 23.54 9 19970513 2 30.33 9 19980608 2 41.98 10 19970121 3 39.31 11 19970101 1 13.49 11 19970128 1 19.3 11 19970317 1 12.77 11 19980220 1 12.99 12 19970101 4 57.06 13 19970101 4 72.94 14 19970101 2 29.92 15 19970101 4 52.87 16 19970101 1 9.77 16 19970713 2 31.6 16 19970726 4 28.51 16 19970910 1 9.99 17 19970101 5 73.22 18 19970104 1 14.96 19 19970101 10 163.35 19 19970610 1 11.77 20 19970101 27 363.6 20 19970118 19 289.41 21 19970101 3 63.34 21 19970113 1 11.77 22 19970101 1 14.37 23 19970101 2 24.74 24 19970101 3 47.28 24 19980120 1 10.49 25 19970101 2 24.96 25 19970718 1 13.9 25 19970817 1 12.25 25 19971024 1 12.99 25 19980417 1 12.99 25 19980525 1 10.49 25 19980603 3 24.97 25 19980608 2 24.98 26 19970101 3 42.72 26 19970126 3 59.97 27 19970107 6 83.41 27 19970112 4 52.46 28 19970101 3 39.51 28 19970127 2 25.74 28 19970308 2 25.74 29 19970101 3 46.72 29 19970206 3 67.31 29 19970309 3 999999 29 19970405 3 44.52 29 19970420 1 13.97 29 19970504 2 26.14 29 19970530 1 32.45 29 19970713 2 37.65 29 19970713 2 26.74 29 19970906 1 14.79 29 19971102 3 35.97 29 19980426 4 48.45 30 19970101 1 14.37 30 19970214 1 13.97 31 19970101 4 59.06 31 19980407 4 42.89 31 19980409 3 38.06 31 19980525 3 37.04 32 19970101 3 49.97 32 19970124 2 16.36 32 19980311 1 11.88 33 19970101 3 41.69 33 19970121 2 29.92 33 19970216 5 73.42 33 19970502 2 40.74 33 19970514 3 54.25 33 19970601 1 14.96 33 19970604 2 30.13 33 19970829 35.69 33 19970906 1 11.77 33 19971002 3 45.47 33 19971003 2 34.98 33 19971005 3 54.97 33 19971013 5 69.45 33 19971019 3 48.97 33 19971031 4 54.46 33 19971106 5 66.45 33 19971109 3 67.47 33 19971110 1 13.99 33 19971118 20 14.49 33 19971123 4 55.96 33 19971125 3 36.97 33 19980113 3 36.97 33 19980227 3 34.47 33 19980305 4 35.35 33 19980313 2 42.48 34 19970101 2 23.14 35 19970101 3 26.73 35 19970927 1 15.49 36 19970101 3 37.91 36 19970203 1 11.77 37 19970129 2 31.26 37 19970306 2 29.13 37 19970628 1 13.97 37 19970816 1 14.37 37 19971102 3 39.47 37 19980513 2 27.48 38 19970101 1 12.49 39 19970101 3 33.33 39 19970313 4 50.68 39 19970514 2 28.93 39 19980305 4 49.55 39 19980311 2 58.96 40 19970101 2 28.34 40 19970308 1 13.97 40 19970503 1 15.96 40 19970830 1 14.96 40 19970914 3 44.47 40 19970914 1 13.99 40 19970914 1 22.99 40 19971025 2 25.98 40 19971213 1 16.99 40 19971214 4 54.96 40 19980215 1 12.58 40 19980215 1 2.99 40 19980225 3 36.34 40 19980308 1 14.42