“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
Tag: bi
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
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’
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
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