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: Tutorial
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
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
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
Notebooks in Microsoft Fabric
Want to learn the ins and outs of using Notebook in Microsoft Fabric... you are in the right place. Check out the video where I talk about: Using Notebook across Lakehouses and Workspaces Configuring an environment In-line libraries Virtual tables And more... https://youtu.be/aaiiUyaj46k
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