april 10-12, chicago, il advanced dashboard using excel, excel service and performancepoint
TRANSCRIPT
![Page 1: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/1.jpg)
April 10-12, Chicago, IL
Advanced DashboardUsing Excel, Excel Service and PerformancePoint
![Page 2: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/2.jpg)
April 10-12, Chicago, IL
Please silence cell phones
![Page 3: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/3.jpg)
3
Agenda
What’s new in Excel and Excel
Services?Apps for Office
What’s new in PerformancePoin
t?
How do we define a dashboard, and how do I get all this stuff on my dashboard?
![Page 4: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/4.jpg)
Microsoft BI Strategy
The stack:Data Analysis with SQL
Analysis ServicesSQL ServerIntegration Services
The Tool:End user exploration
ExcelPower ViewPowerPivot
The Tool:Sharing
Excel ServicesVisio ServicesPerformancePoint
![Page 5: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/5.jpg)
5
The Forrester Wave™: Self-Service Business Intelligence Platforms, Q2 2012, Forrester Research, Inc., June 12, 2012.
“Microsoft enables business users to look no further than Excel for self-service BI”
![Page 6: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/6.jpg)
Excel 2013
Navigate models, preview and shape up your data (Quick Explore, Quick Analysis and Flash Fill)
Access and mash-up data from any source (PowerPivot)
Stunning visualizations and data discovery (Power View)
Work with hundreds of millions of rows of data (powered by xVelocity)
![Page 7: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/7.jpg)
Excel Services 2013Perform interactive data exploration
Share reports with your colleagues
Work together to make decisions on dashboards
![Page 8: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/8.jpg)
What are Apps for Office?
Content Area
Also known as Agaves . . .
Task Pane
![Page 9: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/9.jpg)
11
Where do Apps for Office live?
File Shares
Marketplace
Corporate Catalogs
![Page 10: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/10.jpg)
How do Apps for Office Work?
• iFrames within the Office app
• Client JavaScript libraries for Office
• Manifest + JS + Office App = App for Office
• If you can show it in a web site, you can show it in an app.
Office Application
Office Web
Extension
Manifest
<XML>
WebPage
(HTLM+JS)
JS
![Page 11: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/11.jpg)
Client Fidelity = Browser Fidelity
![Page 12: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/12.jpg)
15
PerformancePoint Services 2013Composite Dashboard in SharePoint
Share reports with your colleagues
Rich Scorecard and KPI’s
![Page 13: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/13.jpg)
Takeaways
![Page 14: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/14.jpg)
ResourcesExcel Team BlogReporting Services Team BlogData Visualizations in Power ViewWhat’s new in Power View in Excel 2013 and Sharepoint 2013
![Page 15: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/15.jpg)
19
Win a Microsoft Surface Pro!
Complete an online SESSION EVALUATION to be entered into the draw.
Draw closes April 12, 11:59pm CTWinners will be announced on the PASS BA Conference website and on Twitter.
Go to passbaconference.com/evals or follow the QR code link displayed on session signage throughout the conference venue.
Your feedback is important and valuable. All feedback will be used to improve and select sessions for future events.
![Page 16: April 10-12, Chicago, IL Advanced Dashboard Using Excel, Excel Service and PerformancePoint](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649e165503460f94b00c17/html5/thumbnails/16.jpg)
April 10-12, Chicago, IL
Thank you!Diamond Sponsor Platinum Sponsor