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

Shiva Vashishtha  • Peerlist

Data Analyst at MakeMyTrip | SQL | Power BI | Tableau | MS Excel | Python | Excel | Python

Airbnb Reviews and ratings analysis The Conclusion➢ Paris has the highest instant bookable in the whole city by a Huge Margin at 64690 (23 %),followed by New York at 37012 (13 %), at bottom Hong Kong at 7087(3%)➢ From the result we can see that bedroom, review scores ratings and review scorescleanliness plays, price plays an important role in the influence of price, As we look at Paris,it has the most bedrooms with good ratings and also it has a low price on it at 113 andlowest be from Rome at 105➢ The highest booking of rooms is done around July, June &amp; October months.➢ Rome offers the best value to travel as it has the lowest price range on it only at 105 It alsohas the Best ratings with a low price on itDo you h

2 AirBNB Reviews and Ratings

Data Analyst | Python | Excel | SQL | Tableau | Power BI

<h2 class="rich-heading">Project Information</h2>Social Buzz, a rapidly growing social media and content creation platform is overcoming critical challenges. The company faces issues of managing immense data volumes, resource constraints despite its exponential growth, and the impending complexity of preparing for an Initial Public Offering (IPO). Founded in 2010 by former engineers from a prominent social media conglomerate, Social Buzz emphasizes content over individual user identity, garnering over 500 million active monthly users. With the majority of its workforce dedicated to technical operations, Social Buzz now seeks external expertise to navigate its scaling demands and ensure a successful transition to a publicly traded company.<h2 class="rich-heading">Methodology </h2>● Data sources: The primary data sources for the project are likely Social Buzz's internal databases or APIs, providing access to user engagement data and content categories. ● Data wrangling:<ol><li>Data understanding</li><li>Data cleaning</li><li>Data manipulation ● Data analysis: 1. Finding the trends and patterns ● Data visualization</li></ol><h2 class="rich-heading">Data Analysis:</h2><ol><li>Identify Unique Posts and Categories: Count the number of unique posts and categories in the dataset.</li><li>Number of Reactions for Each Category: Calculate the total number of reactions for each category.</li><li>Analyze Sentiment for Each Category: Utilize sentiment analysis techniques to determine the sentiment associated with each category.</li><li>Month with Most Posts: Identify the month with the highest number of posts.</li><li>A number of Unique Reaction Types: Count the number of unique reaction types in the dataset.</li><li>Top Content-Type: Determine the most prevalent content type among the posts.</li></ol><h2 class="rich-heading">Concussion:</h2>In summary, our analysis identified the top 5 content categories driving popularity on Social Buzz: Animals, Food, Healthy Eating, Science, and Technology. By understanding user sentiment and content preferences, Social Buzz can capitalize on these categories to enhance engagement and platform success. Implementing sentiment analysis tools and continuously monitoring content trends will be crucial for sustained growth and competitiveness in the social media landscape.

Accenture-Internship-Project

Pizza Place Sales<ol><li>An overview of pizza sales data from Jan 2015 to Dec 2015 is given in this report. To find trends and patterns in pizza sales.</li><li>According to data on monthly pizza sales, there are seasonal variations in sales, with some months having lower sales than others. The project may explore possible causes of these variations, such as seasonal factors, promotional activity, or modifications in consumer behavior.</li><li>The breakdown of pizza sales during the morning, afternoon, and evening hours is seen in the data on sales by time of day. The project could study how this breakdown differs by category and whether there are chances to boost sales at particular times of the year.</li><li>Last but not least, information on pizza sales by category offers insight on the most well-liked pizza varieties among consumers. The project might look into customer demographics, pizza preference patterns, and possible markets for fresh pizza selections.</li><li>The overall goal of the Pizza Sales Project seems to be to better understand pizza sales trends and locate chances to increase sales through the use of data analysis. The project may include suggestions for marketing and promotion plans, adjustments to the menu, or other techniques designed to boost sales and promote business expansion.</li></ol>

1 Pizza Sales Report

Hi Folks, 
I am a Data Analyst & an educator by heart. I have expertise in Excel, Python, MySQL, Tableau and Power BI.

