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