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
Category: Tutorial
Are you sure you are using Direct Lake connection ? Here is how to validate
In this video, we'll explore: The key differences between Direct Lake and Direct Query modes How each mode impacts data retrieval and performance The tools you can use to validate if you're using a Direct Lake connection, including Query Analyzer and Profiler By the end of this tutorial, you'll have a clear understanding of which … Continue reading Are you sure you are using Direct Lake connection ? Here is how to validate
What???!!!??? Forecasting with LLM and GenAI!
https://youtu.be/2G4WUV81ExI Today, we're tackling a topic you probably haven't seen before: how to forecast and make predictions in Microsoft Fabric using Generative AI and Large Language Models (LLMs). While most videos focus on LLMs as assistants or copilots, I find that use case uninspiring and soon-to-be commoditized. Instead, I'm focused on logic intelligence—applying GenAI to … Continue reading What???!!!??? Forecasting with LLM and GenAI!
LLM and GenAI in Fabric, no Azure required!
In this video, we’re taking our RAG architecture to intergalactic levels! Building on our previous video (https://youtu.be/oCHinlZRsLU), we’re removing dependencies on PaaS components like Document Intelligence and Azure AI Search. Instead, we’re leveraging LangChain to process PDF documents and using the open-source vector database, Chroma DB, as our vector store. https://youtu.be/jwVOQCUUH1Y this is the relevant … Continue reading LLM and GenAI in Fabric, no Azure required!
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.
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
Copilot in Action – Does it replace web search ?
In the last few months, I have been using with Copilot to help with writing code in Notebooks. And here are some of my findings: Copilot is good with basic code Result is not consistent. I got different answers to the same question... some times a better answer and sometimes not Since it is part … Continue reading Copilot in Action – Does it replace web search ?
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
business intelligist 