<h3 class="rich-heading">Summary</h3>The "Cardiac Patients Medical Report Analysis" is a comprehensive study focused on gaining insights into cardiac health and efficiency, with the ultimate goal of contributing to medical knowledge, enhancing patient care, and improving outcomes for individuals at risk of heart issues. The study involved a detailed analysis of medical reports from heart patients, with the aim of identifying the most vulnerable age group, gender predisposition to heart diseases, and the impact of factors such as chest pain, fasting blood sugar, and serum cholesterol. The dataset used for the analysis was sourced from Kaggle.Source: <a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="https://www.kaggle.com/datasets/johnsmith88/heart-disease-dataset">https://www.kaggle.com/datasets/johnsmith88/heart-disease-dataset</a>

Cardiac Patients Report Analysis

Data Enthusiast || Content Coordinator @Google Developer Student Club || Learner

Problem Statement: Studios in the movie industry face challenges in achieving high Tomatometer ratings, affecting their revenue and brand reputation. This calls for a deeper understanding of factors influencing ratings, especially in the "R" rating category, to enhance movie success.Solution: Our project addresses this challenge by conducting a detailed analysis of "R" rated comedy films released from 2014 onwards. The aim is to uncover insights that can help studios optimize their content strategies and improve their movie ratings. By focusing on factors such as rating counts, certified fresh vs. rotten ratings, and studio performance, we provide actionable recommendations for enhancing performance and competitiveness in the industry.Data Sources:<ul><li>We extracted the dataset from Kaggle, provided in a tabular format as a CSV file.</li></ul><a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="http://file.Data">Data</a> Wrangling:<ul><li>Handled missing values using techniques such as mean, mode, and median imputation.</li><li>Cleaned and preprocessed the data to ensure accuracy and consistency.</li></ul><a target="_blank" rel="noopener noreferrer nofollow" class="text-green-text rich-link break-all link-break" href="http://consistency.Data">Data</a> Analysis:<ul><li>Utilized Excel for analysis, employing pivot tables, VLOOKUP, and statistical functions.</li></ul><ul><li>Explored film distribution trends, release patterns, studio ratings, critic vs. audience perceptions, and consensus language frequency.</li></ul>Goals &amp; KPIs: Goals<ol><li>Understand film distribution and trends.</li><li>Analyze new release patterns.</li><li>Compare studio ratings.</li><li>Investigate critic vs. audience perceptions.</li><li>Explore critic consensus language.</li><li>Provide actionable insights for strategy optimization.</li></ol>KPIs<ol><li>Film distribution analysis.</li><li>% of Certified Fresh and Rotten ratings.</li><li>Trends in release frequency.</li><li>Studio rating comparison.</li><li>Critic-audience rating discrepancies.</li><li>Consensus language frequency.</li></ol>Recommended Analysis:<ul><li>Explore genre distribution.</li><li>Analyze rating percentages.</li><li>Investigate release trends.</li><li>Compare studio ratings.</li><li>Examine critic-audience rating discrepancies.</li><li>Explore consensus language frequency.</li></ul>Conclusion: The analysis provides valuable insights into achieving high Tomatometer ratings for "R" rated comedy movies. By understanding factors influencing ratings and benchmarking against industry standards, studios can improve their performance and increase their chances of success in the competitive movie industry.

MOVIE RATINGS ANALYSIS

Project Coordinator at APTARA | Investment Banking | Reconciliation | Derivatives | Excel | SQL | PowerBI | MS Office

Hello Folks, I'm very excited to share my first project dedicated to Netflix Original Movies which gives a better understanding on features of successful movies that can help Netflix in planning and producing more popular and well-received content, thereby attracting a larger audience and increasing its market share in the OTT platform industry based on different attributes such as genre, runtime, IMDB score, and language.Please do share your feedback. Will be really advisable to create more exciting projects.

Netflix Orginals

Pharmacy Graduate | Aspiring Data Analyst

Churn data for a fictional Telecommunications company that provides phone and internet services to 7,043 customers in California, and includes details about customer demographics, location, services, and current status.The concept revolves around utilizing predictive analytics to anticipate and address customer churn in the telecom industry. Through advanced data analysis, patterns and factors leading to attrition are identified. Tailored retention strategies, including personalized offers and improved service quality, are then implemented to mitigate churn and cultivate customer loyalty. This comprehensive approach, coupled with a dedication to service excellence, enables telecom companies to proactively meet customer needs, resulting in reduced churn, heightened satisfaction, and enhanced market competitiveness. Overall, it offers a strategic framework for sustainable success in the dynamic telecom landscape.

