MBA HR graduate || HR recruitment  || HR operations || actively seeking opportunities

Ashwin Kaur  • Peerlist

Data Analytics professional at Schenider Electric having 2+ years of experience with Excel,SQL, Python,Tableau

<ul><li>From the result we can see that Bedrooms, review scores ratings,</li></ul>Review scores cleanliness, price plays an important role for the influence on the price.<ul><li>Paris have the most bedrooms with good ratings and also it has low</li></ul>price at 113.<ul><li>Highest bookings of rooms is done around in the month of July, June</li></ul>and October months.<ul><li>Rome offer the best value to travel as it has the lowest price range at</li></ul>105. It also have the best ratings with a low price on it.

AIRBNB LISTINGS AND REVIEWS

The pizza restaurant is facing declining sales and plans to analyze customer and order data from 2015 to identify trends and improvement areas. By conducting thorough data analysis using Excel, including creating dynamic dashboards, the restaurant aims to uncover factors contributing to the sales drop and implement targeted strategies, such as promotions for weekdays and menu optimization. Engaging staff for insights and analyzing customer feedback will further enhance understanding of customer preferences. The goal is to increase sales by 10% within six months while improving customer satisfaction and loyalty.

PIZZA PLACE SALES ANALYSIS

This report analyzes over 15,000 movies from Rotten Tomatoes, showing that comedy is the most popular genre, with 3,540 ratings. In 2014, the highest number of releases occurred, especially in October, which had 85 new films.There are differences between critic and audience ratings. Sony Pictures Home Entertainment has the lowest ratings (0 to 9), while Paramount Pictures scores better overall. Positive comments account for 62% of 8,309 critic reviews.Recommendations include focusing on comedies, especially in October, and considering both critic and audience feedback. Sony Pictures should improve its quality to boost ratings. These insights can help the film industry meet viewer expectations and increase box office success.

Rotten Tomatometer Movie Rating

This project focuses on enhancing web purchases for a company by analysing key factors that influence online buying behaviour. We identified that customers born between 1963 and 1982, particularly those with graduate degrees and annual incomes between 41,000 and 82,000, are the primary online shoppers. The "Last Campaign" was the most successful marketing initiative, with "Wines" being the best-selling product. However, web purchases were underperforming overall. To improve sales, we recommend enhancing the user experience with a more intuitive website and mobile optimisation, boosting online visibility through SEO and SEM, personalising marketing efforts with tailored recommendations and targeted emails, leveraging social media for promotion, and ensuring secure payment options to build customer trust. By implementing these strategies, the company can improve online sales performance and achieve sustainable growth.