Embedding PowerApps in Power BI Dashboards

It's no secret that PowerApps and Power BI are related or so you might think considering that both products have the word "power" in their names. Although Microsoft is yet to officially introduce the big picture of how Power BI, Power Apps and Flow will come together, having a shared gateway infrastructure between the three … Continue reading Embedding PowerApps in Power BI Dashboards

Power BI and SAP – What Works and What Doesn’t

I run many workshops focused on integration of Microsoft Analytics and SAP. This is not an easy topic to cover due to complexities of the SAP landscape and also because Microsoft Analytics has many moving parts both with respect to its on premise and cloud components. In this article, I will just focus on Power … Continue reading Power BI and SAP – What Works and What Doesn’t

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

PowerApps – Navigate between screens

An app typically has more than one screen and we need the capability to navigate it. PowerApps has two functions, Navigate and Back that helps with navigation. Let's check out how these functions work. Download the App from here. Select Next button on the WOD screen. From the properties section pick OnSelect. Notice the formula: Navigate(WODDetails,ScreenTransition.Fade) Here is what … Continue reading PowerApps – Navigate between screens

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