The Chinook store is set up in a way that allows customer to make purchases in one of the two ways: ● purchase a whole album ● purchase a collection of one or more individual tracks. The store does not let customers purchase a whole album, and then add individual tracks to that same purchase (unless they do that by choosing each track manually). When customers purchase albums, they are charged the same price as if they had purchased each of those tracks separately. Management are currently considering changing their purchasing strategy to save money. The strategy they are considering is to purchase only the most popular tracks from each album from record companies, instead of purchasing every track from an album. We have been asked to find out what percentage of purchases are individual tracks vs whole albums, so that management can use this data to understand the effect this decision might have on overall revenue. Task 3 1. Write a query that categorizes each invoice as either an album purchase or not, and calculates the following summary Statistics: • Number of invoices • Percentage of invoices

An Analysis of Purchase Patterns in the Chinook Store

The Chinook store offers customers the flexibility to make purchases in two ways: either by buying a whole album or purchasing a collection of individual tracks. However, the store does not allow customers to initially purchase whole albums and subsequently add individual tracks to the same purchase, unless they manually select each track. Management is now contemplating changing their purchasing strategy to optimize cost savings. Specifically, they are considering only buying the most popular tracks from each album rather than purchasing every track from an album. To assess the potential impact on overall revenue, it is crucial to determine the percentage of purchases that are individual tracks versus whole albums. This analysis aims to achieve this objective by categorizing each invoice as either an album purchase or not and calculating the relevant summary statistics.

To categorize each invoice as either an album purchase or not, a SQL query will be designed. The query will utilize the Chinook store’s database, which contains information about each purchase, including the tracks, invoices, and albums. By analyzing this data, we can determine which purchases consist solely of albums and which comprise individual tracks.

To calculate the relevant summary statistics, we will consider two key measures: the number of invoices and the percentage of invoices.

The query will provide the following summary statistics:
1. Number of Invoices: This will indicate the total count of invoices in the Chinook store’s database. By identifying the total number of invoices, management can gain an understanding of the size of the customer base and the overall sample size for the analysis.

2. Percentage of Invoices: This value will represent the proportion of invoices that are classified as album purchases. By dividing the number of album purchases by the total number of invoices and multiplying by 100, we can calculate the percentage. This measure will offer valuable insights into customer preferences and buying behavior.

By obtaining the summary statistics of the percentage of album purchases, management can assess the potential impact of the proposed purchasing strategy. If the percentage is found to be high, implying that a substantial portion of purchases are albums, then the decision to purchase only popular tracks may result in cost savings. However, if the percentage is low, suggesting that individual track purchases dominate, the cost savings from buying only popular tracks may be minimal.

In conclusion, this analysis aims to categorize purchases as either albums or individual tracks and calculate relevant summary statistics to determine the percentage of album purchases. This information will aid management in evaluating the potential impact of their purchasing strategy on overall revenue. By understanding customer preferences, Chinook store management can make informed decisions to optimize their procurement process.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.

Click Here to Make an Order Click Here to Hire a Writer