Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Creating a PowerPivot Report

Now that you know how to load data into a PowerPivot workbook in Excel, you can begin to

report on it. You can leverage some of the abilities of PowerPivot to deliver data quickly and

efficiently to Excel, while using the visualization features of Excel to make your report useful

to your end users.

Reporting is a powerful feature in Excel and now even more so with the addition of PowerPivot.

PowerPivot has new capabilities for managing and building relational datasets right in Excel,

and it does not need to use Access or complicated query strategies to get the end users the

data on which they want to report. This lesson will teach you how to harness the power of

Excel and the new PowerPivot add-in to make complicated and in-depth reporting simpler to

deliver.

COMPONENTS OF A POWERPIVOT REPORT

A number of components make up your report. Major pieces include:

Data source (we will be using PowerPivot data)



PivotTable



Pivot chart



DAX (Data Access Expressions) formulas for analysis



You’ll build these items piece by piece and then you’ll have a visually appealing report for your

end users.

33

889633c33.indd 303 8/16/10 10:45:10 PM

304



LESSON 33 Creating a PowerPivot rePort

BUILDING THE REPORT

First you need to import your data. You learned how to do this in the ...