Skip to main content

Posts

Showing posts from December, 2020

052: Mobile App - Part 1 - Design and Technology

This initial phase of a small Mobile App project presents motivations and goals for a new application, and  gives directions around tooling selection. The weekly mood As already mentioned some time ago, I sometimes spend my freetime riding a roadbike. And as it belongs to, I feel both the need to have pleasure and to perform. At first I enjoy good weather, beautiful landscapes and spontaneous break-aways with mates. From time to time, I also expect to make or smash the numbers, simply by pushing it to technical and mental limits where applicable. A few months ago I wrote a blog post  about recording rides using a GPS / Running watch, and analysing calculated power data from Strava segment efforts. Now, I feel the need for something to show me how I perform while riding. Since the watch doesn't show more than speed and time like a cheap bike computer, I do need some extra. However, I want to achieve this with parsimony, that is without purchasing a  Cycling power meter ...

051: Introvert Architect: Bug or feature?

Review of  Susan Cain's  book Quiet, with own additions such as my personal story and level of maturity around introversion and extroversion at work. The weekly mood Unexpectedly, I've been able to catch up with a couple of project tasks left behind during the past few weeks, and even found the time to look a bit outside the box. In his talk  and  articles  called The Architect Elevator , Gregor Hohpe defines the Architect person as a special "Animal", and the Architect role as a "Connector". The latest is not a surprising term from one of the fathers of  Enterprise Integration Patterns  (EIP). However, I find the first one intriging because it conveys that Architects belongs to a minority of people who might not allways be well accepted or understood. I recently read  Quiet: The Power of Introverts in a World That Can't Stop Talking , a very popular  Essay  by Susan Cain (2012). Although I am not used to making book reviews, I...

050: ELT with DBT

Data Build Tool (DBT) allows you to easily create and manage ELT-pipelines to automatically build and populate a target analytical model. The weekly mood Thanksgiving is over and I wish I could integrate an Advent calendar into my blog, but in this case I should have had the idea before. Therefore, let us put it to next year... perhaps. Talking about ideas, I am still puzzled on how to help my organisation becoming data-driven. Is it ok to struggle with some basic Data Warehouse implementation, or is it a shame? As a matter of fact, we need to do something, and we need to do it now. See also: Building An Analytics-Centric Organisation . Today we'll have a look at a tool that is quite popular for populating dimensional data models: DBT. What is DBT Data Build Tool (DBT) is an Open-Source CLI written in Python that is used to manage, document, test, compile, package and run compute queries on a  Data Warehouse  (DW) or a Data Lake (DL). DBT is developed by a Philadelphia-...