Power Pivot/Query/BI

Power Pivot, Power Query, and Power BI are amazing tools that help us Get & Transform data and creating interactive reports and dashboards.

PowerPivot Instead of VLOOKUP Excel Showdown

Formulas, Pivot Tables, Power Pivot, Power Pivot/Query/BI

How To Use Power Pivot Instead of VLOOKUP

October 6, 2014

Pivot Table Source Data Comparison

Modeling, Pivot Tables, Power Pivot/Query/BI, Power Query

How to Structure Source Data for a Pivot Table & Unpivot

July 18, 2013