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
Month: March 2017
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
How to Integrate Flow with Microsoft Azure Data Lake
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
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