Kaggle Dataset Tutorial for Beginners with Excel 📊

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/