Application Lifecycle Management (ALM) and Power BI

Wikipedia defines Application Lifecycle Management as a set of pre-defined processes that start somewhere in the business as an idea, a need, a challenge or a risk and then pass through different development phases such as requirements definition, design, development, testing, deployment, release and maintenance spanning across an entire lifecycle of a product. As more … Continue reading Application Lifecycle Management (ALM) and Power BI

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

Analyze Weather in Power BI

obviEnce published it's first Services App on Power BI. The app provides temperature and precipitation trends over the last 30 days across USA and Canada. The app will enhance your dataset by allowing you to analyze impact of weather on your business. Here is a snapshot of the dashboard.

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

The Long-awaited Matrix Control is Released for Power BI… and few other tidbits

Yesterday was a big day for Power BI – the long-awaited Matrix visual is now finally available. Sure, it's still in beta and yes, there are still some features lacking (formatting, formatting, formatting…), and yes, there are bugs (try to drill down on columns for example), BUT… this is a very significant update for Power … Continue reading The Long-awaited Matrix Control is Released for Power BI… and few other tidbits

Fact Checking the Gartner Magic Quadrant for Business Intelligence Report

Power BI was ranked very well by Garner in its annual Magic Quadrant for Business Intelligence and Analytics report. Most people never read the report because the only thing that really matters to them is the picture above. However, if you do bother to read it you will find a few statements about Power BI … Continue reading Fact Checking the Gartner Magic Quadrant for Business Intelligence Report

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

Working with Inline Tables and Using IN Operator in Filter

It's is often handy to be able to define a table in line with your calculation. Apparently, you can do it in DAX using the following syntax: { value1, value1, value3} The statement above creates a table that can be used with a DAX function that expects a table as a parameter. Example: {1, 2, … Continue reading Working with Inline Tables and Using IN Operator in Filter