and a few words about me — I like writing. It helps to keep my mind and ideas in order. I started my Medium blog a year ago and I am so happy to see that my ideas have become useful for someone else, especially for those who are trying to learn and acquire new skills in…

Advanced ETL techniques for beginners — In this story I will speak about advanced data engineering techniques in Python. No doubt, Python is the most popular programming language for data. During my almost twelve-year career in data engineering, I encountered various situations when code had issues. This story is a brief summary of how I resolved…

A shortcut for beginners in 2024 — This story explains an accelerated way of getting into the data engineering role by learning the required skills and familiarising yourself with data engineering tools and techniques. It will be useful for beginner-level IT practitioners and intermediate software engineers who would like to make a career change. Through my years…

On a scale from 1 to 10 how good are your data warehousing skills? — Github On a scale from 1 to 10 how good are your data warehousing skills? Want to go above 7/10? This article is for you. Want to get ready for a data analyst job interview asap? This blog post explains some intricate data warehouse SQL techniques in detail. I will…

Tips to prepare for a job interview — This story aims to shed some light on various data engineering interview scenarios and typical discussions. It covers almost every question you might be asked and I hope it will be useful for beginner and intermediate-level data practitioners during the job interview preparation. Throughout my almost fifteen-year career in analytics…

AI-powered Business Intelligence. A hype or reality? — We live in a fascinating time when Artificial Intelligence (AI) is transforming the way we do things. This includes data pipeline design and analytics. Today I’d like to talk about how AI powers automated big data analysis and reporting. I’m sure you are familiar with Business Intelligence (BI) if you…

Difficult to code when encountering complex tasks — SQL is widely used, and data scientists (analysts) often need to use SQL to query and process data in their daily work. Many enterprises hold the view that as long as the IT department builds a data warehouse (data platform) and provides SQL, data scientists can freely query and analyze…

Readers Digest to Learn Data Engineering Gradually — In this story, I would like to talk about data engineering books and resources that might be of interest to those who learn data engineering (DE). I realised that there aren’t many of them in the market explaining data engineering as a concept holistically as a whole thing. Some of…

An End-To-End Tutorial for Beginners — In this story I will speak about one of the most popular ways to run data transformation tasks — batch data processing. This data pipeline design pattern becomes incredibly useful when we need to process data in chunks making it very efficient for ETL jobs that require scheduling. I will…