Data Analysis Report for Fond Rouge

[Audio] Good afternoon everyone. We are here to discuss Fond Rouge's data and its insights related to revenue loss, sentiment classification, counterfeiting, and overall performance in American locations. To begin, let's take a look at who we are dealing with, starting with the problem..

[Audio] An illustration demonstrates the data input and output of the Fond Rouge analytics model. It displays how the model is given customer, location and revenue data to provide insights relevant to the queries. The findings from the analysis can be then used to spot areas for improvement and suggest tactics to tackle issues such as counterfeit, revenue loss, and customer sentiment..

[Audio] The slide outlines the aim, information, and analysis focuses to be addressed in this presentation. The aim is to analyze the data of Fond Rouge using SAP Analytics Cloud, which includes information about sales, returns, sentiment classification and location. The analysis focuses will be on identifying key insights and addressing specific questions related to revenue loss, sentiment classification, counterfeiting, and overall performance in American locations. Agenda for this presentation is in the following slides..

[Audio] We leveraged the capabilities of SAP Analytics Cloud to explore and visualize the data, apply calculations and formulas, and use its advanced analytical capabilities to derive meaningful insights from the data. This software is designed for data analysis, visualization, and reporting, providing a user-friendly interface and powerful capabilities..

[Audio] Fond Rouge experiences the greatest loss of revenue due to returns in San Diego, with a ratio of refunds to revenue of 54%, which is significantly higher compared to other cities..

[Audio] Analysis of Fond Rouge data using SAP AnalyticsCloud reveals that 21.39% of all sales in the US had Negative reviews. This indicates that a significant proportion of sales in the US were not highly rated by customers. Having this knowledge can help uncover the reasons for revenue loss in the US..

[Audio] When we looked at the global sales made with Fond Rouge, we found that only 2.52% of those sales had negative reviews. This suggests that a very small proportion of all sales had negative reviews. But what is the percentage of negative classifiers, globally?.

[Audio] We have identified Los Angeles and Las Vegas in the US with a low sentiment score of under 65% and returns lower than 20%. Our analysis indicates that these could be potential locations for counterfeiting..

[Audio] The data that we have analyzed indicates that Fond Rouge does not have a problem throughout all of its American locations. Our findings show that an unusual refund ratio of 54.37% is only observed in San Diego. This suggests that the other locations such as Los Angeles and Las Vegas might be hinting towards high counterfeiting. To further understand the situation, we need to look into the data more deeply for other key insights..

[Audio] The analysis of Fond Rouge data using SAP Analytics Cloud reveals that there are two cities in the United States, Los Angeles and Los Vegas, which have a return rate of below 20%, but an average sentiment score of lower than 65. This suggests that counterfeiting is an issue in these areas, and should be further investigated..

[Audio] "The analysis of Fond Rouge data with SAP Analytics Cloud allowed us to gain incisive understanding into the causes of revenue loss, customer sentiment and potential counterfeit stocking issues. These insights offer clear direction for Fond Rouge on how to deliver better customer satisfaction, streamline operations and create preventative strategies to mitigate problems in individual locations. This has enabled Fond Rouge to take meaningful actions to achieve their goals and ambitions..

[Audio] Ending the presentation, the contact information of our Data Analyst Intern, Darshan, is provided for the time and consideration..