SQL is a powerful data manipulation language (DML) that can be used to perform complex calculations and format data within your database. The Views Raw SQL module enables you to use SQL on your fields in your Drupal view. This is useful when using Drupal as a data platform for reports and data analysis from…Continue readingUsing SQL in Drupal Views Fields
Tag: business intelligence
A few years ago then Google CEO Eric Schmidt was quoted as saying, “There was 5 exabytes of information created between the dawn of civilization through 2003, but that much information is now created every 2 days, and the pace is increasing”. The great volumes of data available for analysis have necessitated the development of…Continue readingConditional Formatting of Data In Drupal Views
Categories
Defining Drill Downs in Drupal Views
The logical way to analyse data is to start by looking at summarised data before looking at the detail. This is referred to as drilling down. In this post I demonstrate how to define drill down functionality between two Drupal Views. This is a continuation on my series of posts showing how Drupal can be…Continue readingDefining Drill Downs in Drupal 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
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’