“Poli is an easy-to-use SQL reporting application built for SQL lovers!” Poli isn’t a fully fledged BI tool. In my experience Poli is enough for sizeable chunk of BI users. I often find alot of features in sophisticated BI tools are not used. Poli is simple to get started. Within a couple of hours you…Continue readingInstall Poli As service using Systemd
Category: Business Intelligence
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
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
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’
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