Blog: Tom Breur Subscribe to this blog's RSS feed!

Tom Breur

Welcome to my blog!

About the author >

Tom Breur, Principal with XLNT Consulting, has a background in database management and market research. For the past 10 years, he has specialized in how companies can make better use of their data. He is an accomplished teacher at universities, MBA programs and for the Certified Business Intelligence Professional (CBIP) program. He is a regular keynoter at international conferences.  Currently,he is a member of the editorial board of the Journal of Targeting, the Journal of Financial Services Management and Banking Review. He acts as an advisor for The Council of Financial Competition and the Business Banking Board and was cited among others in Harvard Management Update about state-of-the-art data analytics. His company, XLNT Consulting, helps companies align their IT resources with corporate strategy, or in plain English, he helps companies make more money with their data. For more information you can email him at or call +31646346875.


November 2009 Archives

PivotAt the last Microsoft BI conference in Seattle  project “Gemini” was annouced. Gemini is now available as Powerpivot (see also Powerpivot (inspired by pivot table?) allows users to analyse the data within the comfort of their Excel 2010 interface. In my experience however 99% of the data contained in an Excel sheet is often a datadump from operational systems or a datawarehouse (like) environment. Nothing wrong with that by the way. It allows users to play around with the data. But my point is that the data comes from the companies own operational systems. As most of us know (except perhaps the deaf and blind) the majority of data is to be found outside our own organizations. If you can find some way to combine your own data with relevant information from the net your quickly on your way to making smart decisions. As Rick Mans and I wrote in our recent article Samen Spelen (We are working on a English translation) the challenge is first to find the right information and than to make it manageable. So we want the slicing and dicing we do in BI classic on the web as well in combination with search. Well, Microsoft must have read our minds because they are working on something called Pivot ( It uses collections of large groups of data with a similar item and uses visualizations to find hidden patterns. Take a look at some of the demo’s and in your mind replace datasets like dogs, cars and playing cards with mortgages, prepaid customers or dairy products. I think Microsoft has taken a first step in the direction of mixing structured and unstructured data. Too bad it is still in two seperate worlds. Who knows what can happen if you mix it together. This leaves one final question. How to call such a product? Power Pivot Plus?

Posted November 19, 2009 9:46 AM
Permalink | No Comments |

Samen Spelen, Samen delen. Het lijkt een bezwerend mantra om de lieve vrede op de crí¨che te bewaren. Maar er is meer. Kinderen zijn eigenlijk continue aan het leren. Kruipen, leren lopen. Later spelen ze met lego, kralen of blokken. Het liefst doen ze dat alleen en zijn ze nog niet goed in staat om te delen. Ze houden liever alle leuke dingen voor zichzelf. Langzamerhand ontdekken kinderen echter dat spelen ook kan met andere kinderen. Maar dat betekent ook speelgoed delen. Dat gaat eerst nog gepaard met tranen maar later ontdekken kinderen dat samen spelen goed kan samengaan met samen delen. Sterker nog, het wordt steeds leuker zo samen. En voor je het weet, heb je een beste vriend of vriendin. Als volwassene is de wereld niet vaak niet veel anders. Wij vinden het ook soms moeilijk om ons speelgoed te delen. Laat staan bedrijfsgegevens of vergaande analyses. Maar ook hier blijkt weer groot voordeel te behalen. In dit artikel wordt ingegaan op de rol van bedrijfsinformatie (of business intelligence) en welke rol externe sociale netwerken (Internet Social Media) kunnen spelen bij het nemen van beslissingen. Wellicht zal een manager in de toekomst niet veel meer hoeven doen dan interne data te publiceren op het net en $50 te bieden voor de beste synthese.


 Samen Spelen, Samen Delen

Posted November 18, 2009 10:24 AM
Permalink | No Comments |

I have written an article with Rick Mans on BI and Social Media. It was published on the BI platform ( Article is in Dutch.

Posted November 16, 2009 10:21 AM
Permalink | No Comments | was interviewed by Hans Lamboo (Database Magazine, BI platform) on the development of BI.Interview is in Dutch.

Posted November 16, 2009 10:18 AM
Permalink | No Comments |

Posted November 4, 2009 8:54 AM
Permalink | No Comments |

IT budgets are down. That’s a fact that nobody can deny. At the same time the need for relevant information has increased considerably. That is another fact. As a result IT is reconsidering its position whilst the business is waiting for the much needed report or analysis. This need for faster time to information and less IT involvement has given rise to something that is often called Business or Self Service Reporting (SSR). Traditionally BI reports are created by the IT department. SSR allows business users to do this for themselves.


This might sound like a radical new way of delivering information but it is nothing new. Gartner for example has always placed the Report writing function in the business part of the BICC. What is different now is that the tools have become more intuitive and easy to work with. Business users, albeit power users, can build their own reports with a relative ease. IT responsibilities for SSR are limited, or should I say focused, on delivering the quality data on time. Which is not bad considering the lower budgets. Another great thing about letting business user build their own reports is that it improves the quality of the requirements (no more misunderstandings) and the setting of priorities (they will probably build what the need the most first). So it really sounds like a win-win situation and often it is just that. But... there is a down side to this as well.


By spreading the report function across various lines of business a dilution of knowledge arises which is often strengthened by the information silos that are created. In a way it is back to the old days with the business (intelligence) silos across the company. Did I hear somebody say: single version of the truth? But the IT department has also a hard time in monitoring the use of the report function and keeping the performance on an acceptable level.


So how can we do something to solve these problems? One way is to make the SSR a little bit more IT monitored by setting up a ‘managed’ self service environment. That is something Microsoft has done. Another solution would be to create an organization structure to support these changes. This would be something like a BICC but more business orientated. Let’s call it a BI Service Center or BISC. A third possibility would be to limit the SSR to a certain kind or reporting. When there is a need for fast time to information or when there is a high need for business involvement SSR is the way to go. All other reports are created in some sort of central function. A hybrid solution can even arise where personal or self service reports become centrally maintained standard reports in time, thus solving the single version challenge.


Self Service Reporting can be a great thing. It will decrease the time to information for many people which is much needed in these roaring times. However SSR must always be implemented and positioned in a way that its benefits will not create concerns for others involved. Always keep the impact of SSR on your information architecture in mind while seeking for quick solutions. 

Posted November 2, 2009 10:20 AM
Permalink | No Comments |