Don’t expect magic from dbt and don’t expect it will fix all your problems. Instead, expect to get a stable framework that makes your project as simple as possible. The only side effect of simplification I noticed is that I face much fewer problems and the ones I encounter are usually simple to debug. Bear

If you’re data enthusiast, it’s definitely worth trying. DBT (data build tool) is relatively fresh (v. 1.2) and open-source tool that perfectly fills the gap in data engineering stack. It’s dedicated for data engineers that love to code and hate to drag-and-drop. Particularly, for analytics engineers that work somewhere between data engineers and data analysts

There is no single definition of what the data lake is. Moreover, there have been many misconceptions around the idea. To understand the concept we move back to its origins.

The concept of a data warehouse is quite old, it originates from late 1980’s. Yet, in our practice we find out the term “data warehouse” is often misunderstood. The presence of a similar term, a data lake, does not makes things easier and the two concepts are frequently confused or mixed.

In the other post on Coronavirus reporting we touched briefly the topic of dimensions. In particular we discussed about the temporal dimension. Since dimensional modelling is a basic concept in the data warehouse design it deserves a separate post. The temporal dimension is commonly used in practically every business and science domain. Time / date

The evolution of the COVID-19 coronavirus epidemic triggered an enormous interest in crunching the available data. There are plenty of data on this topic readily available, which makes this task to appear particularly easy. Both official institutions and individuals have created a number of various visualisations, of various quality and various practical usefulness. I must

The recent outbreak of Coronavirus COVID-19 has got significant impact on economy, both on global and local scale. It has already affected many business domains, directly or indirectly. The tourism sector was hit directly, but there are also decline in trade and significant challenges in manufacturing and logistics. Several major events and conferences all over

At the time of writing it is year 2019. Yes, 2019. Not 1819 – the middle of Industrial Revolution, not 1919 – when the Hours of Work (Industry) Convention was established, but 2019. It was just few months ago when we celebrated the 50th anniversary of the first man landing on the Moon. World Wide

Is the time spent in the office more productive comparing to the time worked elsewhere? Apparently not. At least not when in comes to open-space offices, by far the most popular now. There are more distractions, which means less focus. The open-space office, with its inherent noise and lack of privacy, greatly contribute to that.