Data Analysis in Excel: Google & Facebook Marketing Insights for Beginners to Intermediates

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/avinashlalith/merkle-sokrati-advertising-campaign/data
----------------------
🎁 Join my newsletter and get access to various freebies (Books and checklists, CV template, Portfolio Projects) - https://stan.store/KarinaDataScientist

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

🧠 AI to help you analyse your data - https://powerdrill.ai/?via=karina-samsonova

----------------------
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

🎥 Other videos you might be interested in
----------------------
https://youtu.be/uoZouXo3nGQ
----------------------

About me
----------------------
Hi, my name is Karina and I'm a finance person turned data person.

My mission is to transform intimidating tech into accessible tools. I aim to empower 1 million people to harness the power of AI, Python, SQL, and Excel to work smarter, not harder.

Contact
----------------------
Youtube: youtube comments are by far the best way to get a response from me!

email for business inquiries only: karinadatascientist@gmail.com

----------------------
Social Media:
----------------------
TikTok: https://www.tiktok.com/@karinadatascientist
Instagram: https://www.instagram.com/karinadatascientist/
Linkedin: https://www.linkedin.com/in/karina-samsonova/

#dataanalysis #exceltutorial #dataanalytics