Super Rating is an Australian-based food product review company. The founder is Mr. Roman King. The goal of setting up the review platform is to compare suppliers who provide or manufacture the same product but have been unable to win the interest of consumers. In May, the chief executive officer (CEO) of Oishii Ramen, Mr. Takashi Hajita, said he wanted to launch a new yet similar brand of ramen in the food market. However, he is very concerned about whether consumers will accept the new ramen recipe and brand. He needs insight data from Super Rating to update him so that he can engage in strategic decision-making. In fact, Mr. Hajita is aware of other ramen brands, including Azami, Western Family, Urban Noodle, Koyo, Master Kong, Maggi, Nissin, etc. Some of the brands have received good reviews, whereas others have failed to obtain good reviews from customers. Data analytics is essential for guiding Mr. Hajita to make a good decision based on the following: 1. Which are the most popular types of ramen, and why do people like them? 2. What factors must be taken into consideration to establish a new ramen recipe? 3. How does culture play a role in food products? You have been working for the company Super Rating as a data analyst for six months, and Mr. King wants you to write and submit a report to him based on the following criteria: 1. From the spreadsheet, briefly discuss the product reviews and explaining how you can interpret each product review correctly. Do the reviews on the spreadsheet suffice enough to help you to analyse ramen’s sales performance objectively at the country level? If yes, please explain. (2 marks) 2. The CEO OF Oishii Ramen would like to know if the ramen packaging style contributes to influencing consumers’ purchasing power? Does culture play a significant role in terms of packaging style? Justify your findings by showing two dashboards and explaining your rationale. (3 marks) 3. In what way can Oishii Ramen’s headquarters use the rating and which rating is the most appropriate for them ? (2 marks) 4. Suggest a technique that you can use to demonstrate to the CEO the popularity of ramen in the country, and justify and show your method with evidence. (3 marks) 4 5. How reliable is the ramen ranking to the CEO if it is chosen to review the business’s sales performance or growth? (2 marks) 6. During the investigation, you want to propose some brands to discontinue. Which ramen brands would you suggest for discontinuation? Justify your answer. (4 marks) 7. Compare the reviews of ramen in Japan and Korea. Are there any similar reviews? If so, prove it. (4 marks) 8. Do Asia, Australia, and America have foods that taste similar to ramen? (2 marks) 9. If the new CEO would like to introduce a new ramen recipe in the Nepal and India markets, what recommendations would you make to him? (4marks) 10. Show three dashboards: 1. Which country has the most reviews? 2. Which country has the fewest reviews? 3. Which consumer ratings did consumers click that apply to all countries? (2 marks) 11. Due to the limited data on the review spreadsheets, what other fields would you recommend adding to the spreadsheet to provide more precise information to Mr. Hajita to help him to find out about ramen’s poor review? And what sort of data or information do you think Mr. Hajita must know before he executes his strategic plan to discontinue an old ramen product and launch a new ramen product? Justify which countries need a new ramen flavour launch? (2 marks)