Question:

Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume.

This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.

Overview of essay:

The NBA Top Shots moments have been categorized with play types on NBA games. The impact of these play types on sales has been studied based on these metrics:

• Sale volume and count
• Distinct buyers and sellers
• Average purchased price by buyers
• Use buckets based on sale price and grouped the purchasers by play types
• Whales tendency on play types
• Hold duration for play types

Approach:

• Play types

  PLAY_TYPE from flow.core.fact_nft_sales x left outer join flow.core.dim_topshot_metadata y on x.NFT_ID=y.NFT_ID where TX_SUCCEEDED='TRUE' and x.NFT_COLLECTION='A.0b2a3299cc857e29.TopShot' and x.CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'

• Buckets of sales by price

  CASE WHEN PRICE <= 10 THEN 'a.below 10' WHEN PRICE > 10 and PRICE <=50 THEN 'b.10-50' WHEN PRICE > 50 and PRICE <=200 THEN 'c.50-200' WHEN PRICE > 200 and PRICE <=1000 THEN 'e.200-1000' WHEN PRICE > 1000 THEN 'f.above 1000’

• Whales

  Buyers with average price over 1000 USD as whales

• Hold duration

  Find time duration by DATEDIFF(day,x1, x2 ) for buy and sell time of each NFT_IDs

Sale analysis of play types:

Key findings 1:

1. The overall sale volume for play types reveals the highest sale in total belongs to Rim plays with near 3 million sale volume. The 3 pointer is the second most sale play type on NBA Top Shots with 1.7 million USD.
2. About 41% of sales count belong to the Rim play type and its the highest play type in sale count aspect.
3. The average purchased USD per buyer shown in scatter plot and reveals the value of Rim play types by 170 USD as average purchased value per buyer.
4. The sale volume and count of play types on NBA Top Shots validated the comments on previous statements and shown the domination of Rim and 3 pointer.
5. One of the most used graph to evaluate the value of play types is cumulative sale volume over time and according to this graph, the Rim, 3 pointer and Assist have most promising movements.
6. The buckets introduced based on sale price. After that the share of sale count based on play types demonstrated in each bucket. As illustrated in this graph, the share of 3 pointer plays has been increased by increasing the sale price.
7. The play types that is popular among whales is 3 pointer with 30% of sales among whales. The Assist is the second most used play type between whales and the Rim got the third place and popularity among whales.
8. The play types have been illustrated based on hold duration on scatter plot and displays the high duration time for 2 pointer and the main reason of that is because of low sales on this type on NBA Top Shots.