SEARCHING: Boost a search term

September 25, 2012

BI24 provides the relevance level of matching documents based on the terms found. To boost a term use the caret, “^”, symbol with a boost factor (a number) at the end of the term you are searching. The higher the boost factor, the more relevant the term will be.

Boosting allows you to control the relevance of a document by boosting its term. For example, if you are searching for “Manchester” or “Pie” and you want the term “Manchester” to be returned towards the top of the document list, using the ^ symbol along with the boost factor next to the term. You would type:

This will make documents with the term Pie appear at the top of the document list.

You can also boost grouped terms;

SEARCHING: Grouping Syntax and Queries

September 25, 2012

BI24 supports using parentheses to group clauses to form sub queries. This can be very useful if you want to control the Boolean logic for a query.

To search for either “beef” or “chicken” and “London”, use the query:

This eliminates any confusion and makes sure you that “London” must exist and either term “chicken” or “beef” may exist.

SEARCHING: Proximity Searches

September 24, 2012

You can use BI24 to find words that are separated by a specific number of words in a document. To do this, type the tilde (“~”) symbol at the end of a phrase followed by the number of words that separate those two words.

For example to search for a “Thin” and “Pizza” within 4 words of each other in a document use the search:


SEARCHING: Wild Card Searches

September 24, 2012

BI24 supports single and multiple character wild card searches;

? Symbol for a single character wildcard search.

* Symbol for a multiple character wildcard search.

The single character wild card search looks to replace the wild card character with a single character in the search string. For example, if you wanted to find records for postcode sub areas ‘BS1 3EZ’ and ‘BS1 3ET’, you could enter for BS1 3E?

Multiple character wild card searches look to replace the wild card character with zero or more characters in the search string. For example, if you wanted to find records for the branches ‘Falkirk’ and ‘Falmouth’, you could enter for Fal*

The results returned are;

SEARCHING: Combining Search Terms

September 24, 2012

Combining search terms will provide you with a more focused set of results. – For example if you want to find the Chicken products in Birmingham, you could enter chicken birmingham:

Any records that contain the word ‘Chicken’ AND ‘Birmingham’ in any column or field will be returned and BI24 will highlight where a match is made in the record.

If you want to have the combined search term preference changed to find ‘Any’ terms (OR) rather than ‘All’ terms (AND), see Section 11 on Setting BI24 Preferences.

SEARCHING: Exact Match

September 24, 2012

Entering the exact name of the item you want to search for is an obvious place to start. For example if you’re looking for information about chicken products, type chicken in the search field then click the Search button:

Any records that contain the word ‘chicken’ in any column or field will be returned and BI24 will highlight where a match is made in the record.

Data Visualization- The Medium is the Message

March 2, 2012

Marshall McLuhan‘s enigmatic phrase – medium is the message-  from the sixties gives him credit for predicting the World Wide Web 30 years ago.  He could have just as well have been talking about Data Visualisation for Business Analytics. While information management technology has grown at a blistering pace, the human ability to process and comprehend numerical data has not.

Visualization opens up the channel of communication between the technologists who create the data and the business people who act upon it.  Data visualization tools, such as mashups, executive dashboards, KPI and performance scorecards and other data visualization technology, are becoming more popular and necessary to deal with mind numbing charts and exponential data growth.

However, the C-Suite has heard about the promise of dashboards and interactive scorecard for a few decades now and is typically dissatisfied with what they get from IT and the speed at which they get it. The big difference is that visualization technologies have finally advanced to a level where they can give actionable intelligence to the right people at the right time at the right place.

Lets take for instance an a mobile BI solution using a tool such as an Apple iPad. This gives the business executive the ability to manipulate the data with the ease of reading an e-book.  The visualization library that you can draw upon to create an interactive experience on the iPad includes:

Bi24 data visualisation

There are three critical business requirements addressed by such a solution. These are:

1) Ease of Use:Pictures and graphs are easier to read than numbers and more insightful than words on a page. The picture of the water levels from the recent tsunami shown in this posting can communicate more information than any seismic data chart.

2) Interactivity – Business users want the ability to change parameters and do their own queries but are loath to get on a keyboard to do write a query and would rather not go through discussion cycle an IT manager to look at data in a different way.

3) Mobility – Any time any place access is a fundamental need of the modern business environment. The wide-scale adoption smartphones and tablets provides an ideal platform to carry out this requirement.

We predict that mobile BI using visualized data which is easy to manipulate will be a giant step in aligning IT with business in 2011. A picture transcends language barriers and communication challenges across organizational silos more effectively than any form of numerical data.

There are those who argue that the emphasis on visualization (simplicity) minimizes the advanced technology that is a bulk of the work in information management. All the work that goes on in processing data is of no value if it cannot support a better business decision. The visualized data is all that matters. The tip of the iceberg is the iceberg.

Thanks to Shirish Netke

%d bloggers like this: