joel.fail

The stories of my failures

Data Engineering

Work-around for Id columns in Dimensions using Synapse Serverless SQL engine

Azure Synapse is one of the latest flagship tools for analytics within the Azure Cloud. Synapse analytics is an all-in-one platform for data integration, processing, data warehousing and analytics. Azure Synapse is very cost efficient and highly advised for small to middle companies to start their BI landscape. However Synapse has some peculiarities, one of […]

Work-around for Id columns in Dimensions using Synapse Serverless SQL engine Read More »

Each problem has different approaches

Last day on LinkedIn, I saw a post in my feed about a woman who was making her transistion into the BI field. In this particular post she posted her solution to a LeetCode problem, the original problem is this one here: https://leetcode.com/problems/second-highest-salary/description/ As you saw, the problem consisted of retrieving the second highest salary

Each problem has different approaches Read More »

Using mini dimension for fast-changing attributes

Introduction This blog post will be about the use of mini-dimensions for fast-changing attributes, also known as the type 4 slowly changing dimension. Dimension tables in a dimensional model are usually wide and contain alot of attributes. If the case is there where one or a few of the attributes are fast changing, then this

Using mini dimension for fast-changing attributes Read More »