1 / 40

August 14 th , 2013

Donald Donais. August 14 th , 2013. Exploring Insights in your Data. PJ Johnson. Overview PowerPivot BI Semantic Model Break PowerView Performance Point Services. Agenda. Develop and support a local community focused on Microsoft SharePoint Technologies

mandell
Download Presentation

August 14 th , 2013

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. Donald Donais August 14th, 2013 Exploring Insights in your Data PJ Johnson

  2. Overview PowerPivot BI Semantic Model Break PowerView Performance Point Services Agenda

  3. Develop and support a local community focused on Microsoft SharePoint Technologies Educate user group members about SharePoint Technologies Transfer knowledge within the community Communicate best practices Introduce new products / solutions User Group Goal / Objectives

  4. WroxPress (www.wrox.com) O’Reilly (www.oreilly.com) MNSPUG Sponsors Dedicated Sponsors Annual Sponsor Benchmark Learning (www.benchmarklearning.com) Avtex (www.avtex.com) Microsoft (www.microsoft.com) softwareOne (www.softwareone.com) SharePoint User Group Support

  5. Today’s Lunch Sponsor Jamie Alperti and Ben Croswell Products Include: ControlPoint and ViewPoint for SharePoint • SharePoint Governance, Administration and Auditing • Yammer and SharePoint Social Awareness Session begins around 11:50 and runs about one hour. There will be a giveaway at the end of the presentation.

  6. SharePoint Resource Documents SharePoint Resource links RSS Feeds Meeting Schedule Past User Group Presentations Past User Group Recordings Sponsorship Information http://sharepointmn.com Email: sharepoint@sharepointmn.com MN SharePoint Users Group Website

  7. Linked In group – The most interactive… includes job postings… Post Job Posting on the Jobs Discussion page http://www.linkedin.com/groups?gid=1878792 Twitter tags - @MNSPUG and #MNSPUG Social Networking

  8. Next Meeting September 11th 9:00 AM to 11:30 AM SharePoint Upgrade – What You Need to Know Microsoft Technology Center Check www.SharePointMN.com for updates! Ongoing Schedule 2nd Wednesday of every month 9:00 to 11:30 am Microsoft Technical Center - Edina Upcoming Schedule

  9. Microsoft Webcast Calendar of Events http://www.microsoft.com/events/webcasts/calendar/monthview.aspx#filter SharePoint ShopTalk (Online) – Every Thursday @ 11:30 AM http://sharepointshoptalk.blogspot.com/ SharePoint Legal Users Group – 3rd Thursday @ 12:00 to 1:00 p.m. http://sharepointmnlegal.com SharePoSH – Online Virtual Event http://www.shareposh.com/Pages/default.aspx Minnesota SharePoint SharePint – August 20th , 2013 5 – 7 p.m. @ Joe Senser’s Sports Grill, Bloomington, MN SharePoint Saturday Omaha – September 28th, 2013 University of Nebraska, Omaha http://spsevents.org/city/Omaha/Pages/Information.aspx SharePoint Saturday Twin Cities – October 12th, 2013 Normandale Community College, Bloomington http://www.spstc.com/ SharePoint Saturday Chicago – November 2nd, 2013 Hard Rock Hotel, Chicago, IL http://www.sharepointsaturdaychicago.com/ SharePoint Conference 2014 – March 3-6th 2014 , The Venetian, Las Vegas, Nevada http://sharepointconference.com/ Anything Else? Local and Online Events

  10. Evaluations & Giveaways!

  11. Presenter

  12. Introductions PJ Johnson • Architect, Microsoft Technology • Architecting Business and Technology Strategies • World-Wide Lead for Business Productivity Solutions for all Microsoft Technology Centers

  13. MNSPUG -Business Intelligence Exploring Insights in your Data PJ Johnson, MTC Architect Content Development: Microsoft Technology Centers Content Delivery: <your organization here>

  14. Insights for Everyone from Any Data, Any Size, Anywhere Empower users of all levels with new insights through familiar tools while balancing the need for IT to monitor and manage user created content. Deliver access to all data types across structured and unstructured sources. 6. Self-Service Agile

  15. Explore Combine and analyze large datasets Summarize data and discover trends Instantly preview charts and pivot tables 6.

  16. Visualize Perform interactive data exploration Share reports with your colleagues Work together to make decisions on dashboards

  17. Share Embed & interact with data on your web page or SharePoint site Share & collaborate by sending a URL 6.

  18. Business Intelligence Defined Business User Experience Business Middle Tier Data Infrastructure & BI Platform • Self-Service access & insight • Ad-hoc (Multi-data sources) • Data exploration & analysis • Predictive analysis • Dashboards &Scorecards • Web based analytics • Web based forms & workflow • Collaboration • Enterprise Search • Enterprise Content Mgmt • LOB data integration • OLAP • Enterprise Reporting • ETL • MDM • Data Mining • Data Warehousing (RDBMS) ENTERPRISE DATA

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

  20. Explore andVisualize - PowerPivot Content Development: Microsoft Technology Centers Content Delivery: <your organization here>

  21. Delivering on our Promise of “BI for Everyone” 3 Dimensions of BI Personal Team Corporate Empowered Excel, SSRS, & PPS Formalized PowerPivot Analysis Services

  22. Self Service Analysis (PowerPivot) Excel-hosted client & reporting In-memory BI engine SharePoint for managed collaboration Analysis Services for BI integration

  23. PowerPivot and SharePoint Overall Architecture Front-End Servers Administration Server Excel Web Access PowerPivotManagement Dashboard PowerPivot Gallery SharePoint Web Services (Excel, PowetPivot, etc.) Site Collections SharePoint Central Administration Application Servers PowerPivotSystem Service Excel Calculation Services Analysis Services Instance Excel Services Search Services Secure Store Services PowerPivot for SharePoint InfoPath Forms Services Access Services Performance Point Services ReportingServices Storage Area Network FailoverCluster SharePoint Configuration, Service Application, andContent Databases

  24. DEMO PowerPivot

  25. Explore - Power Query Content Development: Microsoft Technology Centers Content Delivery: <your organization here>

  26. Explore -Business IntelligenceSemantic Model (BISM) Content Development: Microsoft Technology Centers Content Delivery: <your organization here>

  27. BI Semantic Model • Third-party • Applications • Power View • Excel • Reporting • Services • PerformancePoint • BI Semantic Model • Data model • Multidimensional • Tabular • Business logic • MDX • DAX • Queries • MDX • MDX/DAX • Data access • MOLAP • ROLAP • In-Memory • Direct Query Databases LOB Applications Files OData Feeds Cloud Services

  28. Data Model Multidimensional Tabular • Familiar model, easier to build, faster time to solution • Advanced concepts (parent-child, many-to-many) not available natively in the model… need calculations to simulate these • Easy to wrap a model over a raw database or warehouse for reporting & analytics • Sophisticated model, higher learning curve • Advanced concepts baked into the model and optimized (parent-child, many-to-many, attribute relationships, key vs. name, etc.) • Ideally suited for OLAP type apps (e.g. planning, budgeting, forecasting) that need the power of the multidimensional model

  29. Visualize - Operational Reporting Content Development: Microsoft Technology Centers Content Delivery: <your organization here>

  30. Reporting Services Reporting Services is a complete server-based platform supporting the authoring, management and delivery of relevant, interactive reports where needed across the entire enterprise Authoring Management Delivery

  31. Visualize -PowerView Content Development: Microsoft Technology Centers Content Delivery: <your organization here>

  32. POWER USERS IT PROS DEVELOPERS END USERS Intuitive DesignEnvironment Highly flexibleand productive Visual data representation Re-use of insights Report Viewer Controls Highly Interactive Rich Design Capabilities Flexible layout Rich Presentation Report Designer Report Builder Power View Embedded Operational Ad Hoc

  33. Power View Highly Visual Design Experience Rich Metadata-driven Interactivity Presentation-readyat all times • Interactive, web-based authoring and sharing of information • Familiar Microsoft Office design patterns • Powerful data layout with banding, callout and small multiples visualizations • Fully integrated with PowerPivot • Drive greater insight through smart and powerful querying • Zero configuration highlighting and filtering • Animated trending and comparisons • Interactive Presentation turns pervasive information into persuasive information • Deliver and collaborate through SharePoint • Full screen presentation mode for interactive boardroom session

  34. DEMO

  35. Visualize - Dashboard & Analytical Reporting Content Development: Microsoft Technology Centers Content Delivery: <your organization here>

  36. PerformancePoint Services • Context-driven dashboards across systems • Provides transparency and accountability • Interactive access using browser • Combine structured and unstructured information into a single view

  37. Manageability • Part of SharePoint Service Application • Common framework and infrastructure • PowerShell Management Scripting • Familiar Administration and fewer tools required

  38. DEMO Performance Point Services

  39. Please Fill Out Evaluations Drawings for Giveaways Today’s Presenter: PJ Johnson Last But Not Least

  40. Thanks for coming!

More Related