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
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 … Continue reading Connecting to SAP BW using Power BI Desktop
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
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
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
Since Power BI does not have a native connector to SAS yet I decided to write this blog and walk you through using R to read data from your *.sas7bdat files. I will assume that the reader does not have R installed so I will walk you through all the steps necessary to get this … Continue reading Reading SAS (*.sas7bdat) Files In Power BI
business intelligist 