1 / 17

S elf-Service BI using PowerPivot and Power View

S elf-Service BI using PowerPivot and Power View. MODIFY THIS SLIDE FOR ACTUAL PRESENTER, DELETE THIS BAR AFTER MODIFICATION. ILIKESQL.COM. dandyw@microsoft.com. Dandy Weyn. @ ilikesql. Microsoft Business Intelligence. Most Broadly adopted Productivity & Collaboration Tools.

sabin
Download Presentation

S elf-Service BI using PowerPivot and Power View

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. Self-Service BI using PowerPivot and Power View

  2. MODIFY THIS SLIDE FOR ACTUAL PRESENTER, DELETE THIS BAR AFTER MODIFICATION ILIKESQL.COM dandyw@microsoft.com Dandy Weyn @ilikesql

  3. Microsoft Business Intelligence Most Broadly adopted Productivity & Collaboration Tools SharePoint Collaboration Excel Workbooks PowerPivot Applications SharePoint Dashboards & Scorecards Analysis Services Reporting Services Most widely deployed EIM & BI Platform Integration Services Master Data Services Odata Feeds LOB Apps

  4. Rapid Data Exploration & VisualizationEmpower end users with new insights SELF-SERVICE ANALYSIS • Familiar Excel Experience • Powerful Data Mashups • In-Memory Performance • STUNNING, INTERACTIVE DATA VISUALIZATION • Highly Visual Design Experience • Rich Metadata-Driven Interactivity • Presentation-Ready at All Times SHARE & COLLABORATE THROUGH SHAREPOINT • Easily Access Reports &Dashboards • Create Alerts From Published Reports • Collaborate on BI Insights

  5. Stunning, Interactive Data VisualizationDiscover new insights at the speed of thought with Power View Discover and share insights across all levels of the organization with Power View • Interactive, browser-based visualization tool for gathering insights at the speed of thought Immersive, visual design experience Richmeta data-driveninteractivity Presentation-ready at all times

  6. What is Power View? From Authoring to Presentation in Clicks Easily change data and layout with quick clicks Collaborate with full interactivity Share dynamic reports quickly and easily Powered by Silverlight Managed & Discoverable

  7. Power View is Completely Web-Based Familiar Office Ribbon Access to semantic model Simply drag and drop objects to see data come to life Customize Shapes and data

  8. Designed for a New Wave of Information Workers Share dynamic reports quickly and easily VISUAL EMBELLISHMENTS SUPPORT & ENRICH DATA STORY TELLING 1-way to do things 2 clicks to Return on Investment (ROI) All tasks done in context Everything happens on the canvas, with the data Less is more Choose the right default, by default Easy for the user, hard on us Highly performing and efficient Power View UI Design Principles Collaborate with full interactivity Easily change data and layout with quick clicks

  9. PowerPivot PowerPivot for Excel PowerPivot for SharePoint Analyzing Massive Data Volumes in Excel With a few mouse clicks, a user can create and publish intuitive and interactive self-service analysis solutions.

  10. Analysis Services: SQL Server 2012 Goal #1 Continue to provide best-in-class tools for BI specialists Goal #2 Extend the reach of BI tools to a broader base of IT professionals and developers SQL Server Analysis Services Future Roadmap BI Semantic Model Goal #3 Provide a single model for creating BI solutions that is transparent to client tools Goal #4 Support the full spectrum of BI solutions, including personal, team, and corporate contexts

  11. Analysis Services Architecture SharePoint Internet Explorer SQL Server Data Tools (Formertly BIDS) Power View Excel Services Reporting Services xlsx PowerPivot for Excel Analysis Services BI Semantic Model PowerPivot for SharePoint (Analysis Services) Excel xlsx Third Party Apps Personal BI Team BI Corporate BI

  12. DEMO

  13. Power View for All Users Sophisticated Design Environment Report Viewer Controls Rich Design Capabilities Developers Productive Authoring Re-use of insights Flexible layout IT Pros Power Users Visualdata representation Highly Interactive Rich Presentation End Users Report Designer Report Builder Power View Embedded Operational Business

  14. PowerPivot Management Dashboard PowerPivot is great for IT: Track the usage of PowerPivotObjects Discover mission-critical applications Increase IT efficiency: Familiar Technologies for Authoring, Sharing, Security and Compliance Visualize system performance and usage Find out what data sources are being used!!!

  15. PowerPivot Summary Integrate data from multiple sources Analyze large volumes of data Powerful BI capabilities within familiar tool Thin client collaboration Manage rogue BI

  16. Resources SQL Server Hands-on-Labs SQLSERVERLAUNCH.COM

More Related