Categories
Business Intelligence Drupal

Drupal: Filters for External Data Views

A Drupal View that uses Views Database Connector (VDC) to show external database tables will not have all features of a “normal” View. For example, select filters are only available for list fields, references and taxonomy terms. In this post I use two modules to improve the exposed filters in my external data View. In…Continue readingDrupal: Filters for External Data Views

Categories
Business Intelligence SQL

Simplifying Lengthy SQL Scripts

Some of the scripts I have inherited or had to work on have been written by people who separate every logical step into a separate SQL statement and temp table. The longest script I have had to work on was over 20 000 lines which I managed to simplify to couple hundred lines. I frequently…Continue readingSimplifying Lengthy SQL Scripts

Categories
Business Intelligence

Whys it’s okay when your report is ‘wrong’

I don’t mind when a client tells me my report is wrong. This was not always how I felt. In over 10 years working in Business Intelligence (BI) and IT I have noticed that a considerable percentage of developers do not take kindly to being told their report/data extract/table is wrong. In some environments I…Continue readingWhys it’s okay when your report is ‘wrong’

Categories
Business Intelligence SQL

The Most Efficient Way to do Large SQL Data Extracts From Your BI Tool

No matter how many reports and cubes you build you are always going to have users who need large extracts of raw data in CSV format. Typically this data is used for analysis using tools such as Tableau, R and MS Excel. In my experience large data extracts are done by an individuals part of…Continue readingThe Most Efficient Way to do Large SQL Data Extracts From Your BI Tool

Categories
Business Intelligence

Listening to hear your clients

In my opinion “soft” skills such as the ability to listen are hardly ever mentioned as a success factor for data warehousing and BI projects. Part of the problem with BI is the broken telephone effect and to a lesser extent, the technical skills of the developers. Too much time is spent implementing the wrong…Continue readingListening to hear your clients