Tag: data model

Power Pivot Olympic Dashboard

0 commentsExcelPower PivotPower Queryclean datadata modelexcelpivot tablepower pivotpower query

3 Game-Changing Things Power Pivot in Excel Can Do

If you’ve never experimented with Power Pivot in Excel, and you work with data with hundreds or thousands of rows, you’re probably sick of V-Lookups, index/match, and other frequently used Excel formulae. Even though Power Pivot may have a steeper learning curve, getting acquainted with it will save you countless hours in the long-run. This ….  Read More