Whether from multiple tables of a database or from different systems altogether, working in Excel often means cobbling a worksheet together from disparate data sources. In this post we'll look at how …
Introduction to Python (Financial Modeling Institute presentation)
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) →
How to understand the difference between left outer and inner joins in Excel Power Query
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 …
How to understand relational joins in Excel Power Query
In my book Advancing into Analytics I called VLOOKUP() the "duct tape of Excel:" Technology tactics move quickly. Excel now offers XLOOKUP() as a modern alternative to VLOOKUP(). But the theories …
Continue Reading about How to understand relational joins in Excel Power Query →
How to use the SWITCH() function in Excel Power Pivot
It's amazing to think that everything we do on our computers (at least for now) is powered by a series of True/False states. And while most of these operations are done behind the scenes, there's …
Continue Reading about How to use the SWITCH() function in Excel Power Pivot →
How to load a data model from Excel to Power BI
One of the best things about Power Pivot and Power Query is that once you've learned how to use them in Excel, you can easily transfer that knowledge to Power BI: But not only do your skills …
Continue Reading about How to load a data model from Excel to Power BI →