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
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
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
EDIT 2020-12-14: the final installment of the three part series on PVM with DAX formulas and the latest video can be found here: https://businessintelligist.com/2020/12/11/dax-for-perfect-price-volume-mix-pvm-calculation-power-bi-tutorial/ EDIT 2020-11-20: the most recent post about this topic, including a video, can be found here:https://businessintelligist.com/2020/11/20/the-definitive-guide-to-price-volume-mix-calculation-pvm-in-power-bi-theory/ EDIT: 202-04-24: I have made some additions to the original post, please see the theory … Continue reading Price Volume Mix Analysis Using Power BI
EDIT: 2021-03-08 - An updated Power BI Desktop File and a video on this topic can be found here: https://businessintelligist.com/2021/03/08/market-basket-analysis-power-bi-dax-tutorial/ 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 … Continue reading Market Basket Analysis using Power BI
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 … Continue reading How to Integrate Flow with Microsoft Azure Data Lake
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
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
This information has been around the blogosphere for a while but I keep forgetting how to find it; I decided to write about it on my blog so that I can easily find it next time I need it. The existing functionality of the Power BI Connector for SAP BW only exposes text values of … Continue reading How to Expose Key Values from SAP BW in Power Query
The Power BI team posted a great article about streaming tweets and sentiment data into Power BI. Unfortunately, the article does not get into the steps necessary to procure and set up Cognitive Services from Microsoft so I figured I would cover these details in this article. If you already have an Azure account, then … Continue reading Microsoft Flow and Cognitive Services
business intelligist 