Detecting Online Payment Fraud Using Machine Learning Models Lecturer: Dr. Ang Group 9 | Matric | Full Name | |-------------|----------------| | 23121328 | Mohammed Iqram | | 24052516 | LI JUNMING | | 22106713 | LI YUEXIN | | 23108677 | ZHAO ZITONG | | 23111676 | LIU YICONG |

This project is a practice of exploratory data analysis on White-tailed deer Illumina short reads (ID: PRJNA984950). The SARS-CoV-2 SNP variants found within different populations of White-tailed deer across the United States were called using sastQC, trimmomatic, BWA, and vcftools. My goal was to find what significance location had to SARS-CoV-2 variants through finding distribution of samples collected and seeing whether certain genes had more SNPs in certain states. I was also interested in if statewide SNP trends coincided with SNP trends in North Carolina and Massachusetts, two states where White-tailed deer may be a potential resevoir for SARS-Cov-2.

Basic of R

During the 6 day festival, Walmart increased its revenue by 155M Rupees as well as sold 435K additional products. analytical insights of promotional offers We found that out of all the promotional offers, items sold under BOGOF were seen to be the most successful as through BOGOF the festival saw 157,073 more units sold. Right next to this is the 500 Cash back promo which saw an extra 40,881 units sold. Whereas, items sold during this festival with the 25% off promotion performed the worse as it sold 5,717 fewer units than were sold without the promotion The BOGOF promotional offer generated an additional revenue of 69.3M as compared to pre-festival. Meanwhile, the 500 Cashback promo brought in 91M in extra revenue as compared to pre-festival. This means that although the 500 Cash back offer sold fewer units than the BOGOF offer we see that in the end it was still able to acquire a higher amount of extra revenue throughout this period. The primary reason for this is that the items applied to the 500 Cashback promo were far more expensive than those under BOGOF (i.e. furniture sets). The BOGOF promotional offer lead to an increase in revenue growth by 304% ⬆️and 500 $ CashBack offer by 139%⬆️. In contrast, the promotional offers of 33% off, 50% off, 25% off offer lead to a negative growth of 5% ⬇️, 39%⬇️ and 42%⬇️. we also observed the BOGOF offer to be the one that sold the most additional units and highest revenue growth. The 500$ Cashback offer also performed quite well. However, the discount offers such as 25% off, 33% off, 50% offer have shown negative revenue growth. Moreover, it appears that such discounts also failed to aid the company in being able sell a substantial number of units. Therefore, in the next festival we should only focus on utilizing the BOGOF and 500 Cashback promo and with that completely exclude the 50%, 33% and 25% off promotional offers. <br> Analysis insights of each campaign. Overall, products of the Grocery and Staples category sold the most while personal care products sold the least amount of units. This means there’s far more demand for Grocery and Staples category products. Throughout the Diwali festival we found that home appliances, home essential combo and home care products had on average sold an additional 30K units compared to pre-festival. In Sankranti, Grocery and Staples category products got sold by 109K more units as compared to pre-festival period. We can conclude from the above two insights that in Diwali people prefer to buy home essentials while in Sankranti they majorly buy items that is used in making staple food. This could be because, people know that there are high discounts on many products in the times of a big festival like Diwali. Moreover, many people also wait for Diwali to come so that they can buy what they need on discounts. And since, Sankranti is only of 1 day i.e 14 January, people majorly choose to buy daily staple food items as they pre-assume that they aren’t going to get good discounts on house items on such festival. On Sankranti, we generated extra 66 M $ and 334 K more quantities were sold as compared to pre-festival period. On Diwali, we generated extra 88M $ and 108K more quantities were sold as compared to pre-festival period. From the above two insights we can conclude that the majority of items sold in Diwali were far more expensive as compared to the majority of items sold in Sankranti . This is certain as in Diwali majority of items that got sold were Home essentials and in Sankranti, majority of items that got sold were staple food items. So, it’s recommended that in Diwali we should provide discounts on home essentials and in Sankranti we provide discounts on staple food items. Analysis insights for Stores and Cities Overall, top 4 stores in revenue generation are from Mystore(1), Chennai(2) and Bangalore(1) . In this stores we have seen maximum revenue growth in times of festival season. On an average we generated 4.5 M extra revenue and seen an average revenue growth of around 100% as compared to pre-festival time. Stores that are in Coimbatore have also shown 100% revenue growth, but the extra revenue generated from it was slightly less and was around 3.2M $ Similarly, we have seen a growth of whopping 260% on an average in quantities sold in times of festival season as compared to pre-festival times. On an average 12K more product quantities were sold from top 4 stores as compared to pre-festival days. Among all the cities in festival season, in Bangalore largest number of extra products were sold i.e around 108K in comparison to pre-festival times. On the other hand, in Trivandrum least number of extra products were sold i.e around 10K in comparison to other cities. Across all cities(including Trivandrum) on an average there was 200% rise in quantity sold in festival season. Among all the cities in festival season, in Bangalore we saw that largest amount of extra revenue was generated i.e around 38 M in comparison to pre-festival times. On the other hand, in Trivandrum least amount of extra revenue was generated i.e around 3M in comparison to other cities. Across all cities(including Trivandrum) on an average there was 80% revenue growth as compared to pre-festival season. RECOMMENDATIONS I will provide some recommendations based on the insights that I found previously while analyzing data. BOGOF and 500$ CashBack offer helped us in generating extra revenue as well as in selling huge amount of extra quantities as compared to pre-festival times. Thus, we should continue this offers in next festival season. On the other hand discount offers such as 25% off, 33% off and 55% off should be discontinued for the products on which we made this offer available in Sankranti and Diwali. This is because, all this offers lead to negative revenue growth as well as the fact these offers actually did more to hinder the company from being able to significantly sell more products than what normally would be expected during pre-festival times. We must ensure that in Diwali we provide discounts on home essentials and in Sankranti we provide discounts on staple food items.