You guys sure know how to find me! My last video on Time Series forecasting in #DAX and #PowerBI generated a ton of questions, so instead of me trying to reply over LinkedIn, Twitter, YouTube and email, I just recorded this video
Category: DAX
DAX Calculation for Time Series Forecast
Do you love the forecasting feature of Power BI's line charts but wish you could have more control of formatting? Need to break your forecast down by products and customers? I got you covered. In my latest video, I walk you through the DAX calculation for Time Series Forecast. In this video, you'll learn how to: Implement time series analysis using DAX in Power BI. Create a forecast measures from scratch. Break down data into trend and seasonality components for more detailed insights. #PowerBI #DAX #TimeSeriesAnalysis #DataAnalytics #Forecasting #BusinessIntelligence #obviEnce
The Basics of Promotion Effectiveness and Category Management #powerbi #msfabric #salesanalysis
STILL promoting your products at a loss?!? Time to put #PowerBI to work and find out how to #getsmarter with your #data. I introduce the basics of Promotion Effectiveness and Category Management in my latest video. #SalesStrategy #Microsoft #Fabric #FinancialReporting #obviEnce #Planning #Forecasting
How to create a stacked chart with Better or Worse indicators
Every inch of your dashboard real estate is precious. That’s why it has to be packed with as much insight as possible. I almost never use stacked charts because they don't make it easy to add useful context for each data point. Well, until now! In this video, I talk about how you can add a Better/Worse indicator to turn your stacked charts into an insight superpower!
Tutorial: DAX to remove pesky blanks from Parent Child hierarchy in charts and tables.
Should core PowerBI visuals natively support Parent Child hierarchies? Yes... do they? No... We have to deal with blanks and repeats and all kinds of things to make our charts and tables look nice. Well, in this video I offer you my approach to clean up your visualizations so they look exactly the way you want them to look.
Will Copilot in PowerBI Desktop ever be able to help you?
Who is going to win in the upcoming AI vendors showdown? My guess is it will be whoever can figure out how to make AI understand the intricacies of various business domains, like sales and supply chain, for example. So this is the context that I use to understand the effectiveness and usefulness of #Copilots in #PowerBI and #MSFabric. How good is it, and how would we know? Who is it built for? These are some of the questions that I am trying to tackle in this video.
Price Volume Cost Mix – Gross Margin Analysis!
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!
Performance Flow by xVIZ is the best visual for Parent Child hierarchies In Power BI
What is one thing that is harder than modeling complex hierarchies and relationships in our data? Well, having to visualize it of course! Luckily, xVIZ Performance Flow might be the best tool to make it easier for us. It's an incredibly mature visual with lots of features and customization options. Please check out my latest video for a quick review and tutorial. #micorsoft #mspowerbi #financialanalysis #financialreporting #getsmartertogether #obvience
How to generate Business Friendly #PowerBI Data Dictionary using #OpenAI #SemanticLink #msfabric
Learn how to generate a business-friendly PowerBI data dictionary using OpenAI, SemanticLink, and MSFabric! In this video, we explore how to incorporate Azure OpenAI into the world of Business Intelligence and Microsoft Fabric. We use the Semantic Link library to create our data dictionary. Then we enrich it using Azure OpenAI to derive business audience-friendly descriptions from our DAX measure definitions. Check out the video to learn more! hashtag#PowerBI hashtag#OpenAI hashtag#SemanticLink hashtag#MSFabric
Streak Analysis – From DAX to Reporting
If you are trying to manage customer or employee engagement, but have no quantitative understanding of impressions, engagements, and conversions, then you have zero grasp of your reach. If basics are covered, you should focus on the quality of the engagement. Streak Analysis could be very useful to understand patterns of engagement. Learn how to create the DAX calculations and use them in a report in this video.
business intelligist 