PowerPivot is huge. You could write whole books about it. In fact, people have written whole books about it. I've focused on getting data into PowerPivot, because this is the area that is going to be the least familiar to Dynamics GP users. Once the data comes into an Excel pivot table, the processes of pivoting data, reporting off of data, and building dashboards is essentially the same regardless of how the data comes in. Given our limited time and space, I did want to highlight a few things that we won't spend much time on.
PowerPivot allows you to work with millions of rows of data. The sample data in GP 2013 doesn't even come close to this level, but don't lose sight of how powerful this can be. I had someone come up to me with a million rows in their Analytical Accounting tables, and that data was growing by tens of thousands per month. I have other companies that I work with that have 10 years of GL history and their GL numbers are well...