Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Backwards One to Many Relationship Report - Excel, Power Query or SQL?

ExcelIsFun via YouTube

Overview

Learn advanced Excel techniques for calculating average GPA with one condition across a one-to-many relationship between two tables. Explore multiple solutions using Excel array formulas, DAX measures in Excel 2016 Data Model, Power Query, and SQL coding in Access. Master the use of functions like AVERAGE, IF, COUNTIFS, AVERAGEX, CALCULATE, and FILTER to solve complex data analysis problems efficiently.

Syllabus

) Problem Introduction.
) Excel Array Formula Solution using AVERAGE, IF and COUNTIFS function with a Function Argument Array Operation.
) Excel 2016 Data Model DAX formula (DAX Measure) solution using AVERAGE, AVERAGEX, CALCULATE and FILTER functions, without Power Pivot.
) Power Query (Get & Transform).
) SQL coding in Access.
) Summary.

Taught by

ExcelIsFun

Reviews

Start your review of Backwards One to Many Relationship Report - Excel, Power Query or SQL?

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.