Kaggle Dataset Competition Tutorial using Excel for Beginners

In this video we tackle a dataset in Kaggle using Excel utilising feature engineering to create new custom fields that can help in answering business questions. Data set / data file can be accessed here: https://www.kaggle.com/datasets/shilongzhuang/pizza-sales Video Guide 00:00 Intro to Kaggle.com 00:58 Pizza data set 04:14 Question 1 - Most popular day of the week / time of the day 16:41 Question 2 - Peak periods 20:07 Question 3 - What are the best and worst selling pizzas 22:41 Question 4 - What is the average order value?2 25:36 Closing thoughts About me and my channel (My name is Sid, I am currently a Lead Data Analyst (VP level) at a Global Investment Bank based in London, UK and I have been working in Data Analytics for over 7 years. Follow me for more Data related content.) Some of my other popular videos: Kaggle dataset analysis using Jobs data: https://youtu.be/TDpX8o6YplU How to become a Data Analyst in 2024: https://www.youtube.com/watch?v=M-_nODeA8Qw&t=35s 5 Common Data Analysis Mistakes (and How To Avoid Them!): https://www.youtube.com/watch?v=_iB9161ZQwA Interviews I did in the last few years: HSBC Bank: https://www.youtube.com/watch?v=Q9u1ePOE9-8 FAB Bank: https://www.youtube.com/watch?v=R52ccyoAg_U&t=871s JPMorgan Chase: https://www.youtube.com/watch?v=x5KrfIZA5Pk Follow me on social media here: LinkedIn: https://www.linkedin.com/in/sid-skills/