Understanding Power BI relationships and how to create them ensures your visuals filter and slice the way you expect. Learn more here.

Microsoft Power BI uses measures the same way Microsoft Excel uses functions. Learn how to recognize them in use and how to manipulate them when you want something different.

PowerPivot in Excel 2010 is an evolutionary improvement to the familiar Pivot Table model. Excel users can import or link to data in the usual way - via ODBC (Open Database Connectivity), or the like ...

A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.