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 … Continue reading Analyzing Stock Data in DAX →

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 … Continue reading Reporting Currency in Power BI →

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 … Continue reading Snapshot tables in Power BI →

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 … Continue reading Basket Analysis in Power BI →