NOTE: This post was written before Data Explorer was renamed as Power Query. All of the content is still relevant to Power Query. One of the first questions I get asked after showing someone ...

PowerPivot for Excel provides non-expert BI users the ability to create powerful BI solutions using Excel. PowerPivot for SharePoint facilitates the online hosting, sharing and collaboration of these ...

Simon Hurst advises how Excel’s PowerPivot add-in can streamline your dashboard measures. Tutorial 3 in this series looked at PowerPivot dashboards. An updated “release candidate” version of ...

Visual Basic Script (VBS) refresher for Excel files with Power Query and PowerPivot model, helping to update workbooks in automated way (+ can be scheduled). In addition, some useful VBS files that ...

The core idea behind PowerPivot is deceptively simple: Since people use Excel as a generic data analysis tool, why not make Excel into a front end for data analysis from any number of sources, not ...

In-Depth Microsoft PowerPivot: Making Excel Analytics Work A new component in SQL Server 2008 R2 gives users the autonomy to set up business intelligence functionality in Excel without taking ...

In Microsoft SQL Server 2008 R2 we introduced PowerPivot: A self-service Business Intelligence experience that enables information workers to create their own self-service BI solutions and ...