melissa meyer. 2 | sharepoint saturday st. louis 2014
TRANSCRIPT
![Page 1: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/1.jpg)
Melissa MeyerSenior Consultant
Self-Service BI with PowerPivot
Covenant Technology Partners
![Page 2: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/2.jpg)
2 | SharePoint Saturday St. Louis 2014
Housekeeping Follow SharePoint Saturday St. Louis on
Twitter @spsstlouis and hashtag #spsstl Play “Sponsor Bingo” to register for your
chance to win one of the many great giveaways at the end of the day
Schedule and evaluate each session you attend via our mobile app that can be used across devices at http://spsaturday.cloudapp.net
![Page 3: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/3.jpg)
3 | SharePoint Saturday St. Louis 2014
Outline What is PowerPivot and why does it rock? What’s new in the newest edition? Demo Questions
![Page 4: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/4.jpg)
4 | SharePoint Saturday St. Louis 2014
PowerPivot for Excel Free Add-in for Excel Import, Model, Relate data from disparate
sources SSAS Excel Relational DBs
Create Calculated fields and use them anywhere
xVelocity In Memory Engine Store Millions of rows of data in Excel
![Page 5: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/5.jpg)
5 | SharePoint Saturday St. Louis 2014
PowerPivot for SharePoint Server hosting of PowerPivot Data Scheduled Refresh Leverages SharePoint to administer and
secure PowerPivot workbooks Ability to easily collaborate and share
PowerPivot workbooks Source for Power View, SSRS Reports and
Excel
![Page 6: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/6.jpg)
6 | SharePoint Saturday St. Louis 2014
DAX Based on Excel formulas and relational concepts Easy to get started Ability to create complex calculations
Recursion Time Intelligence Lookups based on Relationships
ExamplesTotalSales:= SUM ( [SalesAmount] )SalesYTD:= TOTALYTD ( SUM ( [SalesAmount] )
, ’Date’ [FullDateAlternateKey] , ALL ( Date ) )SalesPctOfQuota:= IF ( ISFILTERED ( 'Date‘ [EnglishMonthName] ) , BLANK() , DIVIDE ( SUM ( ResellerSales [SalesAmount] ) ,
SUM ( [SalesAmountQuota] ) , 0 ) )
Types of Functions
Date and Time Filter Logical Math and Trig Statistical Time Intelligence
![Page 7: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/7.jpg)
7 | SharePoint Saturday St. Louis 2014
Date Best Practices Create a Date table Date table should have a continuous range
of dates – no gaps Mark it as Date table Lowest grain should be day without
hours/min/secs
![Page 8: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/8.jpg)
8 | SharePoint Saturday St. Louis 2014
What’s New In PowerPivot
New DAX Functions USERELATIONSHIP DISTINCTCOUNT RANK CROSSJOIN LOOKUPVALUE SWITCH PATH PATHITEM And More…
Diagram View Hierarchies Calculation Area Perspectives KPIs Date Table Settings And More…
![Page 9: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/9.jpg)
9 | SharePoint Saturday St. Louis 2014
DEMO
![Page 10: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/10.jpg)
10 | SharePoint Saturday St. Louis 2014
Session Evaluations Schedule and evaluate each session you attend via
our mobile app that can be used across devices at http://spsaturday.cloudapp.net
You will be able to evaluate a session 25 minutes before the scheduled end time
Evaluations are stored anonymously and your feedback is appreciated
The app will be the only method available to submit session evaluations for the event and we hope you find it intuitive and convenient
![Page 11: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/11.jpg)
11 | SharePoint Saturday St. Louis 2014
Silver
Thanks to Our Sponsors!
Gold Silver
Raffle
![Page 12: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/12.jpg)
12 | SharePoint Saturday St. Louis 2014
Resources How to get PowerPivot for Excel 2010 and
2013 http://
office.microsoft.com/en-us/excel/download-powerpivot-HA101959985.aspx
PowerPivot Resources http://
technet.microsoft.com/en-us/sqlserver/dn151372.aspx
http://www.powerpivotpro.com/ http://www.powerpivotblog.nl/
![Page 13: Melissa Meyer. 2 | SharePoint Saturday St. Louis 2014](https://reader035.vdocuments.us/reader035/viewer/2022070307/551b2133550346dd1a8b45ae/html5/thumbnails/13.jpg)
13 | SharePoint Saturday St. Louis 2014
Thank You!
Questions?