improving business intelligence with search
Download
Skip this Video
Download Presentation
Improving Business Intelligence with Search

Loading in 2 Seconds...

play fullscreen
1 / 40

Improving Business Intelligence with Search - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Improving Business Intelligence with Search' - lark


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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
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
search and bi are converging

Search and BI are converging

Text

Analytics

Business

Intelligence

Repetitive

Access

Enterprise

Search

Data

Visualization

Ad Hoc

Unstructured

Structured

Information

ways to use search and bi together
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
microsoft sharepoint 2010 the business collaboration platform for the enterprise and the internet
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

topics1
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

introducing fast search for sharepoint
Introducing FAST Search for SharePoint

A new choice for enterprise search that eliminates compromise

Productivity Search Experience

Search Driven Applications

A Single, Cost-effectiveInfrastructure

oob search experience

OOB Search Experience

FAST Search for SharePoint

Demo

deep refinement
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

discovery find and explore
Discovery: Find and Explore

Microwave ovens

Viagra

LSD

Corn Flakes

Uranus

Safety glass

Inkjet printers

Infrared radiation

Chocolate chip cookies

Penecillin

search architecture fast search for sharepoint

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

process content with advanced linguistics
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

slide14

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

topics2
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

microsoft business intelligence get more out of products you already own
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

bi in microsoft sharepoint 2010
BI in Microsoft SharePoint 2010

Business Insights

For Everyone

microsoft sharepoint 2010 the business collaboration platform for the enterprise and the web
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

what is excel services
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

end user experience

End User Experience

Excel Services 2010 with PowerPivot

Demo

your workbooks in the browser
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

slide22

PerformancePoint Advanced Dashboards

Scorecards

Analytics

Maps

Data linked images

Search

Advanced Filters

Predictive KPI’s

slide23

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
topics3
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
bi indexing connector
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
end user experience1

End User Experience

BI Indexing Connector

Demo

search refiners applied to business intelligence
Search Refiners applied to Business Intelligence

Dimension/

Data Refine

Pick Specific Objects

Filter by Data Source Name

detailed info on reports
Detailed Info on Reports

Location of Search Term

Open in Context

Report Preview

topics4
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
architecture overview
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

sharepoint server administration
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
topics5
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
summary
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
people ready business intelligence
People Ready Business Intelligence

Analytics

Collaboration

Visualization

Data Integration

Query andReporting,

Dashboardsand Scorecards

Predictive Analyticsand OLAP Analysis

PersonalProductivity

MetricsManagement

resources

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
slide36

Required Slide

Complete an evaluation on CommNet and enter to win!

slide37

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

slide39

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

ad