powerpivotpro's channel
Loading...
-
5 months ago
PowerPivot Data Analyst 1 - What is PowerPivot?
Learn about the five benefits of PowerPivot in this introductory video from MrExcel.
This video is designed to accompany the book, PowerPivot for...
powerpivotpro
commented:
-
5 months ago
Learn Excel 2010 - "Hosted PowerPivot" #1432
Excel 2010 introduces the ability to put your worksheets on the web and introduced PowerPivot. You could never get your PowerPivot worksheets on th...
powerpivotpro
liked
-
5 months ago
powerpivotpro
commented:
@jakabpeterjax Hi Peter. Typically this is caused by entering an incorrect username. Are you saying you see a blank page *before* you are ever prompted for a username and password? If so, please send me a screenshot of the blank browser window as well as what browser you are running (including...
-
-
-
-
2 years ago
Converting a PowePivot Report to Cube Formulas
Shows how a PowerPivot-backed PivotTable can be coverted to a collection of cell-by-cell formulas, which can then be formatted and arranged however...
powerpivotpro
uploaded
-
2 years ago
Parameterized/Sliced PowerPivot Report using Cube Formulas
Contrary to the name, PowerPivot reports do not have to use pivots. Here I show a report that includes several twists that are not possible in piv...
powerpivotpro
uploaded
-
2 years ago
Dax Measure Pt 1
Showing how to add a "Qty per Day" measure to a pivot report using PowerPivot and its extension to the Excel formula language (DAX).
See http://po...
powerpivotpro
uploaded
-
2 years ago
Dax Measure Pt 2
Showing how to add a "Qty per Day" measure to a pivot report using PowerPivot and its extension to the Excel formula language (DAX).
See http://po...
powerpivotpro
uploaded
-
2 years ago
PowerPivot Temperature Mashup Pt 2
(See http://powerpivotpro.com for more PowerPivot content.)
Using PowerPivot to build a report that lets users "slice" sales data by the temperatu...
powerpivotpro
uploaded
-
2 years ago
PowerPivot Temperature Mashup Pt 1
Using PowerPivot to build a report that lets users "slice" sales data by the temperature range being experienced by customers on the date of the sa...
powerpivotpro
uploaded
-
2 years ago
PowerPivotPro's First Video Blog Post - Fun With Slicers and Relationships
See http://powerpivotpro.com for more PowerPivot content.
powerpivotpro
uploaded
@Melchizeedek Just wanted to say that I agree with Bill's points completely. I'd also add that Access can serve two complementary roles with PowerPivot. One is data shaping - transformations etc. PowerPivot offers nothing for that. The other is as a data collection/entry tool, via forms. Eit...