Data Analysis Project in Excel (Beginner to Intermediate)

In this video we will analyse Google and Facebook Marketing data using Excel. We will create pivot tables, different types of charts and make a dashboard.
Dataset can be found here - www.kaggle.com/datasets/avina...
⚡️MASTERCLASS - "Data Analysis with Python Masterclass" - karinadatascientist.com/ ⚡️
Timestamps:
00:00 Intro
01:28 Dataset
03:27 Filter dataset
04:54 Marketing Metrics
06:50 Pivot table
08:27 Calculated Field in Pivot
12:20 Duplicate Tab
13:40 Bar Chart
16:04 Pie chart
17:33 Line graph
22:00 Dashboard layout
25:37 Group data in Pivot
27:52 Final Dashboard
29:55 Add text card to a chart
31:20 Recommendations and conclusion
Social Media:
TikTok: / karinadatascientist
Instagram: / karinadatascientist
Linkedin: / karina-samsonova

[@khushboomehta8611]

Amazing ❤, one suggestion i would like to add. Can you please provide the analysis that we got by creating the graphs. So that can help us as a beginner how to analyse the data and what can be done to improve the businesss. Really liked the video. I will definitely replicate this one

[@karinadatascientist]

Sure, very good idea

[@abhijith.p8982]

u r a legend , what a mind blowing video..

[@karinadatascientist]

What a cool comment. Thank you!

[@ohhjepoy]

hi, do you have video about story telling your visualized data?

[@karinadatascientist]

No, I don't. But it is a great idea for a video. Thank you

[@ohhjepoy]

@@karinadatascientist thanks karina ♥️

[@ansilaameer606]

Is this project possible to do in excel 2013 version

[@karinadatascientist]

Of course. Interface is probably different, so some buttons might be located in a different spot