Thursday
Jun202013

PowerPivot 6 - The Joy of Sets

Concluding our Tutorial on PowerPivot, my last post in this series looks at the Time Intelligence functions, Key Performance Indicators, and gives an introduction to the Joy of Sets (In Excel PowerPivot!)

Click to read more ...

Monday
Jun102013

PowerPivot 5 - Measure for Measure

We're doing well in our short PowerPivot course. So far we've seen the many features of PowerPivot as extensions to Excel. Now we get to "Measures" a powerful calculation tool, and one that's just a bit different from anything we've seen before in Excel. Read this blog carefully, and try the examples and soon you'll be using Measures like an expert!

Click to read more ...

Thursday
May302013

PowerPivot - 4

Right, we've got PowerPivot installed and working, connected data and got a pivot table created. Good, but only a small part of what PowerPivot can do. Now we start to look at the real "Power" in PowerPivot, calculating column data with the DAX language....

Click to read more ...

Page 1 ... 3 4 5 6 7 ... 18 Next 3 Entries »