© 2010 Microsoft Corporation. All rights reserved.

Microsoft SQL Server PowerPivot for Excel 2010 workbook samples are provided for informational purposes only as an aid to illustrate a concept. These
example companies, organizations, products, domain names, e-mail addresses, people, places, and events depicted herein are fictitious, and no associa
mail address, person, place, or event is intended or should be inferred.

LCA BI Finance

Financial Report Usage Tracking powered by PowerPivot

This shape represents a
slicer. Slicers can be Total Users & Hits Da
used in at least Excel
2010. 50000
25000
45000
40000
This
If theshape
shaperepresents
was a
35000
slicer.
modified Slicers
in ancan be
earlier 30000
20000
used in at
version of least Excel
Excel, or if 25000
2010.
the workbook was 20000 Sum of Hits
Sum of Users 15000
saved in Excel 2003 or 15000
If the shape
earlier, was
the slicer 10000
modified
cannot bein an earlier
used. 5000 10000
version of Excel, or if 0
the workbook was
saved in Excel 2003 ora 5000
This shape represents
earlier, the slicer
slicer. Slicers can be
cannot
used in be used.Excel
at least 0
2010.

If the shape was

modified in an earlier
version of Excel, or if
the workbook was
saved in Excel 2003 or
earlier, the slicer
cannot be used.

Hits by Sub-Group
Group Eleven - Sub Group Ten - Sub Group Group Nine - Sub Group Group Six - Sub Group Group Six - Sub Group Group Six - Sub Group
Group One One One Six Seven O ne
Group Two - Sub Group Group Thirteen - Sub Group Sixteen - Sub Group Sixteen - Sub Group Sixteen - Sub Group Four - Sub Group
One Group One Group Three Group Eleven Group One O ne
Group Five - Sub Group Group Fifteen - Sub Group Fourteen - Sub Group Three - Sub Group Twelve - Sub Group Seven - Sub

This shape represents a

One Group One Group One Group Three Group Four Group One
Group Twelve - Sub Group Thirteen - Sub Group Six - Sub Group Group Thirteen - Sub Group Twelve - Sub Group Sixteen - Sub
Group Two Group Five Five Group Four Group Three Group Seven
Group Sixteen - Sub Group Thirteen - Sub Group Five - Sub Group Group Sixteen - Sub Group Three - Sub Group Six - Sub Group
Group Two Group Three Two Group Ten Group Six Three
Group Sixteen - Sub Group Sixteen - Sub Group Seven - Sub Group Seven - Sub Group Seven - Sub Group Thirteen - Sub

slicer. Slicers can be

Group Four Group Six Group Four Group Three Group Two Group Two
Group Eight - Sub Grand Total
Group One

used in at least Excel

2010.

If the shape was

modified in an earlier
version of Excel, or if
the workbook was
saved in Excel 2003 or
earlier, the slicer
cannot be used.
If the shape was
modified in an earlier
version of Excel, or if
the workbook was
saved in Excel 2003 or
earlier, the slicer
cannot be used.
s an aid to illustrate a concept. These samples are provided “as is” without warranty of any kind. The
d herein are fictitious, and no association with any real company, organization, product, domain name, e-

PowerPivot

Dashboard & Report Hits

25000
Column Labels DB - PG DB - Executive
20000 Highlights
DB - Attorney DB - Firm
Report - Matter Report - Firm
15000 Report - IO Report - PG
Report - Attorney Report - Task
10000 Report - Time Report - Budget Recon
DB - PG More Report - Geography

5000

Role, User Hits

Business Manager 22533
Shrader, Jill 2457
Hernady, Robert 2156
Burk, Susan 1972
Andreshak, Joe 1705
Silva, Alexandre 1606
Goldin, Maxim 1596
Grinius-Hill, Susan D. 1393
Mirchandani, Bharat 1290
Hance, Jim 1273
Liu, Jenny 1271
Martínez, Frank 1012
Remick, Enoch T. 995
Kránitz, József 725
Johnson, David 687
Johnson, Brian 650
Poozhiyil, Suraj 521
Kaliyath, Sandeep 356
Moore, Michael 230
Karásek, Petr 215
 Kumar, Deepak 196
Bacon Jr., Dan K. 182
Carlson, Ty 45
Admin 4573
Neipper, Michael 2867
Mahadevan, Vidhya 515
Kin, Tatsunari 282
Fourre, Gwenael 281
Carpenter, Chase 249
Sreenivas, Mahesh 213
Garcia, Debra 76
Raheem, Michael 71
Hamilton, David 19
Paralegal 4395
Guinot, Allan 320
Deming, Stephen 308
Boyer, Marc 305
Béres, Kálmán 259
Solanki, Ajay 219
Mirtič, Damjan 218
Alexieva-Bosseva, Diliana 202
Dell, Eduard 199
Rao, Arvind B. 178
O'Neill, Tom 168
Ackerman, Pilar 167
Bye, Dennis 164
Kirilov, Stanimir 145
Dick, Cari 143
King, Russell 142
Elznicova, Eva 140
Kubovcik, Miroslav 139
Brown, Derek 134
Carey, Richard 114
Kirilov, Anton 114
Rowe, Todd 106
Bott, Jörg 98
Hamborg, Thomas 95
Jean, Virginie 83
Kennedy, Will 80
Li, Yan 57
Fontana, Olivier 40
Lyon, Robert 38
Jøergensen, Irene 20
Attorney 4321
Rubin, Idan 713
 Richardson, Wendy 506
Herbinger, Andreas 418
Jain, Mukesh 337
Roic, Alessio 246
Chen, Aik 202
Graceffo, Elisa 179
Kharoufeh, Bishara 179
Bochenek, Tomasz 172
Artman, Ravital 152
Kelly, Bob 151
Berroth, Michael 131
Shen, Paul 125
Isla, Julian 122
Sprenger, Christof 94
Severino, Miguel 91
Kensok, Jennifer 76
Smith, John 75
Rolecki, Marek 74
Makovac, Zrinka 69
Lan, Andrew 57
Chen, Jacky 57
Palma, Tude 57
Capek, Karel 38
Finance Manager 3678
Blythe, Michael Greg 1712
Con, Aaron 488
Cameron, Maria 370
Ebdrup, Mads 357
Goldschmidt, Daniel 331
Posti, Juha-Pekka 306
Krausova, Renata 114
Unknown 3121
Nixon, Toby 1496
Royant, Sabine 558
Moore, Bobby 248
Fischer, Heinrich 160
Krawczak, Joseph 123
Rudmanis, Raimonds 90
Pezzini, Pierangela 85
Orint, Neil 79
Anderson, Christen 74
Jurek, Michael 57
Eamsiri, Krittiya 38
Smith, Samantha 37
Sharma, Ashvini 19
 Brussard, Chloe 19
Bermejo, Antonio 19
Raghav, Amritansh 19
AGC 2550
Paramasivam, Prakash 321
Rockfeld, Scott 295
Arifin, Zainal 284
Carbonati, Cyril 221
Creasey, Jack 207
Bloesser, Rex 184
Probst, David 177
Schaller, George 174
Beasley, Shaun 169
Grilo, Carlos 137
Mogensen, Michael 123
Geller, Christa 114
Murchison, Heather 76
Salopek, Dubravka 42
Hagege, Adina 23
Steffensen, Kim 3
Procurement 1306
Solovay, Andrew 686
Bryant, Chris 401
Dubicki, Dominik 219
DGC 326
Lange, Michael 194
Paturskis, Leonids 132
Grand Total 46803