TELECOM CUSTOMER CHURN

data analytic fresher

&nbsp;Delving into churn data for a hypothetical Telecommunications company catering to 7,043 customers in California, our aim is to dissect why customers are churning and craft strategies to curtail churn rates. This project is pivotal for both strategic planning to retain customers and immediate actions to address current churn issues. Acquiring specific customer insights and data is imperative to unravel churn patterns, encompassing demographics, service usage, and location. This venture holds significant potential to profoundly impact the company's financial performance and elevate customer satisfaction levels.

Telecom customer churn

Rotten Tomatoes distinguishes itself as a premier destination for accessing reviews from both everyday moviegoers and seasoned professional critics alike. Its unique feature allows users to effortlessly assess the collective opinion of audiences through the audience score, while simultaneously gaining insight into the assessments of established critics via the Tomato meter. These critics represent a diverse array of publications and groups, providing a multifaceted perspective on each film. By offering this dual evaluation system, Rotten Tomatoes empowers viewers to make well-informed decisions about their movie selections, enabling them to align their preferences with the consensus of both critics and fellow audience members. This amalgamation of professional critique and user feedback makes Rotten Tomatoes an indispensable tool for individuals seeking guidance in choosing their next cinematic experience.

Rotten tomatometer movie rating

Aspiring data analyst

"Amazon Product Review" is a comprehensive data analysis project aimed at revolutionizing the online retail experience on Amazon. Through meticulous examination of customer preferences, product performance, and market trends, we uncover invaluable insights to enhance product visibility, elevate customer satisfaction, and drive sales. Our tailored approach includes personalized marketing strategies, strategic product placements, and optimized portfolios, all geared towards fostering greater customer loyalty and maximizing profits. With a commitment to reshaping the Amazon shopping journey, our project leverages the power of data-driven strategies to empower excellence in online retail.

Amazon Product Review

Data Analyst

Analyzing Amazon product reviews involves extracting valuable insights from the vast array of feedback provided by customers on various products available on the platform. By examining factors such as product ratings, review content, user demographics, and purchase behavior, businesses can gain a deeper understanding of consumer preferences, identify emerging trends, and make data-driven decisions to optimize product offerings and enhance customer satisfaction.

AMAZON PRODUCT REVIEWS ANALYSIS

I am Akshay Sargar . I have done B.E.(Mech) from bharati vidyapeeth college of engineering Navi Mumbai .

The analysis of telecom number churn rate for Q4 2022 reveals critical insights. By examining the data, trends emerge, indicating potential causes for churn. These could include service dissatisfaction, competitive offers, or pricing issues. Understanding these trends is vital for devising effective strategies to mitigate churn. Recommendations may involve enhancing service quality, personalized offers, and targeted retention campaigns. Leveraging predictive analytics can also anticipate potential churners, enabling proactive interventions. Additionally, fostering customer engagement through loyalty programs and improving customer service can boster retention efforts. Implementing these recommendations can lead to a reduction in churn rates, ensuring sustainable growth and customer satisfaction in the telecommunications sector.

Telecom Customer Churn

A dataset with ratings and reviews for more than 15,000 Rotten Tomatoes-approved films will be examined by me. This analysis includes rating distribution, studios, release dates, genres and audience versus Tomatometer rating discrepancies. I will find patterns and insights about audience choices and critical response by using python and pandas library. The investigation will yield insights that will guide practical suggestions for filmmakers, studios and critics. This brief study will help the film business make well-informed decisions, which will improve viewer happiness and maximise critical praise for upcoming motion pictures.

Movie Ratings by Rotten Tomatoes

<h3 class="rich-heading">In our analysis we explored key factors influencing web purchases, identified the most effective marketing campaign, characterized the average customer profile, highlighted the top-performing product and pinpointed an underperforming channel. Our findings suggest actions to enhance web purchase performance and revenue generation. Recommendations include optimizing marketing strategies based on the successful campaign, refining product offerings to align with customer preferences and addressing weaknesses in underperforming channels. By implementing these actions businesses can strengthen their online presence, enhance customer engagement and drive revenue growth effectively.</h3>

Marketing Campaign Results

The pizza place has recently seen a decline in sales and is hoping to increase them by examining client behaviour and order data.Pizza sales are affected by a variety of factors, including location, brand name, marketing strategy, size, price, and taste. By examining all of this variables management aims to increase output.

