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 →