1 / 38

Required Slide

Required Slide. Required Slide. SESSION CODE: BIP05-INT. Delivering BI to the Masses at Microsoft Using Microsoft CBI : Top 10 Challenges. Sanjay Soni BI Platforms Evangelist Microsoft Corporation. Curtis Chernosky CBI Solution Manager Avanade Inc. Agenda. Business Problem Scenario

talasi
Download Presentation

Required Slide

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. Required Slide

  2. Required Slide SESSION CODE: BIP05-INT Delivering BI to the Masses at Microsoft Using Microsoft CBI: Top 10 Challenges Sanjay Soni BI Platforms Evangelist Microsoft Corporation Curtis Chernosky CBI Solution Manager Avanade Inc.

  3. Agenda • Business Problem Scenario • Microsoft Consolidated Business Intelligence (CBI) Overview • Microsoft CBI Demo • Delivering BI to the masses at Microsoft - Top 10 considerations and lessons learned • Upgrade to Office SharePoint 2010 - Microsoft PowerPivot hosted solution • Summary

  4. Assumptions and what is not covered during the session • Assumption : you are already familiar with Microsoft BI products • What is covered during the session • Delivering BI to the masses using the BI portal and MS BI stack • Top 10 challenges faced when we created a solution that delivers BI to 30,000+ folks at Microsoft • What is not covered during the session • How to create BI using Relational DW, Integration Services and Analysis Services or related issues • Source code

  5. Top 10 considerations, questions and lessons learned while delivering BI to the masses

  6. It is all about that Microsoft Vision ofDelivering BI to the masses! Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions • Delivered through a familiar environment • Integrated into business collaboration infrastructure • Built on a trusted and extensible platform

  7. Microsoft Business IntelligenceGet more out of products you already own Familiar User Experience Self-service Access and Insight Data Exploration and Analysis Predictive Analysis Data Visualization Contextual Visualization Business User Experience Integrated Content and Collaboration Thin Clients Dashboards BI Search Content Management Compositions Business Collaboration Platform Information Platform Analysis Services Reporting Services Integration Services Master Data Data Mining Services Data Warehousing Information Platform

  8. The Microsoft CBI Story…

  9. Once upon a time … there was an IT department and various business groups

  10. There were Silos of unorganized BI Individual IT departments were creating most of the reports for business Delivery was slow End users had to go to different report catalogs/shares Sales & Marketing Human Resources Operations Finance

  11. Somebody in IT department had a great idea… • CBI was created with • a single enterprise Report catalog • Hosted BI solution with Reporting Services, PPS etc. • A SharePoint based BI portal Sales & Marketing Human Resources CBI Operations Finance

  12. Sales & Marketing CBI Business power users encouraged to create reports and were provided capability to publish their reports Human Resources Operations Finance

  13. Sales & Marketing CBI Result: Agile BI happened and Collaboration increased Users increased to 30,000 users Number of applications in the catalog increased Human Resources Operations Finance

  14. Sales & Marketing CBI Today… Business creates many more reports than the IT department IT department manages, secures and enables managed self service BI More reports switched to cleaner data from EDW and yes it is a continuous process Human Resources Operations Finance

  15. Welcome to CBI … A centrally hosted, secure, and personalizable BI Portal destination with one enterprise report catalog for scorecards, reports & business analysis Externally available for Microsoft customers

  16. Report publishing process 16

  17. Microsoft CBI Demo DEMO

  18. Powered by Other data Sources Other data Sources

  19. Familiar business problem scenario for a fictitiouscompany you can relate with… HR • Lost productivity of end users • Reports / scorecards are everywhere for different groups • Users go to at least 8 different places for their BI • Request access to reports from 8 different IT teams • Inconsistent UI and user id and password required for each application • Data is not coming from a single version of the truth - EDW • Business rumor that IT takes too long to create BI solution • Each IT implementation team has to figure out security, ramp up on BI expertise to host and secure • Shadow applications built by business and vendors are agile • IT needs to maintain those shadow applications when they break • It is not easy to convince executives to invest in a single consolidated BI solution for entire company Finance S&M IT Silos of unorganized BI assets

  20. 10 Powered by Other data Sources Other data Sources

  21. 9 • Push or pull approach • Create a cool demo for the first prototype • Realistic scenario with sponsor’s data • Latest technology and UI demo • Take your time

  22. 9 How to justify costs? BI Consumers IT/Operations Teams BI Report Creators • Integrated Microsoft BI capabilities • Reduced implementation times with secure hosted solution • Enables business users to manage and control access • One central & secure destination for allBI analytics • Improved userproductivity through reduced time to find desired information • Improved user experience through consistent UI • Centralized and robust security architecture • Reduced maintenancecosts • Reduction in shadow application development

  23. INTERNET 8 Metadata Store (MOSS, PAS, SRS, PPS, Excel EXTRANET • Plan for the first customer scenario with a vision for enterprise BI • Scalable Corpnet and extranet scenario Sql Server With Failover cluster Customer Data Sources Catalog Client Microsoft Office SharePoint Servers AD Authentication Domain Account (NTLM) Extranet Users Catalog Client web svc Catalog AD Bridge svc Network Services (Kerberos) IIS Server NLB Cluster Authorization LDAP Queries Extranet AD LDAP Queries CORPNET Catalog AD Provider SVC MSR Catalog Admin Web SVC Corpnet AD LDAP Queries Authorization Power Users (Via Catalog Admintool) Role Based Permissions(RBP) Corpnet Users

  24. 7 CBI Catalog is URL based and hence even third party BI tool reports can be added to it

  25. 6 • AD Authentication • Constrained Delegation (Kerberos) for data level security • SharePoint security for Excel Services / DCL storage and community pages • Role Based Permissions (RBP) - Internal

  26. 5 • A BI portal across the enterprise • Report Center & the Catalog • Storage and Security • Performance Point Server, Excel Services and SSRS • Benefits of using SharePoint • Centralizing Access to Business-Critical Information  • Reusable web parts that can be used in other SP sites • Reducing the Number of Business Intelligence Applications  • Sharing Business Data While Maintaining the Security of Information 

  27. 4 • Scale out approach • Plan for regional deployment upfront or set the right expectations

  28. 3 3 Help business units target right BI front end tools for the right users Analytics Reporting Dashboards Build reports with Report Builder Analyze data with Excel Explore data in SharePoint

  29. 2 • Evangelize and provide demonstrations • Regular live meeting demos • Video channel • Trainings on BI stack over live-meeting • Onboarding process • Onboarding site and documents • Onboarding team with weekly calls • Prototyping • Proper production Support team • Questionnaires using SharePoint forms • Clickable onboarding steps • Emails to right aliases • Deployment from one environment to the next

  30. 1 • Customer empathy • Learn from mistakes • Implement feedback • Customer satisfaction surveys • Maintain customer relationship with regular meetings • Improve, improve, improve

  31. Summary of top 10 considerations we covered…

  32. Upgrade to Office SharePoint 2010 - Microsoft PowerPivot hosted solution

  33. Introducing PowerPivot PowerPivot add-in for Excel PowerPivot add-in for SharePoint

  34. Next steps to have a solution like Microsoft CBI • Solution offering is available in the US and Canada • Avanade (joint venture of Microsoft and Accenture) and/or MCS • Offers services covering technical and business scenarios • Is using it within projects • IT Showcase Technical white paper and video links

  35. For more information • Microsoft CBI IT Showcase video: http://www.facebook.com/video/video.php?v=125986687920&ref=mf • Microsoft CBI white paper and other content: http://technet.microsoft.com/en-us/library/bb735122.aspx • Microsoft IT Showcase Webcasts http://www.microsoft.com/howmicrosoftdoesitwebcasts • Microsoft BI: http://www.microsoft.com/bi • Avanade CBI: http://www.avanade.com/whatwedo/solution.aspx?id=48 http://AvanadeCutsITCosts.com/Consolidated.html • Microsoft & Avanade InformationWeek CBI Webinar: http://event.on24.com/r.htm?e=207924&s=1&k=9A24CEFF0BBEC094EDC4F0E86EF348BF Please fill evaluation form BIP05-INT

  36. Required Slide Complete an evaluation on CommNet and enter to win!

  37. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

  38. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related