1 / 32

Democratising Business Intelligence

Democratising Business Intelligence. Rupert Nicolay Architect Microsoft Services BIN203. Session O bjectives – Answer:. What challenges can be addressed through ‘democratising’ BI? How does the Microsoft BI strategy align to these challenges?

chaka
Download Presentation

Democratising Business Intelligence

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. Democratising Business Intelligence Rupert Nicolay Architect Microsoft Services BIN203

  2. Session Objectives – Answer: • What challenges can be addressed through ‘democratising’ BI? • How does the Microsoft BI strategy align to these challenges? • How do I use what I have to make a difference now? • How does the story evolve in the next product Wave?

  3. Democratising BI - Thoughts Concept:User empowerment leads to better decisions & higher user sat with less of an IT burden?

  4. Reduced IT burden?   IT Dept.   Help!

  5. Democratizing BI – Thoughts • BI tool usage is seldom compulsory (thus more democratic than typical LOB or ERP systems) - success demands end user satisfaction. • BI remains highest priority because it enables much of what CIOs want to deliver.

  6. Democratising BI - Thoughts • Since resources are limited effective IT management of BI services remains critical. • Does IT need to retain responsibility for data interpretation & usage scenarios • Probably NOT – but we can help • If BI is to be pervasive what about the costs of the tools all these users?

  7. From Enterprise to Self Service BI • Requirement still exists for standardised, scalable, reporting. • This may require extra data transformation or sophisticated formatting that takes specific skills to achieve. • Demand continues to grow with regulatory requirements.

  8. Evolution of the Enterprise BI team • Gartner suggest a BI competency centre (‘BICC’) to integrate technologies, address org dynamics associated with competing BI priorities: • Understand the degree of governance required – low for special purpose & dept. solutions – high for corporate apps. • Like any shared service the funding model for shared BI investment is often the subject of vigorous debate. Subscription or Service based? As an overhead? • Team may be virtual or physical & change over time

  9. From Enterprise to Self-Service BI • Some form of self-service BI is likely happening now in your organisation at an individual or even possibly departmental level through some means

  10. Microsoft BI Strategy Low Total Cost of Ownership Leverage your existing Infrastructure

  11. BI in BI delivery • Can we improve Enterprise delivery to align better with the user & ‘empowered’ • Use the analysis tools we apply to our data to our process. • Make Enterprise BI more accessible, empower users in their interactions, be more responsive to demand. • Measure team effectiveness, create self-improving feedback loops. dy dx

  12. demo BI in the BI delivery process

  13. Challenges • As important as ever to balance user satisfaction with control. • Restricting delivery != control. • If Self-service requires data and IT holds the data then to what extent is self-service reliant on the data being prepared and accessible? • Data Quality • Relative to current / relative to ideal

  14. Enterprise & Dept. BI Delivery for All • Leverage the portal for delivery. • Make enterprise analysis the starting point for delivery. • Integrate semi-structured and unstructured data into the delivery. • Microsoft big-bets: SharePoint as primary delivery mechanism, Excel as primary analysis platform.

  15. demo Delivery in the Portal

  16. Web 2.0 & Democratising BI • Consume & collaborate: surface ideas and provide the means to capture otherwise tacit conclusions. • Mix structured and unstructured data. • BI & search. 

  17. demo Web 2.0 Features in BI Delivery

  18. Self-Service Data Mining • Add-in plays very much in the self-service space. • Analysts often unaware of capabilities that map to current activities. • Understand the features and consider promoting to higher-end analysts – risks are low.

  19. demo Self Service Data Mining

  20. Where are we going • Significant self-service investments across the next wave in the 1st half of next year: • Office 2010, Gemini, SharePoint 2010, SQL 2008 R2 incl. Report Builder 3.0 • Address sourcing & analysing data. • Greater detail on these in other BI sessions at TechEd – watch related items list at the end.

  21. Report Builder 3.0 • MAP support. Shape File support.

  22. Report Builder 3.0 • ‘Grab & Go’

  23. Report Builder 3.0 • Other relevant self-service call-outs: • ATOM feeds • Indicators

  24. Gemini – In Memory Analysis

  25. Gemini - Visualisation

  26. Gemini – Resource Management

  27. question & answer

  28. Required Slide Speakers, TechEd 2009 is not producing a DVD. Please announce that attendees can access session recordings from Tech-Ed website. These will only be available after the event. Resources Tech·Ed Africa 2009 sessions will be made available for download the week after the event from: www.tech-ed.co.za • www.microsoft.com/teched International Content & Community • www.microsoft.com/learning • Microsoft Certification & Training Resources • http://microsoft.com/technet • Resources for IT Professionals • http://microsoft.com/msdn Resources for Developers

  29. Required Slide Speakers, please list the Breakout Sessions, TLC Interactive Theaters and Labs that are related to your session. Any queries, please check with your Track Owner. Related Content Breakouts Creating the Right Cubes for Microsoft Office Excel and Excel Services (BIN302) Mon 3 Aug (17:15 - 18:15) Microsoft Project Code Name "Gemini": Self Service Analysis and the Future of BI (BIN201) Tue 4 Aug (13:15 - 14:15) Microsoft Business Intelligence Unplugged (BIN308) Tue 4 Aug (16:15 - 17:15) Business Intelligence Power Hour (BIN207) Tue 4 Aug (17:30 - 18:30) Taking Your Application Design to the Next Level with Data Mining (BIN305) Wed 5 Aug (09:00 - 10:00) Whiteboard Sessions Developing Microsoft BI Solutions with Microsoft SQL Server 2008, the 2007 Microsoft Office System and SharePoint Server 2007 (WTB214) Mon 3 Aug (10:45 - 11:45) How to Get Started in Business Intelligence (WTB213) Tue 4 Aug (08:00 - 09:00)

  30. Required Slide 10 pairs of MP3 sunglasses to be won Complete a session evaluation and enter to win!

  31. Required Slide © 2009 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