First Level Trade-Off to select the right storage for your needs


Every time you start a new project, the question arises as to which data platform and data storage to choose. There is a big variety of storages to choose from. Each option has different features, advantages, and disadvantages. It is really time-consuming to puzzle over trade-off analysis.

The purpose of…

Making Sense of Big Data

Set of Best Practices (dis)proved by Benchmarking


The market of MPP engines is pretty broad and the cloud big players have their offerings that constantly evolve. So it’s really interesting to have a better understanding of their capacities and how they perform.

Let’s review Azure’s Synapse Dedicated SQL Pool MPP database platform, which is the evolution of…


Invented by F. Puppini and promoted by B. Inmon it pretends to be a revolution in Self Service BI


Recently I accidentally came across the new book of Bill Inmon and Francesco Puppini called “Unified Star Schema” (will refer to it USS downstream). Having a new book in 2020 from the father of data warehousing definitely grabbed my attention, I bought it and read it in the following 3…

Making Sense of Big Data, BigData Modeling Patterns

How to model hierarchies in NoSQL leveraging the best practices from the relational world


Sometimes we come across cases when we need to model a hierarchy of different complexity levels and not really sure how to do that properly in the most efficient, reliable, and flexible way. Let’s review one of the data modeling patterns that give us some answers for that.

Problem Statement

Consider we…

Best Practices of DW Modelling applied on IoT data for most flexible and efficient analytics


This is a continuation of the previous part, where there was described a problem statement related to the analysis of IoT data on the example of fitness tracking activities. There were also described the reasoning behind the storage type selection and recommended to have 2 types of storages:

  1. Big data…

Andriy Zabavskyy

Big Data Architect & Data Warehouse Expert at SoftServe Inc.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store