Constant currency analysis is very popular when we need to take out FX rate fluctuations from our analysis. There are many different methodologies that companies used for determining what constant FX rate to apply to the historical values. In our tutorial, we will take a look at the time window for our analysis, figure out … Continue reading Constant Currency Analysis (Power BI DAX Tutorial)
The older and wiser that I get, the more I realize that our framework of values and motivations is often not so much based on our own experiences and learnings but rather on effectiveness of persuasion of individuals who have taken their time and used their skills to instill our values and to create our motivations. You too can learn how to use data to persuade your audience...
EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 In the last post, I talked about flattening parent child hierarchy. Building upon that - the next question is how to make sure that an employee has access to only his/her data and that of the employee(s) … Continue reading Power BI Tutorial: Row Level Security on Parent Child Hierarchy
EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 I have been working with SAP data source lately. And in SAP dimensions, parent-child hierarchy is very common and there is a need to flatten it in Power BI. A common parent child hierarchy is an employee … Continue reading Power BI Tutorial: Flatten Parent Child Hierarchy
Here is a common requirement that I have come across: “I want the Date slicer to automatically select current date without me having to manually change the slicer”. Here is a way to do that. We have a Power BI Desktop report that was created on April 10th 2016. When the report was created, we … Continue reading Power BI Tutorial: Dynamically update Date slicer to show Current Date
In Power BI Desktop, there are multiple options available when using Merge Query feature. This tutorial reviews each of the options. Data for the tutorial can be obtained by downloading Excel file from here . The file has Product sheet which has details of all the products my company sells The file also has a … Continue reading Power BI Desktop : Merge Query Options
In Excel 2016, click on File -> Options -> Add-Ins From the drop down select COM Add-ins and select Go… In COM Add-Ins dialogue, if Power View for Excel is not selected, select the check box and click OK Notice that enabling the Add-In does not provide the ability to create a Power View report … Continue reading Enabling Power View in Excel 2016
Click here to download the data file for this tutorial. We are not always lucky to have our data neatly laid out in rows and columns. Sometimes, our data come in as a formatted report and we need to find a way to massage the data before it can be loaded into a data model. … Continue reading Power BI Tutorial: How to Use Power Query to Load Data from a Formatted Report
Let's take a look at an unfortunately very familiar to most of us business scenario. A patient gets admitted to a hospital, spends several days there and then gets discharged (hopefully feeling much better 🙂 ). In this situation, we have two dates that describe this event, the date of being admitted and the date … Continue reading Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)
I find it interesting that after it's been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to … Continue reading What is Power BI?