Category: Uncategorized

I recently came across a similar pattern, transforming a selection of numbers into a text of numbers sequences. I found the pattern intriguing, partly because I had been solving a similar patterns in SQL working as a data warehouse engineer. And there I knew a ‘special trick’ or optimization technique to solve this kind of…

Today we are going to talk about the analysis of stock data. Stock data is a specific sort of time series data. And it is special in that we observe the current price of a stock share. It is like units in stock, or the bank account balance… It always has the (overall) value, not…

Reporting in a different currency than the given data is a common pattern in BI. Or just the given data is comprised from different values in more currencies and the client want a consolidated view of the amounts. There is more than one way to tackle this pattern. Today we’ll look at two ways to…

Creating snapshot table in BI is always a non-trivial task. In SQL Server 2012 and on creating snapshot tables is little more straightforward. Using the so-called window functions, the code is less verbose thus for the developer to write and more importantly, the operation is more efficient thus faster. Creating snapshot tables in SQL Server…

Aaa, give me some Sales data… Some business requirements sometimes … “require” more than an analytical tool of choice can allow us to create. Let me explain. In the past something like this was the area of Data Mining. (Data Mining is an somewhat retired expression, nowadays this is called more like Data Science.) In…