1 / 16

Advanced Dashboard

Advanced Dashboard. Using Excel, Excel Service and PerformancePoint. Please silence cell phones. Agenda. How do we define a dashboard, and how do I get all this stuff on my dashboard?. Microsoft BI Strategy. Excel Services Visio Services PerformancePoint. The Tool: Sharing. Excel

harris
Download Presentation

Advanced Dashboard

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced Dashboard Using Excel, Excel Service and PerformancePoint

  2. Please silence cell phones

  3. Agenda How do we define a dashboard, and how do I get all this stuff on my dashboard?

  4. Microsoft BI Strategy Excel Services Visio Services PerformancePoint The Tool: Sharing Excel Power View PowerPivot The Tool: End user exploration Analysis Services SQL Server Integration Services The stack: Data Analysis with SQL

  5. “Microsoft enables business users to look no further than Excel for self-service BI” The Forrester Wave™: Self-Service Business Intelligence Platforms, Q2 2012, Forrester Research, Inc.,  June 12, 2012.

  6. 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)

  7. Excel Services 2013 Perform interactive data exploration Share reports with your colleagues Work together to make decisions on dashboards

  8. What are Apps for Office? Also known as Agaves . . . Content Area Task Pane

  9. Where do Apps for Office live?

  10. How do Apps for Office Work? Office Application 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 Web Extension JS Manifest <XML> Web Page (HTLM+JS)

  11. Client Fidelity = Browser Fidelity

  12. PerformancePoint Services 2013 Composite Dashboard in SharePoint Share reports with your colleagues Rich Scorecard and KPI’s

  13. Takeaways All users can transform data into insight… as a natural part of their day to day activities… with the tools they already know & love.

  14. Resources Excel Team Blog Reporting Services Team Blog Data Visualizations in Power View What’s new in Power View in Excel 2013 and Sharepoint 2013

  15. 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/evalsor 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.

  16. Thank you! Platinum Sponsor Diamond Sponsor

More Related