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!
Category: Power BI
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
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
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 ?
How to implement #RAG Architecture with Azure #OpenAI in Microsoft #Fabric
Ready to take your Business Intelligence and Data Engineering skills to the next level with Azure OpenAI and Microsoft Fabric? Learn how to implement hashtag#RAG (Retrieval-Augmented Generation) Architecture with these powerful tools in my latest video. By securely bringing your corporate data into the fold, you can unlock the full potential of GenAI. Check out the video now to get started. hashtag#Azure hashtag#OpenAI hashtag#LLM hashtag#microsoftfabric hashtag#dataengineering hashtag#datascience hashtag#AI hashtag#genai hashtag#powerbi hashtag#getsmartertogether hashtag#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
Data Orchestration in Microsoft Fabric
In this week's video I answer the following questions: - Can I run Dataflow Gen2 using Pipeliine ? - Do all the artifacts have to exist in the same workspace as the Pipeline ? - Can I have nested Pipelines ? - Is Data Pipeline only way to orchestrate data in Fabric ? Hint:: runMultiple() … Continue reading Data Orchestration in Microsoft Fabric
business intelligist 