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. | Wridemy

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?

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Related Tags

Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA

 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