Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

This post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. I am very happy to be writing this blog post today. Not just because I will be showing you another way Excel can ...

1. Add your PivotTable to the Data Model. For this functionality to work, you must add the PivotTable report to the Data Model when you create the PivotTable. This is done by checking the box next to ...

7 Advanced techniques for using Excel PivotTables to enhance data analysis efficiency and effectiveness. Covering practical examples and ...

Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the Excel Data Model and Power BI d… ...

Liam Bastick looks at the new PivotTable enhancements and updates in Office 2019. PivotTables were enhanced beyond recognition with the advent of Excel 2010 and Excel 2013, and the introduction of ...

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!