Improving business intelligence with search
Download
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


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

  • 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 Intelligence experiences.Get 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 experiences.

Business Insights

For Everyone


Microsoft sharepoint 2010 the business collaboration platform for the enterprise and the web
Microsoft SharePoint 2010 experiences.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? experiences.

  • 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 experiences.

Excel Services 2010 with PowerPivot

Demo


Your workbooks in the browser
Your Workbooks in the Browser experiences.

  • 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


PerformancePoint Advanced Dashboards experiences.

Scorecards

Analytics

Maps

Data linked images

Search

Advanced Filters

Predictive KPI’s


Reporting Services SharePoint Integration experiences.

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

  • 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 experiences.

  • 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 experiences.

BI Indexing Connector

Demo


Search refiners applied to business intelligence
Search Refiners applied to Business Intelligence experiences.

Dimension/

Data Refine

Pick Specific Objects

Filter by Data Source Name


Detailed info on reports
Detailed Info on Reports experiences.

Location of Search Term

Open in Context

Report Preview


Topics4
Topics experiences.

  • 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 experiences.

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

  • 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 experiences.

  • 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 experiences.

Analytics

Collaboration

Visualization

Data Integration

Query andReporting,

Dashboardsand Scorecards

Predictive Analyticsand OLAP Analysis

PersonalProductivity

MetricsManagement


Resources

Required Slide experiences.

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


Required Slide experiences.

Complete an evaluation on CommNet and enter to win!


Sign up for Tech·Ed 2011 and save $500 experiences.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


Q&A experiences.

[email protected]

[email protected]


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


Required Slide experiences.


ad