Categories
Drupal SQL

Drupal: Using Views Database Connector (VDC) To Display Data in External Database

Apart from Drupal most organisations may have many systems such as a CRM, HR and e-commerce system. The field of Business Intelligence (BI) deals with bringing disparate data sources into a single data warehouse(DW). If you wanted to display data from your DW using Drupal, the Views module is a good place to start. Before…Continue readingDrupal: Using Views Database Connector (VDC) To Display Data in External Database

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

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

Categories
Business Intelligence Open Source SQL

Open Source SQL Editors

UPDATE-6 July 2020: I have updated this post to be the landing page for all my posts on Open Source SQL Editors. There are many aspects of SQL editors that I will post in separate and probably smaller posts. Introduction Working in Business Intelligence (BI), I write and execute SQL statements every day. Actually it…Continue readingOpen Source SQL Editors

Categories
SQL

Pivoting data in SQL

Most pivoting of data is done outside of the relational SQL databases. Relational databases are rigid and the variable number of columns in a pivot table is not something that goes hand in hand with the rigid structures defined in relational database. Pivot tables make some data just that much easier to work with. A…Continue readingPivoting data in SQL