So excited for this video, hundreds of hours of work are finally coming together! PVM walk for Revenue has been one of the most popular topics on this blog. Now we have finally figured out how to create a perfect Power BI DAX calculation for PVM or I guess PVCM analysis for Gross Margin. It … Continue reading Price Volume Cost Mix – Gross Margin Analysis!
Category: business intelligence
Are we at the tipping point?
Are you STILL one of the people who have not yet realized that the world of BI is about to get turned upside down with GenAI and LLMs? Well, you can keep basking in your ignorance, but for the rest of us, we need to figure out how to stay ahead of where this is going and how to not be left behind. With my latest video/tutorial, we're stepping into the future with LangChain LLM Agents, and how they're revolutionizing the way we interact with Power BI semantic models within Microsoft Fabric. Forget the traditional ways of data processing and get ready for a mind-blowing journey into AI-driven analytics. You can query your Power BI datasets/semantic models and potentially replace lines of code with just a few simple prompts. hashtag#azure hashtag#OpenAI hashtag#LangChain hashtag#PowerBI hashtag#MicrosoftFabric hashtag#AI hashtag#BusinessIntelligence hashtag#Innovation hashtag#BI hashtag#datascience hashtag#obvience hashtag#getsmartertogether
Data Wrangler – Visual Editor for Notebooks
Are you new to writing PySpark code in Notebooks, do you need a code snippet to get you jump started or you are some one who likes a visual editor ? If yes, Data Wrangler is the tool you are looking for. Check out the video for more details. https://youtu.be/xxh_4ZIIf9M
Is Data Activator ready for Prime Time ?
I have been working with Data Activator for a few months now. I have seen it evolve (and it is evolving fast), but is it ready for Prime Time ? Check out this video where I share my thoughts: Walk through the functionality. Talk about the pros and cons. Features I would like to see … Continue reading Is Data Activator ready for Prime Time ?
Power BI Copilot In Action: Enhancing Analytics with AI?
Is it too early to start a meaningful conversation about #Microsoft #Copilot for #PowerBi? Check out this detailed review video with some insightful food for thought at the end. This video is a must-watch for anyone interested in #salesreporting, #financialanalysis and #financialreporting. Let's #getsmartertogether with #msfabric and #mspowerbi! https://youtu.be/V4_krwqFArg
Forecasting Measure in Power BI
In this lab we will be implementing a forecasting measure using DAX. We will not be generating a forecast data set, rather, we will create a measure that will look at the actuals from the past to forecast what will happen in the future. We will be using a CDC data set of US Deaths. … Continue reading Forecasting Measure in Power BI
Is Snowflake One Bad Quarter Away from Being Microsoft Power BI Biggest Threat?
I suspect that many of you have looked at the title of this video and immediately thought that I was just being silly and provocative. And, generally speaking, you would be right as I do enjoy a fair amount of silly and provocation every now and then. However, in this case, even though I do … Continue reading Is Snowflake One Bad Quarter Away from Being Microsoft Power BI Biggest Threat?
What Kellogg Professor Got Wrong about Effectiveness and Honesty in Data Visualizations
Steven Franconeri, a Kellogg School of Management professor, has written a good article "4 keys to Effective – and Honest – Data Visualizations". I thought that he made some solid points; however, I strongly disagree with his opinion about what makes a chart honest or dishonest. https://youtu.be/E6A0cry7PUw As you look at the global temperature trend … Continue reading What Kellogg Professor Got Wrong about Effectiveness and Honesty in Data Visualizations
Power BI Best Practices Analyzer in Tabular Editor
Wanted to do a quick video on how to use Power BI Best Practices Analyzer using Tabular Editor. There was a great blog post on it here: https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/ that covered a lot of details on what best practices were there to be aware of as well as the tool itself. However, the article seemed to … Continue reading Power BI Best Practices Analyzer in Tabular Editor
Progressive Discount (Tax or Commission) Calculation (Power BI DAX Tutorial)
I have to warn you, this is NOT a level 100 or even 200 tutorial. If you decided to proceed, that you absolutely positively have to get that progressive calculation work and I will have to assume that your DAX is pretty good, otherwise you would not be even attempting to tackle this problem. Also, … Continue reading Progressive Discount (Tax or Commission) Calculation (Power BI DAX Tutorial)