Passionned Group™

Increase the hits on your data warehouse with Google

Data warehouses typically contain quite a lot of content. Let us assume, for convenience sake, that much of this content is relevant and reliable. This is often not (yet) the case, but fine, we want to address another issue here, namely that the user cannot find information even though it is available in the right quality.

Deliver information to the user

Checklist: find out what is the reason for this

I myself have once examined what the reason for this could be and have compiled a preliminary list:

Our huge appetite for good information is understood by Google

Google has understood like no other how we people want to deal with our huge appetite for good information. The company offers ease of operation, fast results and excellent guidance (help, suggestions, alternatives; automatically correcting spelling errors). I personally find searching with Google a pleasant experience.

Google cannot do a lot for the first two points and the last point from the above list. However, it can be a great help with the other four.

Connect Google directly to your data warehouse

I want to make a plea for connecting Google ‘directly’ to your data warehouse and business intelligence system. This can be at the report level (document), by chart or table, or perhaps even by fact. The more detailed information Google can disclose, the better the results can be. Furthermore, nowadays many of the better (enterprise) BI tools can handle Google’s requirement pretty well (for example Power BI and Qlik). I have only come across a few implementations where this functionality is applied and that is a pity.

Visitor numbers will rise

You will be surprised to see that the visitor numbers of your data warehouse increase significantly, as well as the number of hits. Metadata then becomes more important than ever, otherwise we cannot apply a number of important techniques and principles for search engine optimization. Think about: key words, description and title. However, we will also need to provide the appropriate tags for each record and attribute in the data warehouse itself, both at detailed level and at aggregate level (scripts can be written for this).

What profit can you gain with this?

You might be wondering what the profit of this could be? A few examples may clarify this.

The big advantage is that the user does not need to log into a system; almost never has to wait long for an answer; he is helped in his search for relevant information from that time; He is presented with alternatives; and external and internal management information can be combined.

Asking computers questions with natural language

The problem in connecting Google to the data warehouse no longer lies so much in the fact that Google should be able to understand your question. Of course, natural language is a phenomenon that is not easily captured in a structure. However, there has been so much research done on it that it seems to be only a matter of time before we can ask computers reasonably good questions while using natural language.

Where is another big challenge?

Where I think there is still a really big challenge, is in the converting of ‘all’ information in the data warehouse to indexed web pages with images. These web pages have to be strongly interlinked with each other and neatly laid out, actually just as it is good practice to do this on ‘normal’ web pages. The user can click through to related issues directly from the page and be quickly informed. After all, we want to be able to serve the user properly on the data warehouse website.

Will we continue to muddle with pixel-perfect reports?

The big question is whether the market is going in this direction. Or will we continue to mess about with building inflexible pixel-perfect reports and rigid dashboards. Time will tell, but the dynamics can sometimes become so powerful that only ease of use and speed can save us.

A selection of our customers

Become a customer with us now

Do you also want to become a customer of ours? We are happy to help you with data-driven working or other things that will make you smarter.

Daan van Beek - Business Partner


Business Partner

Contact me directly

Fact sheet

Number of organizations serviced
Number of training courses
Number of participants trained
Overall customer rating
Number of consultants & teachers
Number of offices
Number of years active