Price Volume Mix Analysis Using Power BI

I have made some additions to the original post, please see the theory behind the calculations in the link below: https://businessintelligist.com/2020/04/24/price-volume-mix-pvm-for-revenue-variance-analysis Also, if you would like to know how to calculate PVM for Gross Margin analysis, you can follow this link: https://businessintelligist.com/2020/04/26/price-volume-mix-pvm-for-gross-margin-variance-analysis I have also recorded a video about the subject here: The original post … Continue reading Price Volume Mix Analysis Using Power BI

Connecting to SAP BW using Power BI Desktop

Today I connected to SAP BW using the connector available in Power BI Desktop. Following link does a good job explaining the steps: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sap-bw-connector/ Ran into a road block while installing SAP Netweaver RFC SDK library. With the help of bases team I downloaded SAP Netweaver SDK library. However there is no explanation as to where/how this … Continue reading Connecting to SAP BW using Power BI Desktop

PowerApps Common Data Service Connector

Here is how to get PowerApps Common Data Service Connector working. Note: You need to have Admin rights to Enable Power BI Integration Login to https://web.powerapps.com On the top right corner click on Settings (gear icon) Select Admin Center Select the environment you want to enable Select Database from the top menu Select Enable Now we … Continue reading PowerApps Common Data Service Connector

Power BI Tutorial: Dynamically update Date slicer to show Current Date

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

Power BI Desktop: Interaction between Visuals

November release of Power BI Desktop delivered a highly requested feature – ability to configure interaction between visual elements in a report. Here is a quick tutorial of the configuration options. I have a report with 4 visual elements, a card, a clustered column chart, a bar chart and a donut chart. By default, when … Continue reading Power BI Desktop: Interaction between Visuals