Have you ever built a stunning Power BI report, only to have your perfect visuals ruined by an ugly date slider? It’s a frustrating problem that can mess with the flow of your report and diminish its usability. But don’t worry—there’s a quick hack to get rid of that slider and make your charts cleaner … Continue reading How to Hack Your Date Dimension in Power BI
Category: Finance
DAX for Time Series Forecasting in Power BI!
In today’s data-driven world, businesses thrive on making informed predictions, and time series forecasting plays a pivotal role in this. With the right tools, you can uncover insights from data trends, helping you forecast future outcomes. If you're ready to dive into this powerful capability using Power BI—without needing to be a data scientist—this free … Continue reading DAX for Time Series Forecasting in Power BI!
Your Best Option for Master Data Management in #PowerBI and #MicrosoftFabric, Editable by Inforiver!
Say goodbye to data headaches while meeting enterprise-grade security and self-service requirements. Check out my latest video for an introduction and in-depth review of this game-changing tool!
DAX for Time Series forecasting – 2 – your questions answered
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
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!
