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:
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/
Видео Kaggle Dataset Competition Tutorial using Excel for Beginners канала Skills With Sid
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:
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/
Видео Kaggle Dataset Competition Tutorial using Excel for Beginners канала Skills With Sid
kaggle beginners how to use kaggle kaggle walkthrough kaggle competition why use kaggle kaggle tutorial for beginners kaggle competitions for beginners learn kaggle kaggle explained kaggle projects kaggle data science kaggle for beginners kaggle projects for beginners kaggle titanic python kaggle titanic solution how to use kaggle notebook kaggle submission tutorial kaggle competition solution how to use kaggle for beginners kaggle competition submission
Комментарии отсутствуют
Информация о видео
10 января 2024 г. 5:04:32
00:26:51
Другие видео канала
Switching from Teaching to Data Analytics?
Company Profile Data - Companies House API
Prepare your CV for Data Analyst roles - tips and strategies
Query APIs using Python (Part 2) - Nested JSON to Dataframe to Excel
Create a GITHUB profile EASILY
Overview of Tableau + Superstore sample data set (2022)
Introduction to Alteryx for Data Analysts in 2022
How To Build Awesome Interactive Dashboards In Excel Using Pivotcharts And Slicers
How to use Vlookup in Excel (with download file)
Data Analytics within Banking - Explained
Learn Python Basics - List and List Methods
Deepseek - AI Disruption - What is going on and whats next?
5 Common Data Analyst Mistakes (and How To Avoid Them!)
Inspecting Dataframes in Pandas - Python
Using Averages in Excel #microsoftexcel
Installing and Setting up Python
Python for Beginner Data Analysts (Part 1 - Data Types)
What is SQL? Explained for Data Analysts (2024 edition)
Excel Data Analysis - Using a Helper Key to compare Data in Excel
3 Stages of Dashboard deployment
How to do a Vlookup in Python using df.merge to join data
