Data Analytics for Brand and Marketing Communication with Excel and Power BI - Session 3

Data Analytics Class: Advanced Excel Formulas & Intro to Power BI Data Pipelines In this interactive, hands-on data analytics session, we dive deep into mastering complex Excel formulas and exploring the foundations of data transformation using Power BI's Power Query editor. What You’ll Learn in This Session: Advanced Excel Formula Workarounds: Learn how to calculate unique values across duplicate data rows using composite functions like SUMPRODUCT combined with COUNTIF. Conditional Logic Functions: Master how to extract specific insights using conditional formulas such as MINIFS and MAXIFS to filter metrics like total impressions and views by distinct categories (e.g., gender or region). Combining Logic: See a step-by-step breakdown of how to aggregate multiple criteria by nested or additive SUMIF functions. The ETL Pipeline & Data Modeling: Get a comprehensive introduction to the Extract, Transform, Load (ETL) process. Understand what data modeling is and how to establish primary and foreign key relationships to join multiple tables seamlessly. Troubleshooting & Best Practices: Watch real-time debugging of syntax errors, handling network lags during collaborative work, and general tips for retaining complex formula structures through consistent practice and documentation. Whether you are looking to sharpen your spreadsheet skills for business intelligence or transitioning your data pipelines into Power BI, this session provides practical workflows for real-world data analysis. Timestamps: 00:00 - Introduction & Setting up the Workspace 08:50 - Calculating Unique Values (SUMPRODUCT + COUNTIF) 25:30 - Filtering Data with Conditional Minimums (MINIFS) 40:00 - Combining Data with Additive SUMIF Functions 51:00 - Pivot Tables vs. Manual Formulas for Complex Queries 54:15 - Deep Dive: What is ETL (Extract, Transform, Load)? 56:20 - Foundations of Data Modeling & Key Relationships 01:01:30 - Power BI Compatibility & System Requirements Don't forget to like, subscribe, and hit the notification bell for more data analytics tutorials!