Teaching analytics with modern Excel
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 →
SWITCH() function in Excel Power PivotIt'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 →
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 →
RELATED() function in Excel Power PivotPower Pivot is a fantastic tool that lets you build relational models right from Excel. This negates the "death by VLOOKUP()" that many large workbooks face -- defining relationships across multiple …
Continue Reading about How to understand the RELATED() function in Excel Power Pivot →
ALL() function in Excel Power PivotIn Excel, filters make it easy to exclude data from PivotTables. You can check off the desired categories, and watch the numbers change throughout: The fancy word for this property is filter …
Continue Reading about How to use the ALL() function in Excel Power Pivot →