Loading in 2 Seconds...
Loading in 2 Seconds...
SharePoint Search Tips and Tricks Power User Search in SharePoint 2013. Joel Oleson Director Enterprise Search Strategy BA Insight @ joeloleson http://collabshow.com. Who Am I?. About Joel Oleson Director of Search Strategy, BA Insight First SharePoint admin Top social media influencer.
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.
SharePoint Search Tips and TricksPower User Search in SharePoint 2013 Joel Oleson Director Enterprise Search Strategy BA Insight @joeloleson http://collabshow.com
Who Am I? • About Joel Oleson • Director of Search Strategy, BA Insight • First SharePoint admin • Top social media influencer • Passionate About • Search • SharePoint • Search-based applications • Community • Travel Connect @joeloleson CollabShow.com TravelingEpic.com Microsoft’s go-to ISV for Enterprise Search Focused on Search and SharePoint since 2004 Search Industry Leader
Agenda • End User Search Tips for SharePoint • Building the Business Case for Enterprise Search • Real World Value in SharePoint Search Case Studies • Wrap up and Q&A
“We live in the age of Data Explosion, Big Data is our reality and Findability is the key competitive advantage any leading organization will have…
Killer Apps are Search Apps • Consumer search experience sets a high bar for search user experience Enterprise search projects often fail because they do not meet users’ expectations and do not deliver a remarkable user experience.
71% percent of Company executives say Search is VITALor Essential to their day to day business…Why do only 18% have cross repository search capabilities?- AIIM 2014 Findability Survey
Word, Words vs. Phrase Boolean Inclusion and Exclusion Proximity Search Tips
Search User Tips • Free Text Queries • Word • Multi word (default will AND words) • Phrase (in quotes)
Boolean • AND (Require) Narrow your search results. • mice AND men • OR (Include) Expand your search Results • Mice OR Men • NOT (Exclude) • mice NOT cats • Case sensitivity Matters - Boolean operators must be capitalized!
Inclusion and Exclusion Operators • “+” includes content that match the inclusion (same as AND) • “-” excludes content that match the inclusion (same as NOT) • Whitespace matters. Be sure to use quotes for phrases • -john smith is not the same as –”john smith”
Proximity • Proximity: NEAR where words are near each other • Mice NEAR men • Syntax • NEAR: <expression> NEAR(n=4) <expression> • Mice NEAR(n=4) Men • ONEAR: Preserves word order • <expression> ONEAR(n=4) <expression> • Mice ONEAR(n=4) Men
Parenthesis: Building Complex Queries • Use parenthesis to explicitly indicate the order of computation for KQL queries • Combine different parts of a keyword query by using the opening parenthesis character "(" and closing parenthesis character ")". • Each opening parenthesis "(" must have a matching closing parenthesis ")“ • A white space before or after a parenthesis does not affect the query.
KQL – Keyword Query Language • KQL is on by default, but FQL Fast Query Language is not. • (mice AND men) OR (cats NOT dogs) • Case in terms doesn’t matter • (UX OR user-experience OR “user experience”) AND “SharePoint 2013” • (warehouse OR warehousing OR san OR nasOR storage) • (.NetAND (VS OR “Visual Studio”) AND (VB or “Visual Basic” OR VB.net) AND (C# or C#.net ) AND “SQL Server”) NOT (designer OR “IT Pro”) • cto OR “chief technical officer” OR “cio” OR “chief information officer” OR vpOR “vice president” OR svpOR “senior vice president”
KQL – Keyword Query Language • A KQL query consists of one or more of the following elements: • Free text-keywords—words or phrases • Property restrictions • You can combine KQL query elements with one or more of the available operators
Quiz… What is the difference • Social media • Social AND Media • “Social Media” • Social NEAR media
Quiz • Which ones are the same? • Dogs or Cats • dogs or cats • dogs OR cats
Dashes, Underscores or Spaces… • If you are using SharePoint Foundation, underscores are NOT a valid word breakerSundance_Film_Festival.docx and you search for the word Film, you will not find your document. • All other versions of SharePoint, underscores ARE a valid word breaker - Sundance_Film_Festival.docx search Sundance, Film or Festival and get document. Sue Hanley – http://www.networkworld.com/article/2222853/microsoft-subnet/10-essential-sharepoint-search-hints.html
Meaningful Titles, Folders, Sites & File Names • File names and titles are very important metadata attributes. By default, SharePoint search results prominently feature the Title of a document and is almost Top for Rank. • If Title is blank, results feature the file name • Do NOT "smush" words together without a separator in file names or titles for documents. If you do, the search engine won't recognize the separate words.
Wild Card Search • The * Star or Astrisk can be used to expand your search or for unknown spelling • "micro*" finds documents that contain "Microsoft" or "microchip" • Use on last term. Don’t use * at the beginning of a search query *soft will NOT return Microsoft.KQL queries don’t support suffix matching. • Combine with phrasing for powerful search • Ex. “john de*” is better than John De* • Stemming & Wildcard is on by default in 2013, but not turned on in 2010. • Default Search sorted by Relevancy
If the product can’t be found, does the product exist? If the feature can’t be found, does the feature exist?34 percent of the sites don’t return useful results when users search for a model number or misspell just a single character in the product title.”- 2014 study by BaynardInstitute
Quiz… • You don’t know how to spell the last name… • You don’t know how to spell the first name…
Search Tips Cont. • Property Search • author:"William Zuckermann“ • Filetype:pptx • filename:”search” • title:”search” • Property Operators :=<>.. • Keyword Query Language (KQL) to enter advanced queries directly in the search box, like this: ("wind farms" OR "solar panels") AND (title:"innovations" OR title:"technologies")
Is Metadata more powerful than content?Stewart Baker, former general counsel of the NSA, said last year: "Metadata absolutely tells you everything about somebody's life. If you have enough metadata, you don't really need content."
Property Operators • = (equal) Returns search results where the property value is equal to the value specified in the property restriction. • : (colon) matches individual terms in the property value that is stored in the full-text index • < less than >greater than when used with date based operators • .. Elipse example A..B where they fall between values
What’s wrong? What will happen? author: "John Smith" author :"John Smith" author : "John Smith"
Query Custom Managed Properties • Property can be retrieved using KQL when the Managed Property Keyword Retrievable property is set to true for a managed property. • Configure your Managed Property to include content from crawled properties. • company:"Adventure Works"
Quiz • What is the difference between these searches? • title:sharepoint search strategy • title=sharepointsearch strategy • title=“sharepointsearch strategy” • title:“sharepoint search strategy” • Title:”SharePoint Search*” • Title:sharepointtitle:strategy
Gotchas • Is anything wrong with this? • Filetype:xls AND budget • Filetype:ppt and “search strategy” • SharePoint will auto OR for same property • Author:MarkAuthor:Cindy • Plus and Minus work, but don’t use them together… • Character length limit: 2,048
XRANK • Advanced parameters typically they're not used. • The cb parameter refers to constant boost • The stdb parameter refers to standard deviation boost • The rb parameter refers to range boost. This factor is multiplied with the range of rank values in the results set • The pb parameter refers to percentage boost. This factor is multiplied with the item's own rank compared to the minimum value in the corpus. • All items containing the term "animals", and boosts dynamic rank for cats over dogs • (animals XRANK(cb=100) dogs) XRANK(cb=200) cats
Searches Need to be Precise for Best Results Give me a search box and I will formulate my own query to find it “sales forecast” OR (“sales“ NEAR “forecast”) AND (author:”WilliamZuckermann") AND (format:”XLS”) OR (format:”XLSX”) search Users with a combination of high technical / high domain expertise will achieve the best search results.
Eliminate Noise from Queries The New Role of Taxonomy – Noise Reduction
Key Takeaways • SharePoint Enterprise search is the right investment • Search is the killer app… • Know your users – Context is everything • You MUST have a metadata strategy • UX including visual refinement is essential
Questions! Let’s make Search the next enterprise killer app. Joel.Oleson@bainsight.com @joeloleson
Search Tips References • SharePoint Search Help http://office.microsoft.com/client/15/help/home?Shownav=true&lcid=1033&ns=SPOSTANDARD&helpID=SearchTips&ver=16 • Keyword Query Language (KQL) Syntax Reference http://msdn.microsoft.com/en-us/library/ee558911(v=office.15).aspx • Property Restriction Keyword Queries http://msdn.microsoft.com/en-us/library/office/ff394509(v=office.14).aspx • Building Search Queries in SharePoint 2013 http://msdn.microsoft.com/en-us/library/jj163973(v=office.15).aspx • Plan End User Search Experience http://technet.microsoft.com/en-us/library/cc263089.aspx • Tips for Effective Queries http://office.microsoft.com/en-us/sharepoint-server-help/tips-for-effective-searches-HA010241114.aspx#BMha10241114_sectipsonpropertiesinsearc
Questions! Contact me... Joel.Oleson@bainsight.com @joeloleson