1 / 40

Improving Business Intelligence with Search

Required Slide. SESSION CODE: BIO206. Improving Business Intelligence with Search . Jeff Fried Senior Technical Product Manager Microsoft Corporation Joe Wallace Senior Lead Program Manager SharePoint BI . Topics. Convergence of Search and Business Intelligence

lark
Download Presentation

Improving Business Intelligence with Search

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 SESSION CODE: BIO206 Improving Business Intelligence with Search Jeff Fried Senior Technical Product Manager Microsoft Corporation Joe Wallace Senior Lead Program Manager SharePoint BI

  2. Topics • Convergence of Search and Business Intelligence • Overview of FAST Search Server 2010 for SharePoint • Overview of Business Intelligence in SharePoint Server 2010 • BI Indexing Connector – Capabilities and Demo • BI Indexing Connector – Architecture and Administration • Summary

  3. Search and BI are converging Text Analytics Business Intelligence Repetitive Access Enterprise Search Data Visualization Ad Hoc Unstructured Structured Information

  4. Search learns from BI, and BI learns from Search

  5. Ways to Use Search and BI Together • Text Analytics • ‘search technology’ serves as a content preprocessor for BI technology. This includes text mining, semantic analysis, sentiment detection, and much more. • Search Analytics • applying BI to outputs of search. This includes analysis of search behavior and performance, search results visualization, and search engine optimization. • Unified Information Access • combining search and BI elements into one system, including report finders, query preprocessors, unified view systems, hybrid databases, and search-based datamarts

  6. Microsoft SharePoint 2010The Business Collaboration Platform for the Enterprise and the Internet Sites Deliver the Best Productivity Experience Composites Communities Cut Costs with a Unified Infrastructure Insights Content Rapidly Respond to Business Needs Search

  7. Topics • Convergence of Search and Business Intelligence • Overview of FAST Search Server 2010 for SharePoint • Overview of Business Intelligence in SharePoint Server 2010 • BI Indexing Connector – Capabilities and Demo • BI Indexing Connector – Architecture and Administration • Summary OSP206 Getting to know FAST Search Server 2010 for SharePoint

  8. Introducing FAST Search for SharePoint A new choice for enterprise search that eliminates compromise Productivity Search Experience Search Driven Applications A Single, Cost-effectiveInfrastructure

  9. OOB Search Experience FAST Search for SharePoint Demo

  10. Deep Refinement Enables precise control of results Enables conversational experience You will never miss any content; enabling better findability and exploration across the entire result set Sorted by frequency Exact Counts Provides a sorted view Each refiner is sorted by frequency, from highest to lowest, indicating the importance of each term Contains exact counts Leads to discovering non-obvious relationships, key data trends, and deep analysis of your content

  11. Discovery: Find and Explore Microwave ovens Viagra LSD Corn Flakes Uranus Safety glass Inkjet printers Infrared radiation Chocolate chip cookies Penecillin

  12. SharePoint Server(s) Search Architecture – FAST Search for SharePoint FAST Server(s) … … Other Server(s) Format Conversion Lemmatization EntityExtraction Language Detection Mapper Content Processing Pipeline Content OpenSearch Query Processor Indexer Content Processor Crawler ifilters Federation People Search Search Center User Profiles Index Partition

  13. Process content with advanced linguistics Automatic and detailed analysis creates a great search experience • Breaks down content to the smallest addressable chunks to build meaning • Understands file encoding, data formats, and written languages • Supports 400+ file formats, 80+ languages FAST Content Processing Pipeline

  14. Turn information into business outcomes through engaging experiences. Social Connect and collaborate to apply your talent more effectively Conversational Change how you interact with information, giving you better answers Visual Help you identify patterns and discover new insights ContextualTailored to your role, task, and perspective, making you more productive

  15. Topics • Convergence of Search and Business Intelligence • Overview of FAST Search Server 2010 for SharePoint • Overview of Business Intelligence in SharePoint Server 2010 • BI Indexing Connector – Capabilities and Demo • BI Indexing Connector – Architecture and Administration • Summary BIO19-INT Using the Microsoft Business Intelligence Stack

  16. 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

  17. BI in Microsoft SharePoint 2010 Business Insights For Everyone

  18. Microsoft SharePoint 2010 The business collaboration platform for the enterprise and the web INSIGHTS Business Connectivity Services PerformancePoint Services Excel Services Excel Services Visio Services Reporting Services Business Connectivity Services Reporting Services

  19. What is Excel Services? • Real-time, interactive, end-user BI reporting tool • Displays all or targeted elements of Excel workbooks through the browser • Application Development platform for building data-centric applications • Automate workbooks via Web Services API • Provide highly interactive application via JSOM • Easily distribute Excel content via REST BIU06-INT | Microsoft Excel and Excel Services 2010: Top 10 Things You Need to Know for Business Intelligence BIO02-INT | Creating Custom Solutions with Excel Services

  20. End User Experience Excel Services 2010 with PowerPivot Demo

  21. Your Workbooks in the Browser • Load more workbooks with improved support for features • Rich fidelity with Excel 2010 • PowerPivot workbooks for self-service access to unlimited data BIU01-HOL | Creating Reports with Microsoft PowerPivot for Microsoft Excel 2010 BIE401 | Deep Dive on PowerPivot Technologies

  22. PerformancePoint Advanced Dashboards Scorecards Analytics Maps Data linked images Search Advanced Filters Predictive KPI’s

  23. Reporting Services SharePoint Integration Deep integration with the Microsoft SharePoint Technologies • Reporting Services functionality exposed through SharePoint UI • Central report delivery and management through SharePoint • Web parts for rendering reports directly in SharePoint for thin portal experience • SharePoint collaboration and workflow capabilities combined with rich reporting • Shared security principles across Reporting Services and SharePoint • Data Driven Subscriptions supported with SQL Server 2008 R2

  24. Topics • Convergence of Search and Business Intelligence • Overview of FAST Search Server 2010 for SharePoint • Overview of Business Intelligence in SharePoint Server 2010 • BI Indexing Connector – Capabilities and Demo • BI Indexing Connector – Architecture and Administration • Summary

  25. BI Indexing Connector • Add-in to FAST Search Server for SharePoint • Query and Crawl excel, powerpivot, and SRSS reports • Improve relevance and search across all documents • Dedicated Reports tab

  26. End User Experience BI Indexing Connector Demo

  27. Search Refiners applied to Business Intelligence Dimension/ Data Refine Pick Specific Objects Filter by Data Source Name

  28. Detailed Info on Reports Location of Search Term Open in Context Report Preview

  29. Topics • Convergence of Search and Business Intelligence • Overview of FAST Search Server 2010 for SharePoint • Overview of Business Intelligence in SharePoint Server 2010 • BI Indexing Connector – Capabilities and Demo • BI Indexing Connector – Architecture and Administration • Summary

  30. Architecture Overview SharePoint WFE SharePoint Crawler FAST Server BI IFilter Office IFilter IFilter interface Unmanaged binary Original Office IFilterdll appended with detailed information Managed Service BI Search Manager Communication using Socket Filters Processors Managed Windows Service hosting filter BI Filters Pre-Processors Data Sources used by Excel Pivot tables or Report Services reports

  31. SharePoint Server - Administration Search site Business Intelligence Indexing Connector Feature • Create Extended Search Site Collection • Deploy BI Indexing Connector feature • Activate BI Indexing Connector feature • Note: Activate on a Extended search site

  32. Topics • Convergence of Search and Business Intelligence • Overview of FAST Search Server 2010 for SharePoint • Overview of Business Intelligence in SharePoint Server 2010 • BI Indexing Connector – Capabilities and Demo • BI Indexing Connector – Architecture and Administration • Summary

  33. Summary • BI and Search are Converging • NEW offerings in 2010 combine to accelerate BI • SharePoint Server 2010 • FAST Search for SharePoint • PowerPivot • BI Indexing Connector • Report Center that’s easy to deploy and use

  34. People Ready Business Intelligence Analytics Collaboration Visualization Data Integration Query andReporting, Dashboardsand Scorecards Predictive Analyticsand OLAP Analysis PersonalProductivity MetricsManagement

  35. 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

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

  37. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

  38. Q&A jeff.fried@microsoft.com joewa@microsoft.com

  39. © 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.

  40. Required Slide

More Related