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
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
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
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
Traditionally, when we do variance analysis, we compare the actual value of the metric being measured to its target value in either absolute or relative terms. For example, if I were to compare current year sales (Sales CY) to prior year sales (Sales PY) I might want to create a Sales YoY calculation as well
I am on a CrossFit high, with the Open just concluded and Regionals about to begin… So I am going to use some of my favorite Hero work outs (WOD) as a sample for this tutorial. There are scenarios where we want to display content based on the user’s selection. Here is how to do it.
It’s been almost two years since I posted about the CONCATENATEX() DAX function here. At the end of that post I promised to publish a tutorial on how one might do Market Basket analysis using this function in Power BI. Well, I try to deliver on my promises even though it might take me
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.
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
I really like Flow’s ability to listen to Twitter. Some time ago, I set up a flow to listen to anything related to my Twitter handle, BizIntelligist. The initial design would just capture tweets that I deemed interesting and email them to me. Then, the cognitive services became available, so I added a step to