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

🎁 Access freebies at https://stan.store/KarinaDataScientist

⚡️MASTERCLASS - "Data Analysis with Python Masterclass" - https://stan.store/KarinaDataScientist⚡️

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