Teaching analytics with modern Excel
In a previous post, we looked at how to create calculated column in Excel Power Query. Now, let's explore when and how to perform the same task in Power Pivot: Calculating in Power …
Continue Reading about How to create calculated columns in Excel Power Pivot →
At the core of Power Pivot is relational data modeling, which allows users to create relationships between tables for efficient calculation and data analysis. With Power Pivot, users can create and …
Continue Reading about How to create and manage relationships in Excel Power Pivot →
If you've worked with Power Pivot in Excel, you've seen the central role of shared fields in establishing relationships between tables. But perhaps you've never considered how the total number of …
Continue Reading about How to understand cardinality in Excel Power Pivot →
If you're using Power Pivot, you're probably dealing with table relationships and applying filters to refine results. This blog post explores filter direction in Power Pivot and how it enables …
Continue Reading about How to understand filter direction in Excel Power Pivot →
This event has concluded. Thank you to the Financial Modeling Institute for the opportunity to present. In March 2023 I had the opportunity to lead a one-hour webinar with the Financial Modeling …
Continue Reading about Introduction to Python (Financial Modeling Institute presentation) →
In a previous post, we looked at some of the limitations of XLOOKUP() and other Excel "duct tape" lookup functions. Relational joins in Power Query were introduced as a more robust alternative. This …