Pizza place sale

Problem Statement: Maven Marketing seeks to boost campaign effectiveness and revenue generation but lacks insights into its campaign data from 2012 to 2014.Solution: We conducted a meticulous analysis of Maven Marketing's campaign data using Excel tools, discerning trends, and patterns to optimize strategies.Tools &amp; Functions Used: Excel functions, pivot tables, and charts were employed for data manipulation, visualization, and comprehensive analysis.Goals &amp; KPIs: Enhance data handling processes, maximize channel effectiveness, ensure campaign success, improve customer management, and boost product performance. Key performance indicators (KPIs) include managing null values, tracking offers, evaluating responses, and tracking product acceptance.Analysis Performed: Identified and handled null values/outliers, determined factors influencing web purchases, evaluated campaign success, described the average customer profile, analyzed channel performance.Conclusion: Our analysis provides critical insights for optimizing Maven Marketing's strategies, emphasizing data-driven decision-making for enhanced effectiveness and business growth.

Market Campaign Analysis

Deciphering the key traits of successful Netflix original movies, like genre, runtime, IMDB score, and language, is crucial. It helps Netflix create content that resonates with a wider audience, boosting its market share in the competitive OTT platform industry. Understanding what makes movies successful allows Netflix to strategically plan and produce captivating content, enhancing its presence in the streaming entertainment landscape. Ultimately, uncovering the success code of Netflix originals empowers the platform to thrive, attract more viewers, and maintain its leadership position in the industry.

Success Code of Netflix Original Movies

Data Analytics

Heart attacks are a leading cause of premature mortality globally, with India witnessing over 3 million deaths annually due to heart attacks and strokes. Numerous factors can impact heart health and efficiency. By gaining valuable insights and taking necessary precautions, we can effectively manage the challenges and complications associated with cardiac health.: In this study, we conducted a detailed analysis of medical reports from numerous heart patients. The goal was to perform exploratory analysis, uncover significant findings, and process the dataset for potential use in machine learning models. Ultimately, these models could aid in predicting the likelihood of heart attacks in new patients. By conducting this in-depth analysis, we hope to contribute to the advancement of medical knowledge, enhance patient care, and improve outcomes for individuals at risk of cardiac issues

Cardiac Patients Medical Report Analysis

The comprehensive database contains ratings and reviews for over 15,000 movies curated by Rotten Tomatoes. Each meticulously crafted record encompasses vital film details such as title, synopsis, genre, directors, cast ensemble, release date, studio affiliation, and runtime, providing users with a holistic understanding of the cinematic work. Alongside these foundational elements, the database incorporates featured reviews from esteemed critics, offering diverse perspectives on the film's merits. The inclusion of the "Tomatometer" status further aids in gauging critical consensus, indicating whether a movie has received predominantly positive or negative reviews. Additionally, audience ratings furnish insight into public reception, enriching the viewer's decision-making process. With an expansive range of films spanning various genres and eras, this repository serves as a valuable resource for cinephiles, critics, and industry professionals alike, facilitating informed discussions and explorations within the realm of cinema. Whether seeking to discover new favorites, analyze cinematic trends, or simply indulge in the art of storytelling, this vast collection promises to captivate and enrich the cinematic journey of enthusiasts worldwide.

ROTTEN TOMATOES

-- | Hey there! This is my Peerlist profile.

This report provides a comprehensive analysis of a pizza outlet's sales performance and trends over a specified period. The key objectives of the report includes: <ul><li>Analyzing the overall sales revenue, order volume, and customer trends for the pizza outlet.</li><li>Identifying the top-selling menu items, their contribution to overall sales, and any changes in customer preferences.</li><li>Examining the impact of factors such as seasonality, promotions, and competition on the outlet's sales performance.</li><li>Providing insights and recommendations to help the pizza outlet optimize its operations, marketing strategies, and menu offerings to drive increased sales and profitability.</li><li>Highlighting opportunities for growth, expansion, or diversification based on the insights gathered from the analysis.</li></ul>The report includes detailed data visualizations, such as charts and graphs, to effectively communicate the findings and support the analysis. The ultimate goal is to equip the pizza outlet's management with the necessary information to make informed decisions and implement strategies to enhance the business's overall performance.