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 https://www.kaggle.com/datasets/avina...

⚡MASTERCLASS "Data Analysis with Python Masterclass" https://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:   / karinasamsonova