Teaching analytics with modern Excel
I asked ChatGPT: if the 7 wonders of the modern world were modern Excel features, which would they be and why? Here's what I got back: 1. Great Wall of China - Power Query The Great Wall is …
Continue Reading about What are the seven wonders of Modern Excel? →
Data modeling, contrary to be nearing obsolescence, remains crucial for data analysts aiming to enhance their reporting speed and deepen their insights into business operations. Bernard Obeng …
CALCULATE() function in Excel Power PivotExcel users have access to a wealth of powerful functions through Power Pivot and DAX, but one function stands out as particularly crucial: CALCULATE(). This function holds the key to dynamically …
Continue Reading about How to use the CALCULATE() function in Excel Power Pivot →
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'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 →
