Skip to content

The BI Journey

My take on the world of Business Intelligence & Business Analytics

  • Home
  • Contact
  • Blog

Month: May 2018

Analyzing Stock Data in DAX

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 →

Jani Zajc Uncategorized Leave a comment May 29, 2018March 20, 2020 3 Minutes

Reporting Currency in Power BI

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 →

Jani Zajc Uncategorized Leave a comment May 23, 2018June 24, 2018 2 Minutes

Snapshot tables 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 →

Jani Zajc Uncategorized 2 Comments May 10, 2018May 10, 2018 2 Minutes

Recent Posts

  • Aggregations in Power BI
  • Non-linear Time Visuals
  • Camel Case Column Renaming – The new Way in #PowerBI #PowerQuery
  • Row Store to Column store… Story
  • Pareto Rule, ABC Class in DAX

Archives

  • April 2020
  • April 2019
  • February 2019
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
Blog at WordPress.com.
  • Follow Following
    • The BI Journey
    • Already have a WordPress.com account? Log in now.
    • The BI Journey
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...