So excited for this video, hundreds of hours of work are finally coming together! PVM walk for Revenue has been one of the most popular topics on this blog. Now we have finally figured out how to create a perfect Power BI DAX calculation for PVM or I guess PVCM analysis for Gross Margin. It … Continue reading Price Volume Cost Mix – Gross Margin Analysis!
Category: Microsoft Business Intelligence
Power BI Copilot In Action: Enhancing Analytics with AI?
Is it too early to start a meaningful conversation about #Microsoft #Copilot for #PowerBi? Check out this detailed review video with some insightful food for thought at the end. This video is a must-watch for anyone interested in #salesreporting, #financialanalysis and #financialreporting. Let's #getsmartertogether with #msfabric and #mspowerbi! https://youtu.be/V4_krwqFArg
Is Snowflake One Bad Quarter Away from Being Microsoft Power BI Biggest Threat?
I suspect that many of you have looked at the title of this video and immediately thought that I was just being silly and provocative. And, generally speaking, you would be right as I do enjoy a fair amount of silly and provocation every now and then. However, in this case, even though I do … Continue reading Is Snowflake One Bad Quarter Away from Being Microsoft Power BI Biggest Threat?
Constant Currency Analysis (Power BI DAX Tutorial)
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)
Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)
If you are looking to challenge your DAX skills while trying to figure out how to calculate a Cumulative Discount (or a Cumulative Commission) then this tutorial is for you. https://youtu.be/9hGowlw4YPc A Cumulative discount is calculated by finding the cumulative sales in the specified discount window, and then, using the cumulative sales as the parameter … Continue reading Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)
How to Calculate Revenue and Margin Using Price and Cost History Tables (Power BI DAX Tutorial)
I use Sales data a lot in my tutorials and usually the Sales Fact table will have the following fields in it: DateProductRevenueUnits Along with a bunch of other stuff…. Now, it is actually very common for a company to only provide Units in the Sales Table along with a Price History and/or Cost History … Continue reading How to Calculate Revenue and Margin Using Price and Cost History Tables (Power BI DAX Tutorial)
DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)
EDIT 2021-03-18: I have added two additional buckets for PVM analysis with New Products and Discontinued Products in this new blog post/video. This is the third installment in the series; however, you are not required to read the previous two to follow along. Part I - I frame up the basic concept of analysis in … Continue reading DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)
Why Microsoft Must Double Its Power BI Investment Now That Salesforce Bought Slack
Should Microsoft be worried that Salesforce has just acquired Slack? In my opinion – YES, in fact it should be so worried that it must double its investments in Power BI.
Power BI Smart Narrative Visual Review – Is It Ready for Primetime???
Lots of good announcements for Power BI happened this week. One piece of technology I was looking forward to was Smart Narratives visual. You will have to download the latest version of Power BI desktop and then go to Options and enable it there. After that you can add a Smart Narrative visual by either … Continue reading Power BI Smart Narrative Visual Review – Is It Ready for Primetime???
Optimizing Azure Analysis Services Partitions for Azure Data Warehouse External Tables
Recently, I had a chance to work with Azure Analysis Services (AS) sourcing data from Azure Data Warehouse (DW) external tables. Optimizing the processing of the Azure Analysis Services partitions to use with the Azure DW external tables is a bit different from working with the regular (physical) data tables, and I will discuss the … Continue reading Optimizing Azure Analysis Services Partitions for Azure Data Warehouse External Tables