Some good news: an important optimisation has rolled out for Excel PivotTables connected to Power BI semantic models! Back in 2019 I wrote about a very common problem affecting the MDX generated by ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...

Excel’s PivotTable feature is a fantastic option for data analysis, allowing users to consolidate and analyze data from various sources in a single, dynamic table. By mastering the art of creating ...

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical ...