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
Category: Tutorial
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
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.
Adding Weather Forecast in Power BI using Azure Map
Azure Maps is a Microsoft technology that has a lot of cool features. Somewhat unexpectedly I discovered that along with purely mapping stuff it also provides functionality to acquire weather forecast data using REST API as outlined here. The detailed process is detailed in the video below, but I will highlight the key steps in … Continue reading Adding Weather Forecast in Power BI using Azure Map
How to Display Multiple Rows in a Single Cell of a Matrix or a Table
How can I condense multiple rows into a single cell in a Matrix or a Table? https://youtu.be/bjCclP7aTCQ Obviously, it is easy to display all details like you see below: But what if for every product I just want to know what countries it is selling in and what channels are used? Like how it is … Continue reading How to Display Multiple Rows in a Single Cell of a Matrix or a Table
How to Hack RLS to Make RANK() Work on Entire Dataset
Let's say you are building a dashboard for the Sales team and have the following requirements: Each sales person should have access to only their territory - Ok this is easy enough. We can achieve this using RLS. Rank the territories based on revenue. Sales person should be able to view the ranking of their … Continue reading How to Hack RLS to Make RANK() Work on Entire Dataset
business intelligist 